ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

92 rows where cases = 5017 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: county, fips

Link rowid date ▲ county state fips cases deaths
2500656 2500656 2022-05-13 Mason Kentucky 21161 5017 105
2501326 2501326 2022-05-13 Saunders Nebraska 31155 5017 30
2497398 2497398 2022-05-12 Mason Kentucky 21161 5017 105
2494140 2494140 2022-05-11 Mason Kentucky 21161 5017 105
2490882 2490882 2022-05-10 Mason Kentucky 21161 5017 105
2487625 2487625 2022-05-09 Mason Kentucky 21161 5017 105
2421158 2421158 2022-04-18 King George Virginia 51099 5017 39
2374850 2374850 2022-04-04 Union Oregon 41061 5017 76
2351014 2351014 2022-03-28 Sagadahoc Maine 23023 5017 29
2347761 2347761 2022-03-27 Sagadahoc Maine 23023 5017 29
2344508 2344508 2022-03-26 Sagadahoc Maine 23023 5017 29
2281997 2281997 2022-03-07 McDuffie Georgia 13189 5017 93
2278744 2278744 2022-03-06 McDuffie Georgia 13189 5017 93
2275491 2275491 2022-03-05 McDuffie Georgia 13189 5017 93
2272238 2272238 2022-03-04 McDuffie Georgia 13189 5017 93
2268986 2268986 2022-03-03 McDuffie Georgia 13189 5017 93
2266009 2266009 2022-03-02 Orange Indiana 18117 5017 94
2262758 2262758 2022-03-01 Orange Indiana 18117 5017 93
2259507 2259507 2022-02-28 Orange Indiana 18117 5017 93
2226240 2226240 2022-02-18 Butler Alabama 1013 5017 114
2222853 2222853 2022-02-16 Lewis West Virginia 54041 5017 75
2216491 2216491 2022-02-15 Cherokee Alabama 1019 5017 74
2214924 2214924 2022-02-14 Dawson Nebraska 31047 5017 42
2210423 2210423 2022-02-13 Fannin Georgia 13111 5017 131
2207170 2207170 2022-02-12 Fannin Georgia 13111 5017 131
2203917 2203917 2022-02-11 Fannin Georgia 13111 5017 131
2164596 2164596 2022-01-30 Ouachita Arkansas 5103 5017 92
2161341 2161341 2022-01-29 Ouachita Arkansas 5103 5017 92
2158085 2158085 2022-01-28 Ouachita Arkansas 5103 5017 92
2155861 2155861 2022-01-27 Hancock Maine 23009 5017 68
2135258 2135258 2022-01-21 Arkansas Arkansas 5001 5017 67
2127739 2127739 2022-01-18 Cayey Puerto Rico 72035 5017  
2105666 2105666 2022-01-11 Salem city Virginia 51775 5017 85
2037422 2037422 2021-12-21 Wythe Virginia 51197 5017 116
1905642 1905642 2021-11-11 Mecosta Michigan 26107 5017 53
1902393 1902393 2021-11-10 Mecosta Michigan 26107 5017 53
1879017 1879017 2021-11-03 Montgomery Illinois 17135 5017 89
1881426 1881426 2021-11-03 Kittitas Washington 53037 5017 56
1877176 1877176 2021-11-02 Coshocton Ohio 39031 5017 90
1877797 1877797 2021-11-02 Fannin Texas 48147 5017 151
1863331 1863331 2021-10-29 Worcester Maryland 24047 5017 119
1791649 1791649 2021-10-07 Clay Kentucky 21051 5017 56
1788392 1788392 2021-10-06 Calloway Kentucky 21035 5017 60
1762932 1762932 2021-09-28 Lawrence Missouri 29109 5017 104
1683022 1683022 2021-09-03 Washington Texas 48477 5017 104
1656030 1656030 2021-08-26 Clinton New York 36019 5017 33
1608941 1608941 2021-08-12 Tuolumne California 6109 5017 74
1599606 1599606 2021-08-09 Livingston Illinois 17105 5017 107
1579453 1579453 2021-08-02 Sweetwater Wyoming 56037 5017 44
1555170 1555170 2021-07-26 Dodge Nebraska 31053 5017 83
1531300 1531300 2021-07-19 Maui Hawaii 15009 5017 57
1486379 1486379 2021-07-05 Nelson Kentucky 21179 5017 62
1483133 1483133 2021-07-04 Nelson Kentucky 21179 5017 62
1479886 1479886 2021-07-03 Nelson Kentucky 21179 5017 62
1476640 1476640 2021-07-02 Nelson Kentucky 21179 5017 62
1470148 1470148 2021-06-30 Nelson Kentucky 21179 5017 62
1459127 1459127 2021-06-26 Washington Virginia 51191 5017 110
1425686 1425686 2021-06-16 Auglaize Ohio 39011 5017 87
1342971 1342971 2021-05-22 Murray Georgia 13213 5017 88
1330124 1330124 2021-05-18 Henry Illinois 17073 5017 96
1325242 1325242 2021-05-16 Linn Oregon 41043 5017 68
1315912 1315912 2021-05-13 Chambers Texas 48071 5017 49
1309054 1309054 2021-05-11 Huntingdon Pennsylvania 42061 5017 129
1280094 1280094 2021-05-02 Fayette Tennessee 47047 5017 76
1280712 1280712 2021-05-02 Dunn Wisconsin 55033 5017 32
1276847 1276847 2021-05-01 Fayette Tennessee 47047 5017 76
1273600 1273600 2021-04-30 Fayette Tennessee 47047 5017 76
1120318 1120318 2021-03-14 Sullivan New York 36105 5017 62
1093791 1093791 2021-03-06 Chisago Minnesota 27025 5017 45
1073626 1073626 2021-02-28 Knox Illinois 17095 5017 163
1070380 1070380 2021-02-27 Knox Illinois 17095 5017 162
1061259 1061259 2021-02-24 Clinton Michigan 26037 5017 70
1047279 1047279 2021-02-20 Garfield Colorado 8045 5017 38
1032728 1032728 2021-02-15 Granville North Carolina 37077 5017 74
1010533 1010533 2021-02-08 Brown South Dakota 46013 5017 79
1008030 1008030 2021-02-07 Shawano Wisconsin 55115 5017 80
997632 997632 2021-02-04 Dyer Tennessee 47045 5017 90
981010 981010 2021-01-30 Cherokee Oklahoma 40021 5017 31
977096 977096 2021-01-29 Washington Mississippi 28151 5017 125
929463 929463 2021-01-14 Carter Tennessee 47019 5017 108
900575 900575 2021-01-05 Val Verde Texas 48465 5017 153
843140 843140 2020-12-19 Madison Idaho 16065 5017 10
827014 827014 2020-12-14 Vermilion Illinois 17183 5017 74
825214 825214 2020-12-13 Tuscarawas Ohio 39157 5017 97
768966 768966 2020-11-26 Kenton Kentucky 21117 5017 63
765720 765720 2020-11-25 Kenton Kentucky 21117 5017 63
615186 615186 2020-10-09 Norfolk city Virginia 51710 5017 79
517419 517419 2020-09-09 Beaufort South Carolina 45013 5017 73
376744 376744 2020-07-28 Hall Georgia 13139 5017 71
372101 372101 2020-07-26 Berks Pennsylvania 42011 5017 362
304618 304618 2020-07-05 Somerset New Jersey 34035 5017 530
47286 47286 2020-04-10 Passaic New Jersey 34031 5017 101

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);