ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,069 rows where deaths = 258 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 131
- Texas 88
- Virginia 88
- New York 54
- North Carolina 47
- Georgia 44
- Louisiana 44
- Maryland 44
- Florida 39
- Pennsylvania 39
- Illinois 38
- Ohio 36
- Alabama 34
- California 33
- Michigan 31
- Missouri 24
- South Carolina 23
- Tennessee 23
- Mississippi 22
- Wisconsin 22
- Arkansas 17
- Iowa 16
- Oklahoma 15
- Connecticut 12
- Kentucky 12
- Minnesota 11
- Colorado 9
- Oregon 9
- Idaho 8
- Montana 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500309 | 2500309 | 2022-05-13 | Hancock | Indiana | 18059 | 20888 | 258 |
2502380 | 2502380 | 2022-05-13 | Nacogdoches | Texas | 48347 | 12413 | 258 |
2497051 | 2497051 | 2022-05-12 | Hancock | Indiana | 18059 | 20849 | 258 |
2499122 | 2499122 | 2022-05-12 | Nacogdoches | Texas | 48347 | 12411 | 258 |
2493793 | 2493793 | 2022-05-11 | Hancock | Indiana | 18059 | 20849 | 258 |
2495864 | 2495864 | 2022-05-11 | Nacogdoches | Texas | 48347 | 12393 | 258 |
2490535 | 2490535 | 2022-05-10 | Hancock | Indiana | 18059 | 20831 | 258 |
2492606 | 2492606 | 2022-05-10 | Nacogdoches | Texas | 48347 | 12380 | 258 |
2487278 | 2487278 | 2022-05-09 | Hancock | Indiana | 18059 | 20831 | 258 |
2489348 | 2489348 | 2022-05-09 | Nacogdoches | Texas | 48347 | 12375 | 258 |
2484020 | 2484020 | 2022-05-08 | Hancock | Indiana | 18059 | 20778 | 258 |
2484368 | 2484368 | 2022-05-08 | McCracken | Kentucky | 21145 | 18464 | 258 |
2486091 | 2486091 | 2022-05-08 | Nacogdoches | Texas | 48347 | 12374 | 258 |
2480762 | 2480762 | 2022-05-07 | Hancock | Indiana | 18059 | 20778 | 258 |
2481110 | 2481110 | 2022-05-07 | McCracken | Kentucky | 21145 | 18464 | 258 |
2482833 | 2482833 | 2022-05-07 | Nacogdoches | Texas | 48347 | 12372 | 258 |
2477504 | 2477504 | 2022-05-06 | Hancock | Indiana | 18059 | 20778 | 258 |
2477852 | 2477852 | 2022-05-06 | McCracken | Kentucky | 21145 | 18464 | 258 |
2479575 | 2479575 | 2022-05-06 | Nacogdoches | Texas | 48347 | 12370 | 258 |
2474246 | 2474246 | 2022-05-05 | Hancock | Indiana | 18059 | 20778 | 258 |
2474594 | 2474594 | 2022-05-05 | McCracken | Kentucky | 21145 | 18464 | 258 |
2476317 | 2476317 | 2022-05-05 | Nacogdoches | Texas | 48347 | 12367 | 258 |
2470989 | 2470989 | 2022-05-04 | Hancock | Indiana | 18059 | 20778 | 258 |
2471337 | 2471337 | 2022-05-04 | McCracken | Kentucky | 21145 | 18464 | 258 |
2473060 | 2473060 | 2022-05-04 | Nacogdoches | Texas | 48347 | 12362 | 258 |
2467733 | 2467733 | 2022-05-03 | Hancock | Indiana | 18059 | 20759 | 258 |
2468081 | 2468081 | 2022-05-03 | McCracken | Kentucky | 21145 | 18464 | 258 |
2469804 | 2469804 | 2022-05-03 | Nacogdoches | Texas | 48347 | 12360 | 258 |
2464478 | 2464478 | 2022-05-02 | Hancock | Indiana | 18059 | 20759 | 258 |
2464826 | 2464826 | 2022-05-02 | McCracken | Kentucky | 21145 | 18464 | 258 |
2466548 | 2466548 | 2022-05-02 | Nacogdoches | Texas | 48347 | 12358 | 258 |
2461222 | 2461222 | 2022-05-01 | Hancock | Indiana | 18059 | 20741 | 258 |
2461701 | 2461701 | 2022-05-01 | Cecil | Maryland | 24015 | 15655 | 258 |
2463293 | 2463293 | 2022-05-01 | Nacogdoches | Texas | 48347 | 12356 | 258 |
2457966 | 2457966 | 2022-04-30 | Hancock | Indiana | 18059 | 20741 | 258 |
2458445 | 2458445 | 2022-04-30 | Cecil | Maryland | 24015 | 15655 | 258 |
2460037 | 2460037 | 2022-04-30 | Nacogdoches | Texas | 48347 | 12355 | 258 |
2454710 | 2454710 | 2022-04-29 | Hancock | Indiana | 18059 | 20741 | 258 |
2455189 | 2455189 | 2022-04-29 | Cecil | Maryland | 24015 | 15655 | 258 |
2456781 | 2456781 | 2022-04-29 | Nacogdoches | Texas | 48347 | 12353 | 258 |
2451454 | 2451454 | 2022-04-28 | Hancock | Indiana | 18059 | 20717 | 258 |
2451933 | 2451933 | 2022-04-28 | Cecil | Maryland | 24015 | 15642 | 258 |
2453525 | 2453525 | 2022-04-28 | Nacogdoches | Texas | 48347 | 12349 | 258 |
2448198 | 2448198 | 2022-04-27 | Hancock | Indiana | 18059 | 20717 | 258 |
2448677 | 2448677 | 2022-04-27 | Cecil | Maryland | 24015 | 15630 | 258 |
2450269 | 2450269 | 2022-04-27 | Nacogdoches | Texas | 48347 | 12348 | 258 |
2444942 | 2444942 | 2022-04-26 | Hancock | Indiana | 18059 | 20706 | 258 |
2445421 | 2445421 | 2022-04-26 | Cecil | Maryland | 24015 | 15624 | 258 |
2446214 | 2446214 | 2022-04-26 | Wilkes | North Carolina | 37193 | 17528 | 258 |
2447012 | 2447012 | 2022-04-26 | Nacogdoches | Texas | 48347 | 12347 | 258 |
2441686 | 2441686 | 2022-04-25 | Hancock | Indiana | 18059 | 20706 | 258 |
2442165 | 2442165 | 2022-04-25 | Cecil | Maryland | 24015 | 15598 | 258 |
2442959 | 2442959 | 2022-04-25 | Wilkes | North Carolina | 37193 | 17528 | 258 |
2443757 | 2443757 | 2022-04-25 | Nacogdoches | Texas | 48347 | 12346 | 258 |
2438430 | 2438430 | 2022-04-24 | Hancock | Indiana | 18059 | 20698 | 258 |
2438909 | 2438909 | 2022-04-24 | Cecil | Maryland | 24015 | 15588 | 258 |
2439703 | 2439703 | 2022-04-24 | Wilkes | North Carolina | 37193 | 17528 | 258 |
2440501 | 2440501 | 2022-04-24 | Nacogdoches | Texas | 48347 | 12346 | 258 |
2435174 | 2435174 | 2022-04-23 | Hancock | Indiana | 18059 | 20698 | 258 |
2435653 | 2435653 | 2022-04-23 | Cecil | Maryland | 24015 | 15588 | 258 |
2436447 | 2436447 | 2022-04-23 | Wilkes | North Carolina | 37193 | 17528 | 258 |
2437245 | 2437245 | 2022-04-23 | Nacogdoches | Texas | 48347 | 12346 | 258 |
2431918 | 2431918 | 2022-04-22 | Hancock | Indiana | 18059 | 20698 | 258 |
2432397 | 2432397 | 2022-04-22 | Cecil | Maryland | 24015 | 15588 | 258 |
2433191 | 2433191 | 2022-04-22 | Wilkes | North Carolina | 37193 | 17528 | 258 |
2433989 | 2433989 | 2022-04-22 | Nacogdoches | Texas | 48347 | 12343 | 258 |
2428662 | 2428662 | 2022-04-21 | Hancock | Indiana | 18059 | 20690 | 258 |
2429141 | 2429141 | 2022-04-21 | Cecil | Maryland | 24015 | 15569 | 258 |
2429935 | 2429935 | 2022-04-21 | Wilkes | North Carolina | 37193 | 17528 | 258 |
2430733 | 2430733 | 2022-04-21 | Nacogdoches | Texas | 48347 | 12334 | 258 |
2425406 | 2425406 | 2022-04-20 | Hancock | Indiana | 18059 | 20690 | 258 |
2425885 | 2425885 | 2022-04-20 | Cecil | Maryland | 24015 | 15561 | 258 |
2426679 | 2426679 | 2022-04-20 | Wilkes | North Carolina | 37193 | 17528 | 258 |
2427477 | 2427477 | 2022-04-20 | Nacogdoches | Texas | 48347 | 12329 | 258 |
2422150 | 2422150 | 2022-04-19 | Hancock | Indiana | 18059 | 20683 | 258 |
2422629 | 2422629 | 2022-04-19 | Cecil | Maryland | 24015 | 15553 | 258 |
2424221 | 2424221 | 2022-04-19 | Nacogdoches | Texas | 48347 | 12314 | 258 |
2418894 | 2418894 | 2022-04-18 | Hancock | Indiana | 18059 | 20683 | 258 |
2419373 | 2419373 | 2022-04-18 | Cecil | Maryland | 24015 | 15532 | 258 |
2420965 | 2420965 | 2022-04-18 | Nacogdoches | Texas | 48347 | 12298 | 258 |
2415638 | 2415638 | 2022-04-17 | Hancock | Indiana | 18059 | 20665 | 258 |
2416117 | 2416117 | 2022-04-17 | Cecil | Maryland | 24015 | 15522 | 258 |
2417709 | 2417709 | 2022-04-17 | Nacogdoches | Texas | 48347 | 12290 | 258 |
2412382 | 2412382 | 2022-04-16 | Hancock | Indiana | 18059 | 20665 | 258 |
2412861 | 2412861 | 2022-04-16 | Cecil | Maryland | 24015 | 15522 | 258 |
2414453 | 2414453 | 2022-04-16 | Nacogdoches | Texas | 48347 | 12290 | 258 |
2409126 | 2409126 | 2022-04-15 | Hancock | Indiana | 18059 | 20665 | 258 |
2409605 | 2409605 | 2022-04-15 | Cecil | Maryland | 24015 | 15522 | 258 |
2411197 | 2411197 | 2022-04-15 | Nacogdoches | Texas | 48347 | 12290 | 258 |
2405870 | 2405870 | 2022-04-14 | Hancock | Indiana | 18059 | 20665 | 258 |
2406349 | 2406349 | 2022-04-14 | Cecil | Maryland | 24015 | 15514 | 258 |
2407941 | 2407941 | 2022-04-14 | Nacogdoches | Texas | 48347 | 12290 | 258 |
2402615 | 2402615 | 2022-04-13 | Hancock | Indiana | 18059 | 20665 | 258 |
2403093 | 2403093 | 2022-04-13 | Cecil | Maryland | 24015 | 15500 | 258 |
2404685 | 2404685 | 2022-04-13 | Nacogdoches | Texas | 48347 | 12290 | 258 |
2399360 | 2399360 | 2022-04-12 | Hancock | Indiana | 18059 | 20665 | 258 |
2399839 | 2399839 | 2022-04-12 | Cecil | Maryland | 24015 | 15496 | 258 |
2401430 | 2401430 | 2022-04-12 | Nacogdoches | Texas | 48347 | 12281 | 258 |
2396105 | 2396105 | 2022-04-11 | Hancock | Indiana | 18059 | 20665 | 258 |
2396583 | 2396583 | 2022-04-11 | Cecil | Maryland | 24015 | 15491 | 258 |
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);