us-counties

Table actions
Big Local News snapshots this data daily from https://github.com/nytimes/covid-19-data. This is time series data for U.S. confirmed cases and deaths down to the county level. There are three CSV files released once a day: national-level data, state-level data and county-level data. Each file contains date, county/state name, FIPS code, number of confirmed cases, number of deaths going back to January 21. All data is gathered by New York Times reporters from state and local health departments or official government announcements. The data is updated once a day in the morning, usually around 8 a.m. EDT, with a full day’s worth of data from the day before. Please cite the New York Times as described in the README and check terms of use.

Data source: Big Local News · About: big-local-datasette

1,076,224 rows sorted by cases descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid date county state fips cases ▲ deaths
1073183 1073183 2021-02-28 Los Angeles California 6037 1192559 21435
1069937 1069937 2021-02-27 Los Angeles California 6037 1191521 21328
1066692 1066692 2021-02-26 Los Angeles California 6037 1189859 21241
1063447 1063447 2021-02-25 Los Angeles California 6037 1188101 21102
1060202 1060202 2021-02-24 Los Angeles California 6037 1186074 20987
1056956 1056956 2021-02-23 Los Angeles California 6037 1183969 20057
1053710 1053710 2021-02-22 Los Angeles California 6037 1181994 19904
1050463 1050463 2021-02-21 Los Angeles California 6037 1181060 19885
1047216 1047216 2021-02-20 Los Angeles California 6037 1179633 19793
1043971 1043971 2021-02-19 Los Angeles California 6037 1177340 19662
1040726 1040726 2021-02-18 Los Angeles California 6037 1174897 19514
1037481 1037481 2021-02-17 Los Angeles California 6037 1172221 19368
1034236 1034236 2021-02-16 Los Angeles California 6037 1170100 19215
1030990 1030990 2021-02-15 Los Angeles California 6037 1168904 19095
1027743 1027743 2021-02-14 Los Angeles California 6037 1167074 19066
1024498 1024498 2021-02-13 Los Angeles California 6037 1165294 18984
1021253 1021253 2021-02-12 Los Angeles California 6037 1162294 18789
1018008 1018008 2021-02-11 Los Angeles California 6037 1159135 18658
1014763 1014763 2021-02-10 Los Angeles California 6037 1155821 18500
1011518 1011518 2021-02-09 Los Angeles California 6037 1152740 18360
1008272 1008272 2021-02-08 Los Angeles California 6037 1149565 18135
1005026 1005026 2021-02-07 Los Angeles California 6037 1146951 18044
1001780 1001780 2021-02-06 Los Angeles California 6037 1143917 17955
998534 998534 2021-02-05 Los Angeles California 6037 1139256 17764
995288 995288 2021-02-04 Los Angeles California 6037 1134820 17539
992042 992042 2021-02-03 Los Angeles California 6037 1129957 17308
988796 988796 2021-02-02 Los Angeles California 6037 1125034 17057
985549 985549 2021-02-01 Los Angeles California 6037 1121349 16854
982302 982302 2021-01-31 Los Angeles California 6037 1117346 16770
979056 979056 2021-01-30 Los Angeles California 6037 1111543 16647
975811 975811 2021-01-29 Los Angeles California 6037 1104843 16332
972566 972566 2021-01-28 Los Angeles California 6037 1098363 16107
969321 969321 2021-01-27 Los Angeles California 6037 1092134 15897
966077 966077 2021-01-26 Los Angeles California 6037 1085466 15592
962832 962832 2021-01-25 Los Angeles California 6037 1079818 15303
959587 959587 2021-01-24 Los Angeles California 6037 1073533 15260
956341 956341 2021-01-23 Los Angeles California 6037 1065309 15162
953096 953096 2021-01-22 Los Angeles California 6037 1055214 14894
949851 949851 2021-01-21 Los Angeles California 6037 1046424 14641
946605 946605 2021-01-20 Los Angeles California 6037 1038495 14384
943358 943358 2021-01-19 Los Angeles California 6037 1032277 14122
940113 940113 2021-01-18 Los Angeles California 6037 1024592 13936
936868 936868 2021-01-17 Los Angeles California 6037 1015063 13848
933623 933623 2021-01-16 Los Angeles California 6037 1004322 13741
930378 930378 2021-01-15 Los Angeles California 6037 990326 13489
927133 927133 2021-01-14 Los Angeles California 6037 975693 13234
923887 923887 2021-01-13 Los Angeles California 6037 958891 12955
920642 920642 2021-01-12 Los Angeles California 6037 944713 12674
917397 917397 2021-01-11 Los Angeles California 6037 933083 12387
914152 914152 2021-01-10 Los Angeles California 6037 920560 12250
910907 910907 2021-01-09 Los Angeles California 6037 906554 12084
907662 907662 2021-01-08 Los Angeles California 6037 889787 11863
904416 904416 2021-01-07 Los Angeles California 6037 871749 11545
901171 901171 2021-01-06 Los Angeles California 6037 852510 11328
897926 897926 2021-01-05 Los Angeles California 6037 840956 11071
894681 894681 2021-01-04 Los Angeles California 6037 827843 10850
891434 891434 2021-01-03 Los Angeles California 6037 818959 10773
888187 888187 2021-01-02 Los Angeles California 6037 806523 10682
884942 884942 2021-01-01 Los Angeles California 6037 790895 10552
881697 881697 2020-12-31 Los Angeles California 6037 770915 10345
878452 878452 2020-12-30 Los Angeles California 6037 756412 10056
875207 875207 2020-12-29 Los Angeles California 6037 746381 9782
871962 871962 2020-12-28 Los Angeles California 6037 733612 9555
1074853 1074853 2021-02-28 New York City New York   725155 29332
1071607 1071607 2021-02-27 New York City New York   720951 29253
868717 868717 2020-12-27 Los Angeles California 6037 720099 9482
1068361 1068361 2021-02-26 New York City New York   716678 29173
1065116 1065116 2021-02-25 New York City New York   712389 29088
1061872 1061872 2021-02-24 New York City New York   707929 29025
865472 865472 2020-12-26 Los Angeles California 6037 706712 9438
1058626 1058626 2021-02-23 New York City New York   704616 28954
1055380 1055380 2021-02-22 New York City New York   700815 28888
1052134 1052134 2021-02-21 New York City New York   697306 28824
1048887 1048887 2021-02-20 New York City New York   694295 28748
1045640 1045640 2021-02-19 New York City New York   689599 28686
1042395 1042395 2021-02-18 New York City New York   684864 28590
1039150 1039150 2021-02-17 New York City New York   678638 28493
858982 858982 2020-12-24 Los Angeles California 6037 677538 9299
862227 862227 2020-12-25 Los Angeles California 6037 677538 9299
1035905 1035905 2021-02-16 New York City New York   675727 28428
1032660 1032660 2021-02-15 New York City New York   672071 28341
1029414 1029414 2021-02-14 New York City New York   668443 28270
1026167 1026167 2021-02-13 New York City New York   664307 28193
855737 855737 2020-12-23 Los Angeles California 6037 664193 9153
1022922 1022922 2021-02-12 New York City New York   659734 28094
1019677 1019677 2021-02-11 New York City New York   655228 28021
1016432 1016432 2021-02-10 New York City New York   650123 27949
852492 852492 2020-12-22 Los Angeles California 6037 647766 9016
1013187 1013187 2021-02-09 New York City New York   647322 27856
1009942 1009942 2021-02-08 New York City New York   642557 27768
1006696 1006696 2021-02-07 New York City New York   637486 27705
849247 849247 2020-12-21 Los Angeles California 6037 635058 8931
1003450 1003450 2021-02-06 New York City New York   632306 27609
1000204 1000204 2021-02-05 New York City New York   626716 27506
846002 846002 2020-12-20 Los Angeles California 6037 623875 8875
996958 996958 2021-02-04 New York City New York   623713 27428
993712 993712 2021-02-03 New York City New York   621218 27354
990466 990466 2021-02-02 New York City New York   617406 27298
987220 987220 2021-02-01 New York City New York   613480 27226
842756 842756 2020-12-19 Los Angeles California 6037 610562 8817

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us-counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);