ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
387 rows where cases = 1486 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 38
- Kentucky 29
- Texas 28
- Kansas 21
- North Carolina 21
- Illinois 20
- North Dakota 17
- Virginia 16
- Nebraska 15
- Arkansas 14
- Puerto Rico 14
- Missouri 13
- Montana 12
- Alabama 11
- Idaho 11
- Michigan 11
- Indiana 10
- Tennessee 9
- South Carolina 7
- Wisconsin 7
- Minnesota 6
- Mississippi 6
- Ohio 6
- Louisiana 5
- West Virginia 5
- Iowa 4
- New York 4
- Oregon 4
- Wyoming 4
- Maine 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444718 | 2444718 | 2022-04-26 | Randolph | Georgia | 13243 | 1486 | 48 |
2441462 | 2441462 | 2022-04-25 | Randolph | Georgia | 13243 | 1486 | 48 |
2438206 | 2438206 | 2022-04-24 | Randolph | Georgia | 13243 | 1486 | 48 |
2434950 | 2434950 | 2022-04-23 | Randolph | Georgia | 13243 | 1486 | 48 |
2431694 | 2431694 | 2022-04-22 | Randolph | Georgia | 13243 | 1486 | 48 |
2428438 | 2428438 | 2022-04-21 | Randolph | Georgia | 13243 | 1486 | 48 |
2429949 | 2429949 | 2022-04-21 | Dickey | North Dakota | 38021 | 1486 | 39 |
2425182 | 2425182 | 2022-04-20 | Randolph | Georgia | 13243 | 1486 | 48 |
2426693 | 2426693 | 2022-04-20 | Dickey | North Dakota | 38021 | 1486 | 39 |
2423437 | 2423437 | 2022-04-19 | Dickey | North Dakota | 38021 | 1486 | 39 |
2420180 | 2420180 | 2022-04-18 | Dickey | North Dakota | 38021 | 1486 | 39 |
2416925 | 2416925 | 2022-04-17 | Dickey | North Dakota | 38021 | 1486 | 39 |
2413669 | 2413669 | 2022-04-16 | Dickey | North Dakota | 38021 | 1486 | 39 |
2410413 | 2410413 | 2022-04-15 | Dickey | North Dakota | 38021 | 1486 | 39 |
2400362 | 2400362 | 2022-04-12 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2395943 | 2395943 | 2022-04-11 | Caribou | Idaho | 16029 | 1486 | 27 |
2397107 | 2397107 | 2022-04-11 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2392687 | 2392687 | 2022-04-10 | Caribou | Idaho | 16029 | 1486 | 27 |
2393852 | 2393852 | 2022-04-10 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2389431 | 2389431 | 2022-04-09 | Caribou | Idaho | 16029 | 1486 | 27 |
2390596 | 2390596 | 2022-04-09 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2386176 | 2386176 | 2022-04-08 | Caribou | Idaho | 16029 | 1486 | 27 |
2387340 | 2387340 | 2022-04-08 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2382921 | 2382921 | 2022-04-07 | Caribou | Idaho | 16029 | 1486 | 27 |
2384085 | 2384085 | 2022-04-07 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2380830 | 2380830 | 2022-04-06 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2377575 | 2377575 | 2022-04-05 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2374322 | 2374322 | 2022-04-04 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2371070 | 2371070 | 2022-04-03 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2367817 | 2367817 | 2022-04-02 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2364564 | 2364564 | 2022-04-01 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2361310 | 2361310 | 2022-03-31 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2361620 | 2361620 | 2022-03-31 | Ransom | North Dakota | 38073 | 1486 | 28 |
2358366 | 2358366 | 2022-03-30 | Ransom | North Dakota | 38073 | 1486 | 28 |
2355112 | 2355112 | 2022-03-29 | Ransom | North Dakota | 38073 | 1486 | 28 |
2351550 | 2351550 | 2022-03-28 | Nemaha | Nebraska | 31127 | 1486 | 19 |
2351859 | 2351859 | 2022-03-28 | Ransom | North Dakota | 38073 | 1486 | 28 |
2348607 | 2348607 | 2022-03-27 | Ransom | North Dakota | 38073 | 1486 | 28 |
2345354 | 2345354 | 2022-03-26 | Ransom | North Dakota | 38073 | 1486 | 28 |
2342101 | 2342101 | 2022-03-25 | Ransom | North Dakota | 38073 | 1486 | 28 |
2339585 | 2339585 | 2022-03-24 | Lynn | Texas | 48305 | 1486 | 38 |
2312158 | 2312158 | 2022-03-16 | Norman | Minnesota | 27107 | 1486 | 13 |
2308905 | 2308905 | 2022-03-15 | Norman | Minnesota | 27107 | 1486 | 13 |
2305654 | 2305654 | 2022-03-14 | Norman | Minnesota | 27107 | 1486 | 13 |
2278853 | 2278853 | 2022-03-06 | Power | Idaho | 16077 | 1486 | 20 |
2275600 | 2275600 | 2022-03-05 | Power | Idaho | 16077 | 1486 | 20 |
2272347 | 2272347 | 2022-03-04 | Power | Idaho | 16077 | 1486 | 20 |
2273794 | 2273794 | 2022-03-04 | Ransom | North Dakota | 38073 | 1486 | 28 |
2274411 | 2274411 | 2022-03-04 | Carson | Texas | 48065 | 1486 | 34 |
2269095 | 2269095 | 2022-03-03 | Power | Idaho | 16077 | 1486 | 20 |
2270541 | 2270541 | 2022-03-03 | Ransom | North Dakota | 38073 | 1486 | 28 |
2265842 | 2265842 | 2022-03-02 | Power | Idaho | 16077 | 1486 | 20 |
2266908 | 2266908 | 2022-03-02 | Stillwater | Montana | 30095 | 1486 | 29 |
2267992 | 2267992 | 2022-03-02 | Jack | Texas | 48237 | 1486 | 27 |
2262154 | 2262154 | 2022-03-01 | Montgomery | Arkansas | 5097 | 1486 | 54 |
2263079 | 2263079 | 2022-03-01 | Menifee | Kentucky | 21165 | 1486 | 30 |
2263510 | 2263510 | 2022-03-01 | Carter | Missouri | 29035 | 1486 | 21 |
2264739 | 2264739 | 2022-03-01 | Jack | Texas | 48237 | 1486 | 27 |
2258903 | 2258903 | 2022-02-28 | Montgomery | Arkansas | 5097 | 1486 | 54 |
2260259 | 2260259 | 2022-02-28 | Carter | Missouri | 29035 | 1486 | 20 |
2255652 | 2255652 | 2022-02-27 | Montgomery | Arkansas | 5097 | 1486 | 54 |
2252401 | 2252401 | 2022-02-26 | Montgomery | Arkansas | 5097 | 1486 | 54 |
2249150 | 2249150 | 2022-02-25 | Montgomery | Arkansas | 5097 | 1486 | 54 |
2245899 | 2245899 | 2022-02-24 | Montgomery | Arkansas | 5097 | 1486 | 54 |
2236473 | 2236473 | 2022-02-21 | Marion | Georgia | 13197 | 1486 | 46 |
2237583 | 2237583 | 2022-02-21 | Shelby | Missouri | 29205 | 1486 | 14 |
2233222 | 2233222 | 2022-02-20 | Marion | Georgia | 13197 | 1486 | 45 |
2233696 | 2233696 | 2022-02-20 | Morris | Kansas | 20127 | 1486 | 26 |
2234332 | 2234332 | 2022-02-20 | Shelby | Missouri | 29205 | 1486 | 14 |
2229971 | 2229971 | 2022-02-19 | Marion | Georgia | 13197 | 1486 | 45 |
2230445 | 2230445 | 2022-02-19 | Morris | Kansas | 20127 | 1486 | 26 |
2231081 | 2231081 | 2022-02-19 | Shelby | Missouri | 29205 | 1486 | 14 |
2226720 | 2226720 | 2022-02-18 | Marion | Georgia | 13197 | 1486 | 45 |
2227194 | 2227194 | 2022-02-18 | Morris | Kansas | 20127 | 1486 | 26 |
2227830 | 2227830 | 2022-02-18 | Shelby | Missouri | 29205 | 1486 | 14 |
2223469 | 2223469 | 2022-02-17 | Marion | Georgia | 13197 | 1486 | 45 |
2223970 | 2223970 | 2022-02-17 | Sherman | Kansas | 20181 | 1486 | 19 |
2224579 | 2224579 | 2022-02-17 | Shelby | Missouri | 29205 | 1486 | 14 |
2220719 | 2220719 | 2022-02-16 | Sherman | Kansas | 20181 | 1486 | 19 |
2103871 | 2103871 | 2022-01-11 | Alcona | Michigan | 26001 | 1486 | 59 |
2100620 | 2100620 | 2022-01-10 | Alcona | Michigan | 26001 | 1486 | 59 |
2101709 | 2101709 | 2022-01-10 | Adjuntas | Puerto Rico | 72001 | 1486 | |
2078571 | 2078571 | 2022-01-03 | Jones | North Carolina | 37103 | 1486 | 38 |
2079066 | 2079066 | 2022-01-03 | McCormick | South Carolina | 45065 | 1486 | 30 |
2074396 | 2074396 | 2022-01-02 | Elliott | Kentucky | 21063 | 1486 | 13 |
2075815 | 2075815 | 2022-01-02 | McCormick | South Carolina | 45065 | 1486 | 30 |
2071145 | 2071145 | 2022-01-01 | Elliott | Kentucky | 21063 | 1486 | 13 |
2072564 | 2072564 | 2022-01-01 | McCormick | South Carolina | 45065 | 1486 | 30 |
2067894 | 2067894 | 2021-12-31 | Elliott | Kentucky | 21063 | 1486 | 13 |
2069313 | 2069313 | 2021-12-31 | McCormick | South Carolina | 45065 | 1486 | 30 |
2064077 | 2064077 | 2021-12-30 | Irwin | Georgia | 13155 | 1486 | 42 |
2064643 | 2064643 | 2021-12-30 | Elliott | Kentucky | 21063 | 1486 | 13 |
2061393 | 2061393 | 2021-12-29 | Elliott | Kentucky | 21063 | 1486 | 13 |
2030225 | 2030225 | 2021-12-19 | Guayama | Puerto Rico | 72057 | 1486 | |
2026966 | 2026966 | 2021-12-18 | Coamo | Puerto Rico | 72043 | 1486 | |
2027759 | 2027759 | 2021-12-18 | Tyler | West Virginia | 54095 | 1486 | 25 |
2024508 | 2024508 | 2021-12-17 | Tyler | West Virginia | 54095 | 1486 | 25 |
1969347 | 1969347 | 2021-11-30 | Sublette | Wyoming | 56035 | 1486 | 23 |
1964237 | 1964237 | 2021-11-29 | Pipestone | Minnesota | 27117 | 1486 | 29 |
1960076 | 1960076 | 2021-11-28 | Lanier | Georgia | 13173 | 1486 | 17 |
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);