ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 28007 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 |
---|---|---|---|---|---|---|---|
2500996 | 2500996 | 2022-05-13 | Attala | Mississippi | 28007 | 5361 | 113 |
2497738 | 2497738 | 2022-05-12 | Attala | Mississippi | 28007 | 5361 | 113 |
2494480 | 2494480 | 2022-05-11 | Attala | Mississippi | 28007 | 5361 | 113 |
2491222 | 2491222 | 2022-05-10 | Attala | Mississippi | 28007 | 5361 | 113 |
2487965 | 2487965 | 2022-05-09 | Attala | Mississippi | 28007 | 5361 | 113 |
2484707 | 2484707 | 2022-05-08 | Attala | Mississippi | 28007 | 5347 | 113 |
2481449 | 2481449 | 2022-05-07 | Attala | Mississippi | 28007 | 5347 | 113 |
2478191 | 2478191 | 2022-05-06 | Attala | Mississippi | 28007 | 5347 | 113 |
2474933 | 2474933 | 2022-05-05 | Attala | Mississippi | 28007 | 5347 | 113 |
2471676 | 2471676 | 2022-05-04 | Attala | Mississippi | 28007 | 5347 | 113 |
2468420 | 2468420 | 2022-05-03 | Attala | Mississippi | 28007 | 5347 | 113 |
2465165 | 2465165 | 2022-05-02 | Attala | Mississippi | 28007 | 5347 | 113 |
2461909 | 2461909 | 2022-05-01 | Attala | Mississippi | 28007 | 5338 | 113 |
2458653 | 2458653 | 2022-04-30 | Attala | Mississippi | 28007 | 5338 | 113 |
2455397 | 2455397 | 2022-04-29 | Attala | Mississippi | 28007 | 5338 | 113 |
2452141 | 2452141 | 2022-04-28 | Attala | Mississippi | 28007 | 5338 | 113 |
2448885 | 2448885 | 2022-04-27 | Attala | Mississippi | 28007 | 5338 | 113 |
2445629 | 2445629 | 2022-04-26 | Attala | Mississippi | 28007 | 5338 | 113 |
2442373 | 2442373 | 2022-04-25 | Attala | Mississippi | 28007 | 5321 | 113 |
2439117 | 2439117 | 2022-04-24 | Attala | Mississippi | 28007 | 5321 | 113 |
2435861 | 2435861 | 2022-04-23 | Attala | Mississippi | 28007 | 5321 | 113 |
2432605 | 2432605 | 2022-04-22 | Attala | Mississippi | 28007 | 5321 | 113 |
2429349 | 2429349 | 2022-04-21 | Attala | Mississippi | 28007 | 5321 | 113 |
2426093 | 2426093 | 2022-04-20 | Attala | Mississippi | 28007 | 5321 | 113 |
2422837 | 2422837 | 2022-04-19 | Attala | Mississippi | 28007 | 5321 | 113 |
2419581 | 2419581 | 2022-04-18 | Attala | Mississippi | 28007 | 5321 | 113 |
2416325 | 2416325 | 2022-04-17 | Attala | Mississippi | 28007 | 5319 | 113 |
2413069 | 2413069 | 2022-04-16 | Attala | Mississippi | 28007 | 5319 | 113 |
2409813 | 2409813 | 2022-04-15 | Attala | Mississippi | 28007 | 5319 | 113 |
2406557 | 2406557 | 2022-04-14 | Attala | Mississippi | 28007 | 5319 | 113 |
2403301 | 2403301 | 2022-04-13 | Attala | Mississippi | 28007 | 5319 | 113 |
2400047 | 2400047 | 2022-04-12 | Attala | Mississippi | 28007 | 5319 | 113 |
2396791 | 2396791 | 2022-04-11 | Attala | Mississippi | 28007 | 5310 | 113 |
2393536 | 2393536 | 2022-04-10 | Attala | Mississippi | 28007 | 5310 | 113 |
2390280 | 2390280 | 2022-04-09 | Attala | Mississippi | 28007 | 5310 | 113 |
2387024 | 2387024 | 2022-04-08 | Attala | Mississippi | 28007 | 5310 | 113 |
2383769 | 2383769 | 2022-04-07 | Attala | Mississippi | 28007 | 5310 | 113 |
2380514 | 2380514 | 2022-04-06 | Attala | Mississippi | 28007 | 5310 | 113 |
2377259 | 2377259 | 2022-04-05 | Attala | Mississippi | 28007 | 5310 | 113 |
2374007 | 2374007 | 2022-04-04 | Attala | Mississippi | 28007 | 5310 | 113 |
2370754 | 2370754 | 2022-04-03 | Attala | Mississippi | 28007 | 5285 | 113 |
2367501 | 2367501 | 2022-04-02 | Attala | Mississippi | 28007 | 5285 | 113 |
2364248 | 2364248 | 2022-04-01 | Attala | Mississippi | 28007 | 5285 | 113 |
2360994 | 2360994 | 2022-03-31 | Attala | Mississippi | 28007 | 5285 | 113 |
2357740 | 2357740 | 2022-03-30 | Attala | Mississippi | 28007 | 5285 | 113 |
2354487 | 2354487 | 2022-03-29 | Attala | Mississippi | 28007 | 5285 | 113 |
2351235 | 2351235 | 2022-03-28 | Attala | Mississippi | 28007 | 5285 | 113 |
2347982 | 2347982 | 2022-03-27 | Attala | Mississippi | 28007 | 5282 | 112 |
2344729 | 2344729 | 2022-03-26 | Attala | Mississippi | 28007 | 5282 | 112 |
2341476 | 2341476 | 2022-03-25 | Attala | Mississippi | 28007 | 5282 | 112 |
2338223 | 2338223 | 2022-03-24 | Attala | Mississippi | 28007 | 5282 | 112 |
2334969 | 2334969 | 2022-03-23 | Attala | Mississippi | 28007 | 5282 | 112 |
2331715 | 2331715 | 2022-03-22 | Attala | Mississippi | 28007 | 5282 | 112 |
2328463 | 2328463 | 2022-03-21 | Attala | Mississippi | 28007 | 5282 | 112 |
2325210 | 2325210 | 2022-03-20 | Attala | Mississippi | 28007 | 5265 | 112 |
2321956 | 2321956 | 2022-03-19 | Attala | Mississippi | 28007 | 5265 | 112 |
2318702 | 2318702 | 2022-03-18 | Attala | Mississippi | 28007 | 5265 | 112 |
2315449 | 2315449 | 2022-03-17 | Attala | Mississippi | 28007 | 5265 | 112 |
2312196 | 2312196 | 2022-03-16 | Attala | Mississippi | 28007 | 5265 | 112 |
2308943 | 2308943 | 2022-03-15 | Attala | Mississippi | 28007 | 5265 | 112 |
2305692 | 2305692 | 2022-03-14 | Attala | Mississippi | 28007 | 5265 | 112 |
2302440 | 2302440 | 2022-03-13 | Attala | Mississippi | 28007 | 5253 | 111 |
2299188 | 2299188 | 2022-03-12 | Attala | Mississippi | 28007 | 5253 | 111 |
2295936 | 2295936 | 2022-03-11 | Attala | Mississippi | 28007 | 5253 | 111 |
2292684 | 2292684 | 2022-03-10 | Attala | Mississippi | 28007 | 5253 | 111 |
2289432 | 2289432 | 2022-03-09 | Attala | Mississippi | 28007 | 5253 | 111 |
2286181 | 2286181 | 2022-03-08 | Attala | Mississippi | 28007 | 5253 | 111 |
2282929 | 2282929 | 2022-03-07 | Attala | Mississippi | 28007 | 5247 | 111 |
2279676 | 2279676 | 2022-03-06 | Attala | Mississippi | 28007 | 5240 | 111 |
2276423 | 2276423 | 2022-03-05 | Attala | Mississippi | 28007 | 5240 | 111 |
2273170 | 2273170 | 2022-03-04 | Attala | Mississippi | 28007 | 5240 | 111 |
2269918 | 2269918 | 2022-03-03 | Attala | Mississippi | 28007 | 5238 | 111 |
2266665 | 2266665 | 2022-03-02 | Attala | Mississippi | 28007 | 5231 | 111 |
2263414 | 2263414 | 2022-03-01 | Attala | Mississippi | 28007 | 5227 | 111 |
2260163 | 2260163 | 2022-02-28 | Attala | Mississippi | 28007 | 5227 | 110 |
2256912 | 2256912 | 2022-02-27 | Attala | Mississippi | 28007 | 5223 | 110 |
2253661 | 2253661 | 2022-02-26 | Attala | Mississippi | 28007 | 5223 | 110 |
2250410 | 2250410 | 2022-02-25 | Attala | Mississippi | 28007 | 5223 | 110 |
2247159 | 2247159 | 2022-02-24 | Attala | Mississippi | 28007 | 5213 | 110 |
2243908 | 2243908 | 2022-02-23 | Attala | Mississippi | 28007 | 5203 | 110 |
2240657 | 2240657 | 2022-02-22 | Attala | Mississippi | 28007 | 5199 | 107 |
2237406 | 2237406 | 2022-02-21 | Attala | Mississippi | 28007 | 5181 | 107 |
2234155 | 2234155 | 2022-02-20 | Attala | Mississippi | 28007 | 5181 | 107 |
2230904 | 2230904 | 2022-02-19 | Attala | Mississippi | 28007 | 5181 | 107 |
2227653 | 2227653 | 2022-02-18 | Attala | Mississippi | 28007 | 5181 | 107 |
2224402 | 2224402 | 2022-02-17 | Attala | Mississippi | 28007 | 5177 | 106 |
2221151 | 2221151 | 2022-02-16 | Attala | Mississippi | 28007 | 5175 | 106 |
2217900 | 2217900 | 2022-02-15 | Attala | Mississippi | 28007 | 5167 | 105 |
2214649 | 2214649 | 2022-02-14 | Attala | Mississippi | 28007 | 5148 | 105 |
2211397 | 2211397 | 2022-02-13 | Attala | Mississippi | 28007 | 4804 | 105 |
2208144 | 2208144 | 2022-02-12 | Attala | Mississippi | 28007 | 4804 | 105 |
2204891 | 2204891 | 2022-02-11 | Attala | Mississippi | 28007 | 4804 | 105 |
2201638 | 2201638 | 2022-02-10 | Attala | Mississippi | 28007 | 4741 | 104 |
2198384 | 2198384 | 2022-02-09 | Attala | Mississippi | 28007 | 4737 | 102 |
2195130 | 2195130 | 2022-02-08 | Attala | Mississippi | 28007 | 4728 | 99 |
2191876 | 2191876 | 2022-02-07 | Attala | Mississippi | 28007 | 4721 | 98 |
2188623 | 2188623 | 2022-02-06 | Attala | Mississippi | 28007 | 4603 | 98 |
2185370 | 2185370 | 2022-02-05 | Attala | Mississippi | 28007 | 4603 | 98 |
2182118 | 2182118 | 2022-02-04 | Attala | Mississippi | 28007 | 4603 | 98 |
2178866 | 2178866 | 2022-02-03 | Attala | Mississippi | 28007 | 4514 | 98 |
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);