ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Sharkey" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501055 | 2501055 | 2022-05-13 | Sharkey | Mississippi | 28125 | 953 | 26 |
2497797 | 2497797 | 2022-05-12 | Sharkey | Mississippi | 28125 | 953 | 26 |
2494539 | 2494539 | 2022-05-11 | Sharkey | Mississippi | 28125 | 953 | 26 |
2491281 | 2491281 | 2022-05-10 | Sharkey | Mississippi | 28125 | 953 | 26 |
2488024 | 2488024 | 2022-05-09 | Sharkey | Mississippi | 28125 | 953 | 26 |
2484766 | 2484766 | 2022-05-08 | Sharkey | Mississippi | 28125 | 952 | 26 |
2481508 | 2481508 | 2022-05-07 | Sharkey | Mississippi | 28125 | 952 | 26 |
2478250 | 2478250 | 2022-05-06 | Sharkey | Mississippi | 28125 | 952 | 26 |
2474992 | 2474992 | 2022-05-05 | Sharkey | Mississippi | 28125 | 952 | 26 |
2471735 | 2471735 | 2022-05-04 | Sharkey | Mississippi | 28125 | 952 | 26 |
2468479 | 2468479 | 2022-05-03 | Sharkey | Mississippi | 28125 | 952 | 26 |
2465224 | 2465224 | 2022-05-02 | Sharkey | Mississippi | 28125 | 952 | 26 |
2461968 | 2461968 | 2022-05-01 | Sharkey | Mississippi | 28125 | 952 | 26 |
2458712 | 2458712 | 2022-04-30 | Sharkey | Mississippi | 28125 | 952 | 26 |
2455456 | 2455456 | 2022-04-29 | Sharkey | Mississippi | 28125 | 952 | 26 |
2452200 | 2452200 | 2022-04-28 | Sharkey | Mississippi | 28125 | 952 | 26 |
2448944 | 2448944 | 2022-04-27 | Sharkey | Mississippi | 28125 | 952 | 26 |
2445688 | 2445688 | 2022-04-26 | Sharkey | Mississippi | 28125 | 952 | 26 |
2442432 | 2442432 | 2022-04-25 | Sharkey | Mississippi | 28125 | 952 | 26 |
2439176 | 2439176 | 2022-04-24 | Sharkey | Mississippi | 28125 | 952 | 26 |
2435920 | 2435920 | 2022-04-23 | Sharkey | Mississippi | 28125 | 952 | 26 |
2432664 | 2432664 | 2022-04-22 | Sharkey | Mississippi | 28125 | 952 | 26 |
2429408 | 2429408 | 2022-04-21 | Sharkey | Mississippi | 28125 | 952 | 26 |
2426152 | 2426152 | 2022-04-20 | Sharkey | Mississippi | 28125 | 952 | 26 |
2422896 | 2422896 | 2022-04-19 | Sharkey | Mississippi | 28125 | 952 | 26 |
2419640 | 2419640 | 2022-04-18 | Sharkey | Mississippi | 28125 | 952 | 26 |
2416384 | 2416384 | 2022-04-17 | Sharkey | Mississippi | 28125 | 952 | 26 |
2413128 | 2413128 | 2022-04-16 | Sharkey | Mississippi | 28125 | 952 | 26 |
2409872 | 2409872 | 2022-04-15 | Sharkey | Mississippi | 28125 | 952 | 26 |
2406616 | 2406616 | 2022-04-14 | Sharkey | Mississippi | 28125 | 952 | 26 |
2403360 | 2403360 | 2022-04-13 | Sharkey | Mississippi | 28125 | 952 | 26 |
2400106 | 2400106 | 2022-04-12 | Sharkey | Mississippi | 28125 | 952 | 26 |
2396850 | 2396850 | 2022-04-11 | Sharkey | Mississippi | 28125 | 952 | 26 |
2393595 | 2393595 | 2022-04-10 | Sharkey | Mississippi | 28125 | 952 | 26 |
2390339 | 2390339 | 2022-04-09 | Sharkey | Mississippi | 28125 | 952 | 26 |
2387083 | 2387083 | 2022-04-08 | Sharkey | Mississippi | 28125 | 952 | 26 |
2383828 | 2383828 | 2022-04-07 | Sharkey | Mississippi | 28125 | 952 | 26 |
2380573 | 2380573 | 2022-04-06 | Sharkey | Mississippi | 28125 | 952 | 26 |
2377318 | 2377318 | 2022-04-05 | Sharkey | Mississippi | 28125 | 952 | 26 |
2374066 | 2374066 | 2022-04-04 | Sharkey | Mississippi | 28125 | 952 | 26 |
2370813 | 2370813 | 2022-04-03 | Sharkey | Mississippi | 28125 | 952 | 26 |
2367560 | 2367560 | 2022-04-02 | Sharkey | Mississippi | 28125 | 952 | 26 |
2364307 | 2364307 | 2022-04-01 | Sharkey | Mississippi | 28125 | 952 | 26 |
2361053 | 2361053 | 2022-03-31 | Sharkey | Mississippi | 28125 | 952 | 26 |
2357799 | 2357799 | 2022-03-30 | Sharkey | Mississippi | 28125 | 952 | 26 |
2354546 | 2354546 | 2022-03-29 | Sharkey | Mississippi | 28125 | 952 | 26 |
2351294 | 2351294 | 2022-03-28 | Sharkey | Mississippi | 28125 | 952 | 26 |
2348041 | 2348041 | 2022-03-27 | Sharkey | Mississippi | 28125 | 951 | 25 |
2344788 | 2344788 | 2022-03-26 | Sharkey | Mississippi | 28125 | 951 | 25 |
2341535 | 2341535 | 2022-03-25 | Sharkey | Mississippi | 28125 | 951 | 25 |
2338282 | 2338282 | 2022-03-24 | Sharkey | Mississippi | 28125 | 951 | 25 |
2335028 | 2335028 | 2022-03-23 | Sharkey | Mississippi | 28125 | 951 | 25 |
2331774 | 2331774 | 2022-03-22 | Sharkey | Mississippi | 28125 | 951 | 25 |
2328522 | 2328522 | 2022-03-21 | Sharkey | Mississippi | 28125 | 951 | 25 |
2325269 | 2325269 | 2022-03-20 | Sharkey | Mississippi | 28125 | 951 | 25 |
2322015 | 2322015 | 2022-03-19 | Sharkey | Mississippi | 28125 | 951 | 25 |
2318761 | 2318761 | 2022-03-18 | Sharkey | Mississippi | 28125 | 951 | 25 |
2315508 | 2315508 | 2022-03-17 | Sharkey | Mississippi | 28125 | 951 | 25 |
2312255 | 2312255 | 2022-03-16 | Sharkey | Mississippi | 28125 | 951 | 25 |
2309002 | 2309002 | 2022-03-15 | Sharkey | Mississippi | 28125 | 951 | 25 |
2305751 | 2305751 | 2022-03-14 | Sharkey | Mississippi | 28125 | 951 | 25 |
2302499 | 2302499 | 2022-03-13 | Sharkey | Mississippi | 28125 | 950 | 25 |
2299247 | 2299247 | 2022-03-12 | Sharkey | Mississippi | 28125 | 950 | 25 |
2295995 | 2295995 | 2022-03-11 | Sharkey | Mississippi | 28125 | 950 | 25 |
2292743 | 2292743 | 2022-03-10 | Sharkey | Mississippi | 28125 | 950 | 25 |
2289491 | 2289491 | 2022-03-09 | Sharkey | Mississippi | 28125 | 950 | 25 |
2286240 | 2286240 | 2022-03-08 | Sharkey | Mississippi | 28125 | 950 | 25 |
2282988 | 2282988 | 2022-03-07 | Sharkey | Mississippi | 28125 | 950 | 25 |
2279735 | 2279735 | 2022-03-06 | Sharkey | Mississippi | 28125 | 950 | 25 |
2276482 | 2276482 | 2022-03-05 | Sharkey | Mississippi | 28125 | 950 | 25 |
2273229 | 2273229 | 2022-03-04 | Sharkey | Mississippi | 28125 | 950 | 25 |
2269977 | 2269977 | 2022-03-03 | Sharkey | Mississippi | 28125 | 950 | 25 |
2266724 | 2266724 | 2022-03-02 | Sharkey | Mississippi | 28125 | 950 | 25 |
2263473 | 2263473 | 2022-03-01 | Sharkey | Mississippi | 28125 | 950 | 25 |
2260222 | 2260222 | 2022-02-28 | Sharkey | Mississippi | 28125 | 950 | 25 |
2256971 | 2256971 | 2022-02-27 | Sharkey | Mississippi | 28125 | 950 | 24 |
2253720 | 2253720 | 2022-02-26 | Sharkey | Mississippi | 28125 | 950 | 24 |
2250469 | 2250469 | 2022-02-25 | Sharkey | Mississippi | 28125 | 950 | 24 |
2247218 | 2247218 | 2022-02-24 | Sharkey | Mississippi | 28125 | 950 | 24 |
2243967 | 2243967 | 2022-02-23 | Sharkey | Mississippi | 28125 | 949 | 24 |
2240716 | 2240716 | 2022-02-22 | Sharkey | Mississippi | 28125 | 946 | 23 |
2237465 | 2237465 | 2022-02-21 | Sharkey | Mississippi | 28125 | 946 | 23 |
2234214 | 2234214 | 2022-02-20 | Sharkey | Mississippi | 28125 | 946 | 23 |
2230963 | 2230963 | 2022-02-19 | Sharkey | Mississippi | 28125 | 946 | 23 |
2227712 | 2227712 | 2022-02-18 | Sharkey | Mississippi | 28125 | 946 | 23 |
2224461 | 2224461 | 2022-02-17 | Sharkey | Mississippi | 28125 | 941 | 23 |
2221210 | 2221210 | 2022-02-16 | Sharkey | Mississippi | 28125 | 939 | 23 |
2217959 | 2217959 | 2022-02-15 | Sharkey | Mississippi | 28125 | 936 | 23 |
2214708 | 2214708 | 2022-02-14 | Sharkey | Mississippi | 28125 | 936 | 23 |
2211456 | 2211456 | 2022-02-13 | Sharkey | Mississippi | 28125 | 935 | 23 |
2208203 | 2208203 | 2022-02-12 | Sharkey | Mississippi | 28125 | 935 | 23 |
2204950 | 2204950 | 2022-02-11 | Sharkey | Mississippi | 28125 | 935 | 23 |
2201697 | 2201697 | 2022-02-10 | Sharkey | Mississippi | 28125 | 931 | 22 |
2198443 | 2198443 | 2022-02-09 | Sharkey | Mississippi | 28125 | 929 | 22 |
2195189 | 2195189 | 2022-02-08 | Sharkey | Mississippi | 28125 | 927 | 22 |
2191935 | 2191935 | 2022-02-07 | Sharkey | Mississippi | 28125 | 926 | 21 |
2188682 | 2188682 | 2022-02-06 | Sharkey | Mississippi | 28125 | 906 | 21 |
2185429 | 2185429 | 2022-02-05 | Sharkey | Mississippi | 28125 | 906 | 21 |
2182177 | 2182177 | 2022-02-04 | Sharkey | Mississippi | 28125 | 906 | 21 |
2178925 | 2178925 | 2022-02-03 | Sharkey | Mississippi | 28125 | 893 | 22 |
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);