ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where county = "Lawrence", deaths = 56 and fips = 28077 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501031 | 2501031 | 2022-05-13 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2497773 | 2497773 | 2022-05-12 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2494515 | 2494515 | 2022-05-11 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2491257 | 2491257 | 2022-05-10 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2488000 | 2488000 | 2022-05-09 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2484742 | 2484742 | 2022-05-08 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2481484 | 2481484 | 2022-05-07 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2478226 | 2478226 | 2022-05-06 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2474968 | 2474968 | 2022-05-05 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2471711 | 2471711 | 2022-05-04 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2468455 | 2468455 | 2022-05-03 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2465200 | 2465200 | 2022-05-02 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2461944 | 2461944 | 2022-05-01 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2458688 | 2458688 | 2022-04-30 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2455432 | 2455432 | 2022-04-29 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2452176 | 2452176 | 2022-04-28 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2448920 | 2448920 | 2022-04-27 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2445664 | 2445664 | 2022-04-26 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2442408 | 2442408 | 2022-04-25 | Lawrence | Mississippi | 28077 | 3588 | 56 |
2439152 | 2439152 | 2022-04-24 | Lawrence | Mississippi | 28077 | 3588 | 56 |
2435896 | 2435896 | 2022-04-23 | Lawrence | Mississippi | 28077 | 3588 | 56 |
2432640 | 2432640 | 2022-04-22 | Lawrence | Mississippi | 28077 | 3588 | 56 |
2429384 | 2429384 | 2022-04-21 | Lawrence | Mississippi | 28077 | 3588 | 56 |
2426128 | 2426128 | 2022-04-20 | Lawrence | Mississippi | 28077 | 3588 | 56 |
2422872 | 2422872 | 2022-04-19 | Lawrence | Mississippi | 28077 | 3588 | 56 |
2419616 | 2419616 | 2022-04-18 | Lawrence | Mississippi | 28077 | 3588 | 56 |
2416360 | 2416360 | 2022-04-17 | Lawrence | Mississippi | 28077 | 3585 | 56 |
2413104 | 2413104 | 2022-04-16 | Lawrence | Mississippi | 28077 | 3585 | 56 |
2409848 | 2409848 | 2022-04-15 | Lawrence | Mississippi | 28077 | 3585 | 56 |
2406592 | 2406592 | 2022-04-14 | Lawrence | Mississippi | 28077 | 3585 | 56 |
2403336 | 2403336 | 2022-04-13 | Lawrence | Mississippi | 28077 | 3585 | 56 |
2400082 | 2400082 | 2022-04-12 | Lawrence | Mississippi | 28077 | 3585 | 56 |
2396826 | 2396826 | 2022-04-11 | Lawrence | Mississippi | 28077 | 3582 | 56 |
2393571 | 2393571 | 2022-04-10 | Lawrence | Mississippi | 28077 | 3582 | 56 |
2390315 | 2390315 | 2022-04-09 | Lawrence | Mississippi | 28077 | 3582 | 56 |
2387059 | 2387059 | 2022-04-08 | Lawrence | Mississippi | 28077 | 3582 | 56 |
2383804 | 2383804 | 2022-04-07 | Lawrence | Mississippi | 28077 | 3582 | 56 |
2380549 | 2380549 | 2022-04-06 | Lawrence | Mississippi | 28077 | 3582 | 56 |
2377294 | 2377294 | 2022-04-05 | Lawrence | Mississippi | 28077 | 3582 | 56 |
2374042 | 2374042 | 2022-04-04 | Lawrence | Mississippi | 28077 | 3582 | 56 |
2370789 | 2370789 | 2022-04-03 | Lawrence | Mississippi | 28077 | 3580 | 56 |
2367536 | 2367536 | 2022-04-02 | Lawrence | Mississippi | 28077 | 3580 | 56 |
2364283 | 2364283 | 2022-04-01 | Lawrence | Mississippi | 28077 | 3580 | 56 |
2361029 | 2361029 | 2022-03-31 | Lawrence | Mississippi | 28077 | 3580 | 56 |
2357775 | 2357775 | 2022-03-30 | Lawrence | Mississippi | 28077 | 3580 | 56 |
2354522 | 2354522 | 2022-03-29 | Lawrence | Mississippi | 28077 | 3580 | 56 |
2351270 | 2351270 | 2022-03-28 | Lawrence | Mississippi | 28077 | 3580 | 56 |
2348017 | 2348017 | 2022-03-27 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2344764 | 2344764 | 2022-03-26 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2341511 | 2341511 | 2022-03-25 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2338258 | 2338258 | 2022-03-24 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2335004 | 2335004 | 2022-03-23 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2331750 | 2331750 | 2022-03-22 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2328498 | 2328498 | 2022-03-21 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2325245 | 2325245 | 2022-03-20 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2321991 | 2321991 | 2022-03-19 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2318737 | 2318737 | 2022-03-18 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2315484 | 2315484 | 2022-03-17 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2312231 | 2312231 | 2022-03-16 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2308978 | 2308978 | 2022-03-15 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2305727 | 2305727 | 2022-03-14 | Lawrence | Mississippi | 28077 | 3575 | 56 |
2302475 | 2302475 | 2022-03-13 | Lawrence | Mississippi | 28077 | 3572 | 56 |
2299223 | 2299223 | 2022-03-12 | Lawrence | Mississippi | 28077 | 3572 | 56 |
2295971 | 2295971 | 2022-03-11 | Lawrence | Mississippi | 28077 | 3572 | 56 |
2292719 | 2292719 | 2022-03-10 | Lawrence | Mississippi | 28077 | 3572 | 56 |
2289467 | 2289467 | 2022-03-09 | Lawrence | Mississippi | 28077 | 3572 | 56 |
2286216 | 2286216 | 2022-03-08 | Lawrence | Mississippi | 28077 | 3572 | 56 |
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);