ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 28107 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 |
---|---|---|---|---|---|---|---|
2501046 | 2501046 | 2022-05-13 | Panola | Mississippi | 28107 | 10566 | 169 |
2497788 | 2497788 | 2022-05-12 | Panola | Mississippi | 28107 | 10566 | 169 |
2494530 | 2494530 | 2022-05-11 | Panola | Mississippi | 28107 | 10566 | 169 |
2491272 | 2491272 | 2022-05-10 | Panola | Mississippi | 28107 | 10566 | 169 |
2488015 | 2488015 | 2022-05-09 | Panola | Mississippi | 28107 | 10566 | 169 |
2484757 | 2484757 | 2022-05-08 | Panola | Mississippi | 28107 | 10539 | 169 |
2481499 | 2481499 | 2022-05-07 | Panola | Mississippi | 28107 | 10539 | 169 |
2478241 | 2478241 | 2022-05-06 | Panola | Mississippi | 28107 | 10539 | 169 |
2474983 | 2474983 | 2022-05-05 | Panola | Mississippi | 28107 | 10539 | 169 |
2471726 | 2471726 | 2022-05-04 | Panola | Mississippi | 28107 | 10539 | 169 |
2468470 | 2468470 | 2022-05-03 | Panola | Mississippi | 28107 | 10539 | 169 |
2465215 | 2465215 | 2022-05-02 | Panola | Mississippi | 28107 | 10539 | 169 |
2461959 | 2461959 | 2022-05-01 | Panola | Mississippi | 28107 | 10526 | 169 |
2458703 | 2458703 | 2022-04-30 | Panola | Mississippi | 28107 | 10526 | 169 |
2455447 | 2455447 | 2022-04-29 | Panola | Mississippi | 28107 | 10526 | 169 |
2452191 | 2452191 | 2022-04-28 | Panola | Mississippi | 28107 | 10526 | 169 |
2448935 | 2448935 | 2022-04-27 | Panola | Mississippi | 28107 | 10526 | 169 |
2445679 | 2445679 | 2022-04-26 | Panola | Mississippi | 28107 | 10526 | 169 |
2442423 | 2442423 | 2022-04-25 | Panola | Mississippi | 28107 | 10521 | 169 |
2439167 | 2439167 | 2022-04-24 | Panola | Mississippi | 28107 | 10521 | 169 |
2435911 | 2435911 | 2022-04-23 | Panola | Mississippi | 28107 | 10521 | 169 |
2432655 | 2432655 | 2022-04-22 | Panola | Mississippi | 28107 | 10521 | 169 |
2429399 | 2429399 | 2022-04-21 | Panola | Mississippi | 28107 | 10521 | 169 |
2426143 | 2426143 | 2022-04-20 | Panola | Mississippi | 28107 | 10521 | 169 |
2422887 | 2422887 | 2022-04-19 | Panola | Mississippi | 28107 | 10521 | 169 |
2419631 | 2419631 | 2022-04-18 | Panola | Mississippi | 28107 | 10521 | 169 |
2416375 | 2416375 | 2022-04-17 | Panola | Mississippi | 28107 | 10520 | 169 |
2413119 | 2413119 | 2022-04-16 | Panola | Mississippi | 28107 | 10520 | 169 |
2409863 | 2409863 | 2022-04-15 | Panola | Mississippi | 28107 | 10520 | 169 |
2406607 | 2406607 | 2022-04-14 | Panola | Mississippi | 28107 | 10520 | 169 |
2403351 | 2403351 | 2022-04-13 | Panola | Mississippi | 28107 | 10520 | 169 |
2400097 | 2400097 | 2022-04-12 | Panola | Mississippi | 28107 | 10520 | 169 |
2396841 | 2396841 | 2022-04-11 | Panola | Mississippi | 28107 | 10498 | 169 |
2393586 | 2393586 | 2022-04-10 | Panola | Mississippi | 28107 | 10498 | 169 |
2390330 | 2390330 | 2022-04-09 | Panola | Mississippi | 28107 | 10498 | 169 |
2387074 | 2387074 | 2022-04-08 | Panola | Mississippi | 28107 | 10498 | 169 |
2383819 | 2383819 | 2022-04-07 | Panola | Mississippi | 28107 | 10498 | 169 |
2380564 | 2380564 | 2022-04-06 | Panola | Mississippi | 28107 | 10498 | 169 |
2377309 | 2377309 | 2022-04-05 | Panola | Mississippi | 28107 | 10498 | 169 |
2374057 | 2374057 | 2022-04-04 | Panola | Mississippi | 28107 | 10498 | 169 |
2370804 | 2370804 | 2022-04-03 | Panola | Mississippi | 28107 | 10479 | 169 |
2367551 | 2367551 | 2022-04-02 | Panola | Mississippi | 28107 | 10479 | 169 |
2364298 | 2364298 | 2022-04-01 | Panola | Mississippi | 28107 | 10479 | 169 |
2361044 | 2361044 | 2022-03-31 | Panola | Mississippi | 28107 | 10479 | 169 |
2357790 | 2357790 | 2022-03-30 | Panola | Mississippi | 28107 | 10479 | 169 |
2354537 | 2354537 | 2022-03-29 | Panola | Mississippi | 28107 | 10479 | 169 |
2351285 | 2351285 | 2022-03-28 | Panola | Mississippi | 28107 | 10479 | 169 |
2348032 | 2348032 | 2022-03-27 | Panola | Mississippi | 28107 | 10459 | 168 |
2344779 | 2344779 | 2022-03-26 | Panola | Mississippi | 28107 | 10459 | 168 |
2341526 | 2341526 | 2022-03-25 | Panola | Mississippi | 28107 | 10459 | 168 |
2338273 | 2338273 | 2022-03-24 | Panola | Mississippi | 28107 | 10459 | 168 |
2335019 | 2335019 | 2022-03-23 | Panola | Mississippi | 28107 | 10459 | 168 |
2331765 | 2331765 | 2022-03-22 | Panola | Mississippi | 28107 | 10459 | 168 |
2328513 | 2328513 | 2022-03-21 | Panola | Mississippi | 28107 | 10459 | 168 |
2325260 | 2325260 | 2022-03-20 | Panola | Mississippi | 28107 | 10393 | 167 |
2322006 | 2322006 | 2022-03-19 | Panola | Mississippi | 28107 | 10393 | 167 |
2318752 | 2318752 | 2022-03-18 | Panola | Mississippi | 28107 | 10393 | 167 |
2315499 | 2315499 | 2022-03-17 | Panola | Mississippi | 28107 | 10393 | 167 |
2312246 | 2312246 | 2022-03-16 | Panola | Mississippi | 28107 | 10393 | 167 |
2308993 | 2308993 | 2022-03-15 | Panola | Mississippi | 28107 | 10393 | 167 |
2305742 | 2305742 | 2022-03-14 | Panola | Mississippi | 28107 | 10393 | 167 |
2302490 | 2302490 | 2022-03-13 | Panola | Mississippi | 28107 | 10368 | 167 |
2299238 | 2299238 | 2022-03-12 | Panola | Mississippi | 28107 | 10368 | 167 |
2295986 | 2295986 | 2022-03-11 | Panola | Mississippi | 28107 | 10368 | 167 |
2292734 | 2292734 | 2022-03-10 | Panola | Mississippi | 28107 | 10368 | 167 |
2289482 | 2289482 | 2022-03-09 | Panola | Mississippi | 28107 | 10368 | 167 |
2286231 | 2286231 | 2022-03-08 | Panola | Mississippi | 28107 | 10368 | 167 |
2282979 | 2282979 | 2022-03-07 | Panola | Mississippi | 28107 | 10365 | 167 |
2279726 | 2279726 | 2022-03-06 | Panola | Mississippi | 28107 | 10364 | 167 |
2276473 | 2276473 | 2022-03-05 | Panola | Mississippi | 28107 | 10364 | 167 |
2273220 | 2273220 | 2022-03-04 | Panola | Mississippi | 28107 | 10364 | 167 |
2269968 | 2269968 | 2022-03-03 | Panola | Mississippi | 28107 | 10363 | 165 |
2266715 | 2266715 | 2022-03-02 | Panola | Mississippi | 28107 | 10360 | 165 |
2263464 | 2263464 | 2022-03-01 | Panola | Mississippi | 28107 | 10359 | 165 |
2260213 | 2260213 | 2022-02-28 | Panola | Mississippi | 28107 | 10357 | 164 |
2256962 | 2256962 | 2022-02-27 | Panola | Mississippi | 28107 | 10349 | 163 |
2253711 | 2253711 | 2022-02-26 | Panola | Mississippi | 28107 | 10349 | 163 |
2250460 | 2250460 | 2022-02-25 | Panola | Mississippi | 28107 | 10349 | 163 |
2247209 | 2247209 | 2022-02-24 | Panola | Mississippi | 28107 | 10328 | 163 |
2243958 | 2243958 | 2022-02-23 | Panola | Mississippi | 28107 | 10328 | 163 |
2240707 | 2240707 | 2022-02-22 | Panola | Mississippi | 28107 | 10325 | 160 |
2237456 | 2237456 | 2022-02-21 | Panola | Mississippi | 28107 | 10313 | 159 |
2234205 | 2234205 | 2022-02-20 | Panola | Mississippi | 28107 | 10313 | 159 |
2230954 | 2230954 | 2022-02-19 | Panola | Mississippi | 28107 | 10313 | 159 |
2227703 | 2227703 | 2022-02-18 | Panola | Mississippi | 28107 | 10313 | 159 |
2224452 | 2224452 | 2022-02-17 | Panola | Mississippi | 28107 | 10310 | 159 |
2221201 | 2221201 | 2022-02-16 | Panola | Mississippi | 28107 | 10305 | 158 |
2217950 | 2217950 | 2022-02-15 | Panola | Mississippi | 28107 | 10297 | 157 |
2214699 | 2214699 | 2022-02-14 | Panola | Mississippi | 28107 | 10293 | 157 |
2211447 | 2211447 | 2022-02-13 | Panola | Mississippi | 28107 | 10265 | 154 |
2208194 | 2208194 | 2022-02-12 | Panola | Mississippi | 28107 | 10265 | 154 |
2204941 | 2204941 | 2022-02-11 | Panola | Mississippi | 28107 | 10265 | 154 |
2201688 | 2201688 | 2022-02-10 | Panola | Mississippi | 28107 | 10252 | 154 |
2198434 | 2198434 | 2022-02-09 | Panola | Mississippi | 28107 | 10233 | 153 |
2195180 | 2195180 | 2022-02-08 | Panola | Mississippi | 28107 | 10213 | 153 |
2191926 | 2191926 | 2022-02-07 | Panola | Mississippi | 28107 | 10191 | 150 |
2188673 | 2188673 | 2022-02-06 | Panola | Mississippi | 28107 | 9913 | 148 |
2185420 | 2185420 | 2022-02-05 | Panola | Mississippi | 28107 | 9913 | 148 |
2182168 | 2182168 | 2022-02-04 | Panola | Mississippi | 28107 | 9913 | 148 |
2178916 | 2178916 | 2022-02-03 | Panola | Mississippi | 28107 | 9838 | 146 |
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);