ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
533 rows where deaths = 333 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 58
- Texas 38
- Georgia 30
- Pennsylvania 29
- Wisconsin 27
- Tennessee 23
- Florida 21
- Oklahoma 21
- Illinois 20
- Indiana 20
- Maryland 20
- Oregon 20
- Michigan 18
- South Carolina 17
- New York 14
- North Carolina 14
- Louisiana 11
- Ohio 11
- Virginia 11
- Minnesota 10
- Colorado 9
- Washington 9
- Missouri 8
- California 7
- Iowa 7
- New Jersey 7
- New Mexico 7
- Utah 7
- Arkansas 6
- Massachusetts 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501594 | 2501594 | 2022-05-13 | Cass | North Dakota | 38017 | 59940 | 333 |
2498336 | 2498336 | 2022-05-12 | Cass | North Dakota | 38017 | 59650 | 333 |
2494952 | 2494952 | 2022-05-11 | Saratoga | New York | 36091 | 49695 | 333 |
2495078 | 2495078 | 2022-05-11 | Cass | North Dakota | 38017 | 59650 | 333 |
2491694 | 2491694 | 2022-05-10 | Saratoga | New York | 36091 | 49553 | 333 |
2491820 | 2491820 | 2022-05-10 | Cass | North Dakota | 38017 | 59650 | 333 |
2488436 | 2488436 | 2022-05-09 | Saratoga | New York | 36091 | 49486 | 333 |
2488562 | 2488562 | 2022-05-09 | Cass | North Dakota | 38017 | 59650 | 333 |
2485305 | 2485305 | 2022-05-08 | Cass | North Dakota | 38017 | 59650 | 333 |
2482047 | 2482047 | 2022-05-07 | Cass | North Dakota | 38017 | 59650 | 333 |
2478789 | 2478789 | 2022-05-06 | Cass | North Dakota | 38017 | 59650 | 333 |
2475531 | 2475531 | 2022-05-05 | Cass | North Dakota | 38017 | 59383 | 333 |
2472274 | 2472274 | 2022-05-04 | Cass | North Dakota | 38017 | 59383 | 333 |
2469018 | 2469018 | 2022-05-03 | Cass | North Dakota | 38017 | 59383 | 333 |
2465762 | 2465762 | 2022-05-02 | Cass | North Dakota | 38017 | 59383 | 333 |
2462507 | 2462507 | 2022-05-01 | Cass | North Dakota | 38017 | 59383 | 333 |
2459251 | 2459251 | 2022-04-30 | Cass | North Dakota | 38017 | 59383 | 333 |
2455995 | 2455995 | 2022-04-29 | Cass | North Dakota | 38017 | 59383 | 333 |
2452739 | 2452739 | 2022-04-28 | Cass | North Dakota | 38017 | 59185 | 333 |
2449296 | 2449296 | 2022-04-27 | Lea | New Mexico | 35025 | 20155 | 333 |
2449483 | 2449483 | 2022-04-27 | Cass | North Dakota | 38017 | 59185 | 333 |
2446039 | 2446039 | 2022-04-26 | Lea | New Mexico | 35025 | 20155 | 333 |
2446226 | 2446226 | 2022-04-26 | Cass | North Dakota | 38017 | 59185 | 333 |
2442784 | 2442784 | 2022-04-25 | Lea | New Mexico | 35025 | 20155 | 333 |
2442971 | 2442971 | 2022-04-25 | Cass | North Dakota | 38017 | 59185 | 333 |
2439528 | 2439528 | 2022-04-24 | Lea | New Mexico | 35025 | 20155 | 333 |
2439715 | 2439715 | 2022-04-24 | Cass | North Dakota | 38017 | 59185 | 333 |
2436272 | 2436272 | 2022-04-23 | Lea | New Mexico | 35025 | 20155 | 333 |
2436459 | 2436459 | 2022-04-23 | Cass | North Dakota | 38017 | 59185 | 333 |
2433016 | 2433016 | 2022-04-22 | Lea | New Mexico | 35025 | 20155 | 333 |
2433203 | 2433203 | 2022-04-22 | Cass | North Dakota | 38017 | 59185 | 333 |
2429947 | 2429947 | 2022-04-21 | Cass | North Dakota | 38017 | 59055 | 333 |
2426691 | 2426691 | 2022-04-20 | Cass | North Dakota | 38017 | 59055 | 333 |
2426848 | 2426848 | 2022-04-20 | Creek | Oklahoma | 40037 | 18158 | 333 |
2421588 | 2421588 | 2022-04-19 | Saline | Arkansas | 5125 | 30874 | 333 |
2423435 | 2423435 | 2022-04-19 | Cass | North Dakota | 38017 | 59055 | 333 |
2423592 | 2423592 | 2022-04-19 | Creek | Oklahoma | 40037 | 18158 | 333 |
2423668 | 2423668 | 2022-04-19 | Josephine | Oregon | 41033 | 16380 | 333 |
2423952 | 2423952 | 2022-04-19 | Anderson | Tennessee | 47001 | 22077 | 333 |
2418332 | 2418332 | 2022-04-18 | Saline | Arkansas | 5125 | 30867 | 333 |
2420178 | 2420178 | 2022-04-18 | Cass | North Dakota | 38017 | 59055 | 333 |
2420335 | 2420335 | 2022-04-18 | Creek | Oklahoma | 40037 | 18158 | 333 |
2420411 | 2420411 | 2022-04-18 | Josephine | Oregon | 41033 | 16365 | 333 |
2420696 | 2420696 | 2022-04-18 | Anderson | Tennessee | 47001 | 22077 | 333 |
2415076 | 2415076 | 2022-04-17 | Saline | Arkansas | 5125 | 30865 | 333 |
2416923 | 2416923 | 2022-04-17 | Cass | North Dakota | 38017 | 59055 | 333 |
2417080 | 2417080 | 2022-04-17 | Creek | Oklahoma | 40037 | 18158 | 333 |
2417156 | 2417156 | 2022-04-17 | Josephine | Oregon | 41033 | 16365 | 333 |
2417440 | 2417440 | 2022-04-17 | Anderson | Tennessee | 47001 | 22077 | 333 |
2411820 | 2411820 | 2022-04-16 | Saline | Arkansas | 5125 | 30864 | 333 |
2413667 | 2413667 | 2022-04-16 | Cass | North Dakota | 38017 | 59055 | 333 |
2413824 | 2413824 | 2022-04-16 | Creek | Oklahoma | 40037 | 18158 | 333 |
2413900 | 2413900 | 2022-04-16 | Josephine | Oregon | 41033 | 16365 | 333 |
2414184 | 2414184 | 2022-04-16 | Anderson | Tennessee | 47001 | 22077 | 333 |
2410411 | 2410411 | 2022-04-15 | Cass | North Dakota | 38017 | 59055 | 333 |
2410568 | 2410568 | 2022-04-15 | Creek | Oklahoma | 40037 | 18158 | 333 |
2410644 | 2410644 | 2022-04-15 | Josephine | Oregon | 41033 | 16365 | 333 |
2410928 | 2410928 | 2022-04-15 | Anderson | Tennessee | 47001 | 22077 | 333 |
2407155 | 2407155 | 2022-04-14 | Cass | North Dakota | 38017 | 58967 | 333 |
2407312 | 2407312 | 2022-04-14 | Creek | Oklahoma | 40037 | 18158 | 333 |
2407388 | 2407388 | 2022-04-14 | Josephine | Oregon | 41033 | 16360 | 333 |
2407672 | 2407672 | 2022-04-14 | Anderson | Tennessee | 47001 | 22077 | 333 |
2403899 | 2403899 | 2022-04-13 | Cass | North Dakota | 38017 | 58967 | 333 |
2404056 | 2404056 | 2022-04-13 | Creek | Oklahoma | 40037 | 18141 | 333 |
2404416 | 2404416 | 2022-04-13 | Anderson | Tennessee | 47001 | 22077 | 333 |
2400644 | 2400644 | 2022-04-12 | Cass | North Dakota | 38017 | 58967 | 333 |
2400801 | 2400801 | 2022-04-12 | Creek | Oklahoma | 40037 | 18141 | 333 |
2397389 | 2397389 | 2022-04-11 | Cass | North Dakota | 38017 | 58967 | 333 |
2397546 | 2397546 | 2022-04-11 | Creek | Oklahoma | 40037 | 18141 | 333 |
2394134 | 2394134 | 2022-04-10 | Cass | North Dakota | 38017 | 58967 | 333 |
2394291 | 2394291 | 2022-04-10 | Creek | Oklahoma | 40037 | 18141 | 333 |
2390878 | 2390878 | 2022-04-09 | Cass | North Dakota | 38017 | 58967 | 333 |
2391035 | 2391035 | 2022-04-09 | Creek | Oklahoma | 40037 | 18141 | 333 |
2387622 | 2387622 | 2022-04-08 | Cass | North Dakota | 38017 | 58967 | 333 |
2387779 | 2387779 | 2022-04-08 | Creek | Oklahoma | 40037 | 18141 | 333 |
2384367 | 2384367 | 2022-04-07 | Cass | North Dakota | 38017 | 58895 | 333 |
2384524 | 2384524 | 2022-04-07 | Creek | Oklahoma | 40037 | 18141 | 333 |
2381112 | 2381112 | 2022-04-06 | Cass | North Dakota | 38017 | 58895 | 333 |
2381301 | 2381301 | 2022-04-06 | Muskogee | Oklahoma | 40101 | 19918 | 333 |
2377857 | 2377857 | 2022-04-05 | Cass | North Dakota | 38017 | 58895 | 333 |
2378046 | 2378046 | 2022-04-05 | Muskogee | Oklahoma | 40101 | 19918 | 333 |
2374604 | 2374604 | 2022-04-04 | Cass | North Dakota | 38017 | 58895 | 333 |
2374792 | 2374792 | 2022-04-04 | Muskogee | Oklahoma | 40101 | 19918 | 333 |
2371352 | 2371352 | 2022-04-03 | Cass | North Dakota | 38017 | 58895 | 333 |
2371540 | 2371540 | 2022-04-03 | Muskogee | Oklahoma | 40101 | 19918 | 333 |
2372416 | 2372416 | 2022-04-03 | Kitsap | Washington | 53035 | 39217 | 333 |
2368099 | 2368099 | 2022-04-02 | Cass | North Dakota | 38017 | 58895 | 333 |
2368287 | 2368287 | 2022-04-02 | Muskogee | Oklahoma | 40101 | 19918 | 333 |
2369163 | 2369163 | 2022-04-02 | Kitsap | Washington | 53035 | 39217 | 333 |
2364846 | 2364846 | 2022-04-01 | Cass | North Dakota | 38017 | 58895 | 333 |
2365034 | 2365034 | 2022-04-01 | Muskogee | Oklahoma | 40101 | 19918 | 333 |
2365910 | 2365910 | 2022-04-01 | Kitsap | Washington | 53035 | 39217 | 333 |
2361592 | 2361592 | 2022-03-31 | Cass | North Dakota | 38017 | 58839 | 333 |
2361781 | 2361781 | 2022-03-31 | Muskogee | Oklahoma | 40101 | 19918 | 333 |
2358338 | 2358338 | 2022-03-30 | Cass | North Dakota | 38017 | 58839 | 333 |
2355084 | 2355084 | 2022-03-29 | Cass | North Dakota | 38017 | 58839 | 333 |
2351831 | 2351831 | 2022-03-28 | Cass | North Dakota | 38017 | 58839 | 333 |
2348579 | 2348579 | 2022-03-27 | Cass | North Dakota | 38017 | 58839 | 333 |
2349644 | 2349644 | 2022-03-27 | Kitsap | Washington | 53035 | 39076 | 333 |
2345326 | 2345326 | 2022-03-26 | Cass | North Dakota | 38017 | 58839 | 333 |
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);