ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
108 rows where cases = 5031 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 11
- Indiana 10
- Idaho 9
- Illinois 9
- Texas 6
- Georgia 5
- Michigan 5
- Nebraska 5
- Kentucky 4
- Minnesota 4
- Ohio 4
- Pennsylvania 4
- Maine 3
- Oregon 3
- Utah 3
- Virginia 3
- Florida 2
- Kansas 2
- Mississippi 2
- South Carolina 2
- Wisconsin 2
- Arkansas 1
- California 1
- Colorado 1
- Delaware 1
- Maryland 1
- Montana 1
- Nevada 1
- Puerto Rico 1
- West Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491738 | 2491738 | 2022-05-10 | Currituck | North Carolina | 37053 | 5031 | 36 |
2488480 | 2488480 | 2022-05-09 | Currituck | North Carolina | 37053 | 5031 | 36 |
2485223 | 2485223 | 2022-05-08 | Currituck | North Carolina | 37053 | 5031 | 36 |
2481965 | 2481965 | 2022-05-07 | Currituck | North Carolina | 37053 | 5031 | 36 |
2478707 | 2478707 | 2022-05-06 | Currituck | North Carolina | 37053 | 5031 | 36 |
2475449 | 2475449 | 2022-05-05 | Currituck | North Carolina | 37053 | 5031 | 36 |
2472192 | 2472192 | 2022-05-04 | Currituck | North Carolina | 37053 | 5031 | 36 |
2467572 | 2467572 | 2022-05-03 | Cassia | Idaho | 16031 | 5031 | 52 |
2464317 | 2464317 | 2022-05-02 | Cassia | Idaho | 16031 | 5031 | 52 |
2444781 | 2444781 | 2022-04-26 | Cassia | Idaho | 16031 | 5031 | 52 |
2441525 | 2441525 | 2022-04-25 | Cassia | Idaho | 16031 | 5031 | 52 |
2442703 | 2442703 | 2022-04-25 | Saunders | Nebraska | 31155 | 5031 | 30 |
2438269 | 2438269 | 2022-04-24 | Cassia | Idaho | 16031 | 5031 | 52 |
2439447 | 2439447 | 2022-04-24 | Saunders | Nebraska | 31155 | 5031 | 30 |
2435013 | 2435013 | 2022-04-23 | Cassia | Idaho | 16031 | 5031 | 52 |
2436191 | 2436191 | 2022-04-23 | Saunders | Nebraska | 31155 | 5031 | 30 |
2431757 | 2431757 | 2022-04-22 | Cassia | Idaho | 16031 | 5031 | 52 |
2432935 | 2432935 | 2022-04-22 | Saunders | Nebraska | 31155 | 5031 | 30 |
2429679 | 2429679 | 2022-04-21 | Saunders | Nebraska | 31155 | 5031 | 30 |
2396047 | 2396047 | 2022-04-11 | Pike | Illinois | 17149 | 5031 | 70 |
2392878 | 2392878 | 2022-04-10 | Orange | Indiana | 18117 | 5031 | 96 |
2389622 | 2389622 | 2022-04-09 | Orange | Indiana | 18117 | 5031 | 96 |
2386367 | 2386367 | 2022-04-08 | Orange | Indiana | 18117 | 5031 | 96 |
2378188 | 2378188 | 2022-04-05 | Cabo Rojo | Puerto Rico | 72023 | 5031 | |
2352843 | 2352843 | 2022-03-28 | Powhatan | Virginia | 51145 | 5031 | 57 |
2330869 | 2330869 | 2022-03-22 | Cassia | Idaho | 16031 | 5031 | 52 |
2324554 | 2324554 | 2022-03-20 | Orange | Indiana | 18117 | 5031 | 96 |
2321300 | 2321300 | 2022-03-19 | Orange | Indiana | 18117 | 5031 | 96 |
2318046 | 2318046 | 2022-03-18 | Orange | Indiana | 18117 | 5031 | 96 |
2314793 | 2314793 | 2022-03-17 | Orange | Indiana | 18117 | 5031 | 96 |
2307998 | 2307998 | 2022-03-15 | Jones | Georgia | 13169 | 5031 | 108 |
2289976 | 2289976 | 2022-03-09 | Madison | North Carolina | 37115 | 5031 | 79 |
2282704 | 2282704 | 2022-03-07 | Lincoln | Maine | 23015 | 5031 | 31 |
2279451 | 2279451 | 2022-03-06 | Lincoln | Maine | 23015 | 5031 | 31 |
2276198 | 2276198 | 2022-03-05 | Lincoln | Maine | 23015 | 5031 | 31 |
2267579 | 2267579 | 2022-03-02 | Wyoming | Pennsylvania | 42131 | 5031 | 100 |
2257756 | 2257756 | 2022-02-27 | Wasco | Oregon | 41065 | 5031 | 53 |
2254505 | 2254505 | 2022-02-26 | Wasco | Oregon | 41065 | 5031 | 53 |
2251254 | 2251254 | 2022-02-25 | Wasco | Oregon | 41065 | 5031 | 53 |
2187885 | 2187885 | 2022-02-06 | Richland | Illinois | 17159 | 5031 | 80 |
2184632 | 2184632 | 2022-02-05 | Richland | Illinois | 17159 | 5031 | 80 |
2181380 | 2181380 | 2022-02-04 | Richland | Illinois | 17159 | 5031 | 80 |
2149389 | 2149389 | 2022-01-25 | Talbot | Maryland | 24041 | 5031 | 72 |
2149412 | 2149412 | 2022-01-25 | Alpena | Michigan | 26007 | 5031 | 120 |
2146160 | 2146160 | 2022-01-24 | Alpena | Michigan | 26007 | 5031 | 120 |
2146225 | 2146225 | 2022-01-24 | Otsego | Michigan | 26137 | 5031 | 90 |
2135114 | 2135114 | 2022-01-20 | Vernon | Wisconsin | 55123 | 5031 | 78 |
2109816 | 2109816 | 2022-01-13 | Shelby | Illinois | 17173 | 5031 | 63 |
2110767 | 2110767 | 2022-01-13 | Lake | Montana | 30047 | 5031 | 87 |
2074698 | 2074698 | 2022-01-02 | Brown | Minnesota | 27015 | 5031 | 66 |
2071447 | 2071447 | 2022-01-01 | Brown | Minnesota | 27015 | 5031 | 66 |
2068196 | 2068196 | 2021-12-31 | Brown | Minnesota | 27015 | 5031 | 66 |
2064945 | 2064945 | 2021-12-30 | Brown | Minnesota | 27015 | 5031 | 66 |
2066600 | 2066600 | 2021-12-30 | Isle of Wight | Virginia | 51093 | 5031 | 93 |
2031346 | 2031346 | 2021-12-20 | Siskiyou | California | 6093 | 5031 | 76 |
2012530 | 2012530 | 2021-12-14 | Ellis | Kansas | 20051 | 5031 | 77 |
2009279 | 2009279 | 2021-12-13 | Ellis | Kansas | 20051 | 5031 | 77 |
1963895 | 1963895 | 2021-11-29 | Grayson | Kentucky | 21085 | 5031 | 99 |
1930509 | 1930509 | 2021-11-19 | Poinsett | Arkansas | 5111 | 5031 | 102 |
1904260 | 1904260 | 2021-11-10 | Clark | Wisconsin | 55019 | 5031 | 80 |
1894458 | 1894458 | 2021-11-07 | Greenbrier | West Virginia | 54025 | 5031 | 98 |
1887545 | 1887545 | 2021-11-05 | Fannin | Texas | 48147 | 5031 | 152 |
1869678 | 1869678 | 2021-10-31 | Marshall | Kentucky | 21157 | 5031 | 78 |
1866429 | 1866429 | 2021-10-30 | Marshall | Kentucky | 21157 | 5031 | 78 |
1863180 | 1863180 | 2021-10-29 | Marshall | Kentucky | 21157 | 5031 | 78 |
1829364 | 1829364 | 2021-10-18 | Manassas city | Virginia | 51683 | 5031 | 51 |
1805743 | 1805743 | 2021-10-11 | Perry | Ohio | 39127 | 5031 | 57 |
1781505 | 1781505 | 2021-10-04 | Fulton | Illinois | 17057 | 5031 | 78 |
1780524 | 1780524 | 2021-10-03 | Sanpete | Utah | 49039 | 5031 | 31 |
1777274 | 1777274 | 2021-10-02 | Sanpete | Utah | 49039 | 5031 | 31 |
1774024 | 1774024 | 2021-10-01 | Sanpete | Utah | 49039 | 5031 | 31 |
1730995 | 1730995 | 2021-09-18 | Logan | Ohio | 39091 | 5031 | 82 |
1718529 | 1718529 | 2021-09-14 | Bee | Texas | 48025 | 5031 | 95 |
1700246 | 1700246 | 2021-09-09 | Nez Perce | Idaho | 16069 | 5031 | 68 |
1701429 | 1701429 | 2021-09-09 | Lyon | Nevada | 32019 | 5031 | 80 |
1695267 | 1695267 | 2021-09-07 | Madison | Ohio | 39097 | 5031 | 66 |
1644848 | 1644848 | 2021-08-23 | Chattahoochee | Georgia | 13053 | 5031 | 17 |
1580925 | 1580925 | 2021-08-03 | Oktibbeha | Mississippi | 28105 | 5031 | 98 |
1566004 | 1566004 | 2021-07-29 | Medina | Texas | 48325 | 5031 | 108 |
1559150 | 1559150 | 2021-07-27 | Chesterfield | South Carolina | 45025 | 5031 | 108 |
1539189 | 1539189 | 2021-07-21 | Hoke | North Carolina | 37093 | 5031 | 56 |
1518281 | 1518281 | 2021-07-15 | Tift | Georgia | 13277 | 5031 | 133 |
1519753 | 1519753 | 2021-07-15 | Watauga | North Carolina | 37189 | 5031 | 33 |
1501774 | 1501774 | 2021-07-10 | Broomfield | Colorado | 8014 | 5031 | 76 |
1323633 | 1323633 | 2021-05-16 | Jackson | Illinois | 17077 | 5031 | 75 |
1320387 | 1320387 | 2021-05-15 | Jackson | Illinois | 17077 | 5031 | 75 |
1317240 | 1317240 | 2021-05-14 | Jackson | Indiana | 18071 | 5031 | 74 |
1313993 | 1313993 | 2021-05-13 | Jackson | Indiana | 18071 | 5031 | 74 |
1250627 | 1250627 | 2021-04-23 | Mifflin | Pennsylvania | 42087 | 5031 | 176 |
1211496 | 1211496 | 2021-04-11 | Washington | Ohio | 39167 | 5031 | 107 |
1201877 | 1201877 | 2021-04-08 | Bradford | Pennsylvania | 42015 | 5031 | 84 |
1198639 | 1198639 | 2021-04-07 | Columbia | Pennsylvania | 42037 | 5031 | 129 |
1112578 | 1112578 | 2021-03-12 | Knox | Illinois | 17095 | 5031 | 164 |
1074239 | 1074239 | 2021-02-28 | Clinton | Michigan | 26037 | 5031 | 70 |
1070993 | 1070993 | 2021-02-27 | Clinton | Michigan | 26037 | 5031 | 70 |
1066945 | 1066945 | 2021-02-26 | Habersham | Georgia | 13137 | 5031 | 142 |
1038036 | 1038036 | 2021-02-17 | Noble | Indiana | 18113 | 5031 | 78 |
984731 | 984731 | 2021-01-31 | Bastrop | Texas | 48021 | 5031 | 65 |
972702 | 972702 | 2021-01-28 | Gadsden | Florida | 12039 | 5031 | 68 |
947850 | 947850 | 2021-01-20 | Lafayette | Mississippi | 28071 | 5031 | 93 |
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);