ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where county = "Lawrence" and deaths = 56 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 6
- Mississippi 67
- Arkansas 12
- Kentucky 7
- South Dakota 4
- Indiana 2
- Pennsylvania 1
county 1
- Lawrence · 93 ✖
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 |
2220797 | 2220797 | 2022-02-16 | Lawrence | Kentucky | 21127 | 4269 | 56 |
2217546 | 2217546 | 2022-02-15 | Lawrence | Kentucky | 21127 | 4242 | 56 |
2214295 | 2214295 | 2022-02-14 | Lawrence | Kentucky | 21127 | 4219 | 56 |
2211043 | 2211043 | 2022-02-13 | Lawrence | Kentucky | 21127 | 4168 | 56 |
2207790 | 2207790 | 2022-02-12 | Lawrence | Kentucky | 21127 | 4168 | 56 |
2204537 | 2204537 | 2022-02-11 | Lawrence | Kentucky | 21127 | 4168 | 56 |
2201284 | 2201284 | 2022-02-10 | Lawrence | Kentucky | 21127 | 4135 | 56 |
1852504 | 1852504 | 2021-10-26 | Lawrence | Arkansas | 5075 | 3269 | 56 |
1849255 | 1849255 | 2021-10-25 | Lawrence | Arkansas | 5075 | 3263 | 56 |
1846005 | 1846005 | 2021-10-24 | Lawrence | Arkansas | 5075 | 3261 | 56 |
1842755 | 1842755 | 2021-10-23 | Lawrence | Arkansas | 5075 | 3260 | 56 |
1839505 | 1839505 | 2021-10-22 | Lawrence | Arkansas | 5075 | 3256 | 56 |
1836256 | 1836256 | 2021-10-21 | Lawrence | Arkansas | 5075 | 3255 | 56 |
1833007 | 1833007 | 2021-10-20 | Lawrence | Arkansas | 5075 | 3250 | 56 |
1829758 | 1829758 | 2021-10-19 | Lawrence | Arkansas | 5075 | 3241 | 56 |
1826509 | 1826509 | 2021-10-18 | Lawrence | Arkansas | 5075 | 3238 | 56 |
1823260 | 1823260 | 2021-10-17 | Lawrence | Arkansas | 5075 | 3238 | 56 |
1825614 | 1825614 | 2021-10-17 | Lawrence | South Dakota | 46081 | 4223 | 56 |
1820011 | 1820011 | 2021-10-16 | Lawrence | Arkansas | 5075 | 3233 | 56 |
1822365 | 1822365 | 2021-10-16 | Lawrence | South Dakota | 46081 | 4223 | 56 |
1816762 | 1816762 | 2021-10-15 | Lawrence | Arkansas | 5075 | 3229 | 56 |
1819116 | 1819116 | 2021-10-15 | Lawrence | South Dakota | 46081 | 4223 | 56 |
1815867 | 1815867 | 2021-10-14 | Lawrence | South Dakota | 46081 | 4221 | 56 |
810841 | 810841 | 2020-12-09 | Lawrence | Indiana | 18093 | 2321 | 56 |
807596 | 807596 | 2020-12-08 | Lawrence | Indiana | 18093 | 2279 | 56 |
740992 | 740992 | 2020-11-17 | Lawrence | Pennsylvania | 42073 | 1645 | 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);