ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where county = "Lawrence" and deaths = 83 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502084 | 2502084 | 2022-05-13 | Lawrence | South Dakota | 46081 | 6605 | 83 |
2498826 | 2498826 | 2022-05-12 | Lawrence | South Dakota | 46081 | 6605 | 83 |
2495568 | 2495568 | 2022-05-11 | Lawrence | South Dakota | 46081 | 6605 | 83 |
2492310 | 2492310 | 2022-05-10 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2489052 | 2489052 | 2022-05-09 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2485795 | 2485795 | 2022-05-08 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2482537 | 2482537 | 2022-05-07 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2479279 | 2479279 | 2022-05-06 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2476021 | 2476021 | 2022-05-05 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2472764 | 2472764 | 2022-05-04 | Lawrence | South Dakota | 46081 | 6589 | 83 |
2469508 | 2469508 | 2022-05-03 | Lawrence | South Dakota | 46081 | 6579 | 83 |
2466252 | 2466252 | 2022-05-02 | Lawrence | South Dakota | 46081 | 6579 | 83 |
2462997 | 2462997 | 2022-05-01 | Lawrence | South Dakota | 46081 | 6579 | 83 |
2459741 | 2459741 | 2022-04-30 | Lawrence | South Dakota | 46081 | 6579 | 83 |
2456485 | 2456485 | 2022-04-29 | Lawrence | South Dakota | 46081 | 6579 | 83 |
2453229 | 2453229 | 2022-04-28 | Lawrence | South Dakota | 46081 | 6579 | 83 |
2449973 | 2449973 | 2022-04-27 | Lawrence | South Dakota | 46081 | 6579 | 83 |
2446716 | 2446716 | 2022-04-26 | Lawrence | South Dakota | 46081 | 6575 | 83 |
2443461 | 2443461 | 2022-04-25 | Lawrence | South Dakota | 46081 | 6575 | 83 |
2440205 | 2440205 | 2022-04-24 | Lawrence | South Dakota | 46081 | 6575 | 83 |
2436949 | 2436949 | 2022-04-23 | Lawrence | South Dakota | 46081 | 6575 | 83 |
2433693 | 2433693 | 2022-04-22 | Lawrence | South Dakota | 46081 | 6575 | 83 |
2430437 | 2430437 | 2022-04-21 | Lawrence | South Dakota | 46081 | 6575 | 83 |
2427181 | 2427181 | 2022-04-20 | Lawrence | South Dakota | 46081 | 6575 | 83 |
2423925 | 2423925 | 2022-04-19 | Lawrence | South Dakota | 46081 | 6570 | 83 |
2420669 | 2420669 | 2022-04-18 | Lawrence | South Dakota | 46081 | 6570 | 83 |
2417413 | 2417413 | 2022-04-17 | Lawrence | South Dakota | 46081 | 6570 | 83 |
2414157 | 2414157 | 2022-04-16 | Lawrence | South Dakota | 46081 | 6570 | 83 |
2410901 | 2410901 | 2022-04-15 | Lawrence | South Dakota | 46081 | 6570 | 83 |
2407645 | 2407645 | 2022-04-14 | Lawrence | South Dakota | 46081 | 6570 | 83 |
2404389 | 2404389 | 2022-04-13 | Lawrence | South Dakota | 46081 | 6570 | 83 |
2401134 | 2401134 | 2022-04-12 | Lawrence | South Dakota | 46081 | 6565 | 83 |
2397879 | 2397879 | 2022-04-11 | Lawrence | South Dakota | 46081 | 6565 | 83 |
2394624 | 2394624 | 2022-04-10 | Lawrence | South Dakota | 46081 | 6565 | 83 |
2391368 | 2391368 | 2022-04-09 | Lawrence | South Dakota | 46081 | 6565 | 83 |
2388112 | 2388112 | 2022-04-08 | Lawrence | South Dakota | 46081 | 6565 | 83 |
2384857 | 2384857 | 2022-04-07 | Lawrence | South Dakota | 46081 | 6565 | 83 |
2381602 | 2381602 | 2022-04-06 | Lawrence | South Dakota | 46081 | 6565 | 83 |
1360261 | 1360261 | 2021-05-27 | Lawrence | Missouri | 29109 | 3441 | 83 |
1357015 | 1357015 | 2021-05-26 | Lawrence | Missouri | 29109 | 3437 | 83 |
1353769 | 1353769 | 2021-05-25 | Lawrence | Missouri | 29109 | 3435 | 83 |
1350523 | 1350523 | 2021-05-24 | Lawrence | Missouri | 29109 | 3431 | 83 |
1347277 | 1347277 | 2021-05-23 | Lawrence | Missouri | 29109 | 3431 | 83 |
1344029 | 1344029 | 2021-05-22 | Lawrence | Missouri | 29109 | 3431 | 83 |
1340780 | 1340780 | 2021-05-21 | Lawrence | Missouri | 29109 | 3428 | 83 |
1337533 | 1337533 | 2021-05-20 | Lawrence | Missouri | 29109 | 3423 | 83 |
1334286 | 1334286 | 2021-05-19 | Lawrence | Missouri | 29109 | 3418 | 83 |
1331039 | 1331039 | 2021-05-18 | Lawrence | Missouri | 29109 | 3419 | 83 |
1098276 | 1098276 | 2021-03-07 | Lawrence | Tennessee | 47099 | 5582 | 83 |
1095028 | 1095028 | 2021-03-06 | Lawrence | Tennessee | 47099 | 5580 | 83 |
1091782 | 1091782 | 2021-03-05 | Lawrence | Tennessee | 47099 | 5578 | 83 |
1088536 | 1088536 | 2021-03-04 | Lawrence | Tennessee | 47099 | 5574 | 83 |
1082755 | 1082755 | 2021-03-03 | Lawrence | Alabama | 1079 | 2846 | 83 |
1085291 | 1085291 | 2021-03-03 | Lawrence | Tennessee | 47099 | 5571 | 83 |
1082045 | 1082045 | 2021-03-02 | Lawrence | Tennessee | 47099 | 5568 | 83 |
1078799 | 1078799 | 2021-03-01 | Lawrence | Tennessee | 47099 | 5567 | 83 |
1075554 | 1075554 | 2021-02-28 | Lawrence | Tennessee | 47099 | 5563 | 83 |
1072308 | 1072308 | 2021-02-27 | Lawrence | Tennessee | 47099 | 5559 | 83 |
1017843 | 1017843 | 2021-02-11 | Lawrence | Alabama | 1079 | 2755 | 83 |
1014598 | 1014598 | 2021-02-10 | Lawrence | Alabama | 1079 | 2746 | 83 |
969865 | 969865 | 2021-01-27 | Lawrence | Indiana | 18093 | 3964 | 83 |
966621 | 966621 | 2021-01-26 | Lawrence | Indiana | 18093 | 3954 | 83 |
963376 | 963376 | 2021-01-25 | Lawrence | Indiana | 18093 | 3940 | 83 |
960131 | 960131 | 2021-01-24 | Lawrence | Indiana | 18093 | 3932 | 83 |
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);