ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where cases = 4945 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 9
- Georgia 8
- Oklahoma 8
- Texas 7
- Louisiana 6
- New York 5
- Illinois 4
- Minnesota 4
- Ohio 4
- Puerto Rico 4
- Nebraska 3
- North Dakota 3
- Arkansas 2
- Indiana 2
- Michigan 2
- Missouri 2
- North Carolina 2
- South Carolina 2
- West Virginia 2
- Wisconsin 2
- Alabama 1
- Arizona 1
- California 1
- Colorado 1
- Florida 1
- Iowa 1
- Kentucky 1
- Maine 1
- Maryland 1
- Montana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492763 | 2492763 | 2022-05-10 | Colonial Heights city | Virginia | 51570 | 4945 | 97 |
2489340 | 2489340 | 2022-05-09 | Milam | Texas | 48331 | 4945 | 102 |
2335129 | 2335129 | 2022-03-23 | Perry | Missouri | 29157 | 4945 | 45 |
2315922 | 2315922 | 2022-03-17 | Schoharie | New York | 36095 | 4945 | 34 |
2313166 | 2313166 | 2022-03-16 | Naranjito | Puerto Rico | 72105 | 4945 | |
2286378 | 2286378 | 2022-03-08 | Big Horn | Montana | 30003 | 4945 | 92 |
2225350 | 2225350 | 2022-02-17 | Hatillo | Puerto Rico | 72065 | 4945 | |
2220925 | 2220925 | 2022-02-16 | Knox | Maine | 23013 | 4945 | 22 |
2213752 | 2213752 | 2022-02-14 | Tattnall | Georgia | 13267 | 4945 | 124 |
2210452 | 2210452 | 2022-02-13 | Jones | Georgia | 13169 | 4945 | 104 |
2207199 | 2207199 | 2022-02-12 | Jones | Georgia | 13169 | 4945 | 104 |
2203946 | 2203946 | 2022-02-11 | Jones | Georgia | 13169 | 4945 | 104 |
2191593 | 2191593 | 2022-02-07 | Concordia | Louisiana | 22029 | 4945 | 88 |
2177159 | 2177159 | 2022-02-02 | Dinwiddie | Virginia | 51053 | 4945 | 64 |
2171066 | 2171066 | 2022-02-01 | Columbia | Arkansas | 5027 | 4945 | 77 |
2163558 | 2163558 | 2022-01-29 | Las Piedras | Puerto Rico | 72085 | 4945 | |
2151824 | 2151824 | 2022-01-26 | Burke | Georgia | 13033 | 4945 | 89 |
2134266 | 2134266 | 2022-01-20 | Juana Diaz | Puerto Rico | 72075 | 4945 | |
2129710 | 2129710 | 2022-01-19 | Letcher | Kentucky | 21133 | 4945 | 87 |
2121885 | 2121885 | 2022-01-16 | Louisa | Virginia | 51109 | 4945 | 53 |
2118633 | 2118633 | 2022-01-15 | Louisa | Virginia | 51109 | 4945 | 53 |
2115381 | 2115381 | 2022-01-14 | Louisa | Virginia | 51109 | 4945 | 53 |
2074505 | 2074505 | 2022-01-02 | Franklin | Louisiana | 22041 | 4945 | 144 |
2071254 | 2071254 | 2022-01-01 | Franklin | Louisiana | 22041 | 4945 | 144 |
2068003 | 2068003 | 2021-12-31 | Franklin | Louisiana | 22041 | 4945 | 144 |
2064752 | 2064752 | 2021-12-30 | Franklin | Louisiana | 22041 | 4945 | 144 |
2031630 | 2031630 | 2021-12-20 | Stephens | Georgia | 13257 | 4945 | 123 |
2032448 | 2032448 | 2021-12-20 | Brown | Minnesota | 27015 | 4945 | 65 |
1982959 | 1982959 | 2021-12-05 | Bureau | Illinois | 17011 | 4945 | 111 |
1979709 | 1979709 | 2021-12-04 | Bureau | Illinois | 17011 | 4945 | 111 |
1981154 | 1981154 | 2021-12-04 | Stutsman | North Dakota | 38093 | 4945 | 92 |
1976459 | 1976459 | 2021-12-03 | Bureau | Illinois | 17011 | 4945 | 111 |
1964189 | 1964189 | 2021-11-29 | Cass | Minnesota | 27021 | 4945 | 53 |
1809298 | 1809298 | 2021-10-12 | Clarendon | South Carolina | 45027 | 4945 | 135 |
1748195 | 1748195 | 2021-09-23 | York | Virginia | 51199 | 4945 | 65 |
1721247 | 1721247 | 2021-09-15 | Logan | Ohio | 39091 | 4945 | 82 |
1695028 | 1695028 | 2021-09-07 | Livingston | New York | 36051 | 4945 | 62 |
1667846 | 1667846 | 2021-08-30 | Randolph | Illinois | 17157 | 4945 | 97 |
1631171 | 1631171 | 2021-08-18 | Henry | Virginia | 51089 | 4945 | 124 |
1625081 | 1625081 | 2021-08-17 | Independence | Arkansas | 5063 | 4945 | 135 |
1531169 | 1531169 | 2021-07-19 | Colquitt | Georgia | 13071 | 4945 | 131 |
1513478 | 1513478 | 2021-07-13 | Stephens | Oklahoma | 40137 | 4945 | 106 |
1510232 | 1510232 | 2021-07-12 | Stephens | Oklahoma | 40137 | 4945 | 106 |
1506985 | 1506985 | 2021-07-11 | Stephens | Oklahoma | 40137 | 4945 | 106 |
1507417 | 1507417 | 2021-07-11 | Burnet | Texas | 48053 | 4945 | 68 |
1503739 | 1503739 | 2021-07-10 | Stephens | Oklahoma | 40137 | 4945 | 106 |
1504171 | 1504171 | 2021-07-10 | Burnet | Texas | 48053 | 4945 | 68 |
1500493 | 1500493 | 2021-07-09 | Stephens | Oklahoma | 40137 | 4945 | 106 |
1497247 | 1497247 | 2021-07-08 | Stephens | Oklahoma | 40137 | 4945 | 106 |
1494000 | 1494000 | 2021-07-07 | Stephens | Oklahoma | 40137 | 4945 | 106 |
1455628 | 1455628 | 2021-06-25 | Nacogdoches | Texas | 48347 | 4945 | 173 |
1448389 | 1448389 | 2021-06-23 | Stark | North Dakota | 38089 | 4945 | 52 |
1428864 | 1428864 | 2021-06-17 | Watauga | North Carolina | 37189 | 4945 | 33 |
1426345 | 1426345 | 2021-06-16 | Harrison | Texas | 48203 | 4945 | 110 |
1410890 | 1410890 | 2021-06-12 | Broomfield | Colorado | 8014 | 4945 | 77 |
1355384 | 1355384 | 2021-05-25 | Douglas | Wisconsin | 55031 | 4945 | 58 |
1318567 | 1318567 | 2021-05-14 | Auglaize | Ohio | 39011 | 4945 | 86 |
1313207 | 1313207 | 2021-05-12 | Pierce | Wisconsin | 55093 | 4945 | 43 |
1301964 | 1301964 | 2021-05-09 | Dodge | Nebraska | 31053 | 4945 | 60 |
1298716 | 1298716 | 2021-05-08 | Dodge | Nebraska | 31053 | 4945 | 60 |
1295470 | 1295470 | 2021-05-07 | Dodge | Nebraska | 31053 | 4945 | 60 |
1275806 | 1275806 | 2021-05-01 | Callaway | Missouri | 29027 | 4945 | 47 |
1267692 | 1267692 | 2021-04-28 | Putnam | West Virginia | 54079 | 4945 | 90 |
1264094 | 1264094 | 2021-04-27 | Medina | Texas | 48325 | 4945 | 103 |
1242565 | 1242565 | 2021-04-21 | Jackson | Indiana | 18071 | 4945 | 73 |
1204718 | 1204718 | 2021-04-09 | Genesee | New York | 36037 | 4945 | 121 |
1201456 | 1201456 | 2021-04-08 | Cattaraugus | New York | 36009 | 4945 | 79 |
1191761 | 1191761 | 2021-04-05 | Wayne | New York | 36117 | 4945 | 66 |
1145691 | 1145691 | 2021-03-22 | Marquette | Michigan | 26103 | 4945 | 57 |
1126298 | 1126298 | 2021-03-16 | Otter Tail | Minnesota | 27111 | 4945 | 71 |
1123768 | 1123768 | 2021-03-15 | Huron | Ohio | 39077 | 4945 | 109 |
1109863 | 1109863 | 2021-03-11 | Vermilion | Louisiana | 22113 | 4945 | 109 |
1086851 | 1086851 | 2021-03-04 | Webster | Iowa | 19187 | 4945 | 88 |
1084749 | 1084749 | 2021-03-03 | Morton | North Dakota | 38059 | 4945 | 94 |
1054829 | 1054829 | 2021-02-22 | Van Buren | Michigan | 26159 | 4945 | 95 |
985768 | 985768 | 2021-02-01 | Coffee | Georgia | 13069 | 4945 | 123 |
983442 | 983442 | 2021-01-31 | Crow Wing | Minnesota | 27035 | 4945 | 79 |
951800 | 951800 | 2021-01-21 | Bryan | Oklahoma | 40013 | 4945 | 44 |
880010 | 880010 | 2020-12-30 | Carson City | Nevada | 32510 | 4945 | 54 |
872481 | 872481 | 2020-12-28 | Floyd | Indiana | 18043 | 4945 | 97 |
874858 | 874858 | 2020-12-28 | Cabell | West Virginia | 54011 | 4945 | 95 |
823183 | 823183 | 2020-12-13 | Santa Cruz | Arizona | 4023 | 4945 | 84 |
790954 | 790954 | 2020-12-03 | Citrus | Florida | 12017 | 4945 | 176 |
748468 | 748468 | 2020-11-20 | Houston | Alabama | 1069 | 4945 | 38 |
747415 | 747415 | 2020-11-19 | Clackamas | Oregon | 41005 | 4945 | 77 |
721336 | 721336 | 2020-11-11 | Mahoning | Ohio | 39099 | 4945 | 293 |
708705 | 708705 | 2020-11-07 | Pickens | South Carolina | 45077 | 4945 | 68 |
680009 | 680009 | 2020-10-29 | Chesapeake city | Virginia | 51550 | 4945 | 79 |
673268 | 673268 | 2020-10-27 | Ellis | Texas | 48139 | 4945 | 77 |
654564 | 654564 | 2020-10-22 | Madera | California | 6039 | 4945 | 74 |
624934 | 624934 | 2020-10-12 | Richmond city | Virginia | 51760 | 4945 | 62 |
581740 | 581740 | 2020-09-29 | Pitt | North Carolina | 37147 | 4945 | 29 |
107864 | 107864 | 2020-05-02 | Montgomery | Maryland | 24031 | 4945 | 282 |
Advanced export
JSON shape: default, array, newline-delimited
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);