ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,555 rows where county = "Covington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499594 | 2499594 | 2022-05-13 | Covington | Alabama | 1039 | 9355 | 232 |
2501008 | 2501008 | 2022-05-13 | Covington | Mississippi | 28031 | 7086 | 113 |
2496336 | 2496336 | 2022-05-12 | Covington | Alabama | 1039 | 9354 | 232 |
2497750 | 2497750 | 2022-05-12 | Covington | Mississippi | 28031 | 7086 | 113 |
2493078 | 2493078 | 2022-05-11 | Covington | Alabama | 1039 | 9355 | 232 |
2494492 | 2494492 | 2022-05-11 | Covington | Mississippi | 28031 | 7086 | 113 |
2489820 | 2489820 | 2022-05-10 | Covington | Alabama | 1039 | 9350 | 232 |
2491234 | 2491234 | 2022-05-10 | Covington | Mississippi | 28031 | 7086 | 113 |
2486563 | 2486563 | 2022-05-09 | Covington | Alabama | 1039 | 9348 | 232 |
2487977 | 2487977 | 2022-05-09 | Covington | Mississippi | 28031 | 7086 | 113 |
2483305 | 2483305 | 2022-05-08 | Covington | Alabama | 1039 | 9343 | 232 |
2484719 | 2484719 | 2022-05-08 | Covington | Mississippi | 28031 | 7080 | 113 |
2480047 | 2480047 | 2022-05-07 | Covington | Alabama | 1039 | 9343 | 232 |
2481461 | 2481461 | 2022-05-07 | Covington | Mississippi | 28031 | 7080 | 113 |
2476789 | 2476789 | 2022-05-06 | Covington | Alabama | 1039 | 9343 | 232 |
2478203 | 2478203 | 2022-05-06 | Covington | Mississippi | 28031 | 7080 | 113 |
2473531 | 2473531 | 2022-05-05 | Covington | Alabama | 1039 | 9343 | 232 |
2474945 | 2474945 | 2022-05-05 | Covington | Mississippi | 28031 | 7080 | 113 |
2470274 | 2470274 | 2022-05-04 | Covington | Alabama | 1039 | 9341 | 232 |
2471688 | 2471688 | 2022-05-04 | Covington | Mississippi | 28031 | 7080 | 113 |
2467018 | 2467018 | 2022-05-03 | Covington | Alabama | 1039 | 9340 | 232 |
2468432 | 2468432 | 2022-05-03 | Covington | Mississippi | 28031 | 7080 | 113 |
2463763 | 2463763 | 2022-05-02 | Covington | Alabama | 1039 | 9337 | 232 |
2465177 | 2465177 | 2022-05-02 | Covington | Mississippi | 28031 | 7080 | 113 |
2460507 | 2460507 | 2022-05-01 | Covington | Alabama | 1039 | 9333 | 232 |
2461921 | 2461921 | 2022-05-01 | Covington | Mississippi | 28031 | 7075 | 113 |
2457251 | 2457251 | 2022-04-30 | Covington | Alabama | 1039 | 9333 | 232 |
2458665 | 2458665 | 2022-04-30 | Covington | Mississippi | 28031 | 7075 | 113 |
2453995 | 2453995 | 2022-04-29 | Covington | Alabama | 1039 | 9333 | 232 |
2455409 | 2455409 | 2022-04-29 | Covington | Mississippi | 28031 | 7075 | 113 |
2450739 | 2450739 | 2022-04-28 | Covington | Alabama | 1039 | 9333 | 232 |
2452153 | 2452153 | 2022-04-28 | Covington | Mississippi | 28031 | 7075 | 113 |
2447483 | 2447483 | 2022-04-27 | Covington | Alabama | 1039 | 9333 | 232 |
2448897 | 2448897 | 2022-04-27 | Covington | Mississippi | 28031 | 7075 | 113 |
2444227 | 2444227 | 2022-04-26 | Covington | Alabama | 1039 | 9333 | 232 |
2445641 | 2445641 | 2022-04-26 | Covington | Mississippi | 28031 | 7075 | 113 |
2440971 | 2440971 | 2022-04-25 | Covington | Alabama | 1039 | 9328 | 232 |
2442385 | 2442385 | 2022-04-25 | Covington | Mississippi | 28031 | 7072 | 113 |
2437715 | 2437715 | 2022-04-24 | Covington | Alabama | 1039 | 9327 | 232 |
2439129 | 2439129 | 2022-04-24 | Covington | Mississippi | 28031 | 7072 | 113 |
2434459 | 2434459 | 2022-04-23 | Covington | Alabama | 1039 | 9327 | 232 |
2435873 | 2435873 | 2022-04-23 | Covington | Mississippi | 28031 | 7072 | 113 |
2431203 | 2431203 | 2022-04-22 | Covington | Alabama | 1039 | 9327 | 232 |
2432617 | 2432617 | 2022-04-22 | Covington | Mississippi | 28031 | 7072 | 113 |
2427947 | 2427947 | 2022-04-21 | Covington | Alabama | 1039 | 9327 | 231 |
2429361 | 2429361 | 2022-04-21 | Covington | Mississippi | 28031 | 7072 | 113 |
2424691 | 2424691 | 2022-04-20 | Covington | Alabama | 1039 | 9323 | 231 |
2426105 | 2426105 | 2022-04-20 | Covington | Mississippi | 28031 | 7072 | 113 |
2421435 | 2421435 | 2022-04-19 | Covington | Alabama | 1039 | 9314 | 231 |
2422849 | 2422849 | 2022-04-19 | Covington | Mississippi | 28031 | 7072 | 113 |
2418179 | 2418179 | 2022-04-18 | Covington | Alabama | 1039 | 9311 | 231 |
2419593 | 2419593 | 2022-04-18 | Covington | Mississippi | 28031 | 7072 | 113 |
2414923 | 2414923 | 2022-04-17 | Covington | Alabama | 1039 | 9311 | 231 |
2416337 | 2416337 | 2022-04-17 | Covington | Mississippi | 28031 | 7072 | 113 |
2411667 | 2411667 | 2022-04-16 | Covington | Alabama | 1039 | 9311 | 231 |
2413081 | 2413081 | 2022-04-16 | Covington | Mississippi | 28031 | 7072 | 113 |
2408411 | 2408411 | 2022-04-15 | Covington | Alabama | 1039 | 9311 | 231 |
2409825 | 2409825 | 2022-04-15 | Covington | Mississippi | 28031 | 7072 | 113 |
2405155 | 2405155 | 2022-04-14 | Covington | Alabama | 1039 | 9309 | 231 |
2406569 | 2406569 | 2022-04-14 | Covington | Mississippi | 28031 | 7072 | 113 |
2401900 | 2401900 | 2022-04-13 | Covington | Alabama | 1039 | 9309 | 230 |
2403313 | 2403313 | 2022-04-13 | Covington | Mississippi | 28031 | 7072 | 113 |
2398645 | 2398645 | 2022-04-12 | Covington | Alabama | 1039 | 9309 | 229 |
2400059 | 2400059 | 2022-04-12 | Covington | Mississippi | 28031 | 7072 | 113 |
2395390 | 2395390 | 2022-04-11 | Covington | Alabama | 1039 | 9307 | 228 |
2396803 | 2396803 | 2022-04-11 | Covington | Mississippi | 28031 | 7068 | 113 |
2392134 | 2392134 | 2022-04-10 | Covington | Alabama | 1039 | 9306 | 228 |
2393548 | 2393548 | 2022-04-10 | Covington | Mississippi | 28031 | 7068 | 113 |
2388878 | 2388878 | 2022-04-09 | Covington | Alabama | 1039 | 9306 | 228 |
2390292 | 2390292 | 2022-04-09 | Covington | Mississippi | 28031 | 7068 | 113 |
2385623 | 2385623 | 2022-04-08 | Covington | Alabama | 1039 | 9306 | 228 |
2387036 | 2387036 | 2022-04-08 | Covington | Mississippi | 28031 | 7068 | 113 |
2382368 | 2382368 | 2022-04-07 | Covington | Alabama | 1039 | 9305 | 228 |
2383781 | 2383781 | 2022-04-07 | Covington | Mississippi | 28031 | 7068 | 113 |
2379113 | 2379113 | 2022-04-06 | Covington | Alabama | 1039 | 9305 | 228 |
2380526 | 2380526 | 2022-04-06 | Covington | Mississippi | 28031 | 7068 | 113 |
2375859 | 2375859 | 2022-04-05 | Covington | Alabama | 1039 | 9305 | 228 |
2377271 | 2377271 | 2022-04-05 | Covington | Mississippi | 28031 | 7068 | 113 |
2372607 | 2372607 | 2022-04-04 | Covington | Alabama | 1039 | 9304 | 228 |
2374019 | 2374019 | 2022-04-04 | Covington | Mississippi | 28031 | 7068 | 113 |
2369354 | 2369354 | 2022-04-03 | Covington | Alabama | 1039 | 9302 | 228 |
2370766 | 2370766 | 2022-04-03 | Covington | Mississippi | 28031 | 7067 | 111 |
2366101 | 2366101 | 2022-04-02 | Covington | Alabama | 1039 | 9302 | 228 |
2367513 | 2367513 | 2022-04-02 | Covington | Mississippi | 28031 | 7067 | 111 |
2362848 | 2362848 | 2022-04-01 | Covington | Alabama | 1039 | 9302 | 228 |
2364260 | 2364260 | 2022-04-01 | Covington | Mississippi | 28031 | 7067 | 111 |
2359594 | 2359594 | 2022-03-31 | Covington | Alabama | 1039 | 9302 | 228 |
2361006 | 2361006 | 2022-03-31 | Covington | Mississippi | 28031 | 7067 | 111 |
2356340 | 2356340 | 2022-03-30 | Covington | Alabama | 1039 | 9301 | 228 |
2357752 | 2357752 | 2022-03-30 | Covington | Mississippi | 28031 | 7067 | 111 |
2353087 | 2353087 | 2022-03-29 | Covington | Alabama | 1039 | 9300 | 228 |
2354499 | 2354499 | 2022-03-29 | Covington | Mississippi | 28031 | 7067 | 111 |
2349835 | 2349835 | 2022-03-28 | Covington | Alabama | 1039 | 9300 | 227 |
2351247 | 2351247 | 2022-03-28 | Covington | Mississippi | 28031 | 7067 | 111 |
2346582 | 2346582 | 2022-03-27 | Covington | Alabama | 1039 | 9277 | 226 |
2347994 | 2347994 | 2022-03-27 | Covington | Mississippi | 28031 | 7061 | 110 |
2343329 | 2343329 | 2022-03-26 | Covington | Alabama | 1039 | 9277 | 226 |
2344741 | 2344741 | 2022-03-26 | Covington | Mississippi | 28031 | 7061 | 110 |
2340076 | 2340076 | 2022-03-25 | Covington | Alabama | 1039 | 9277 | 226 |
2341488 | 2341488 | 2022-03-25 | Covington | Mississippi | 28031 | 7061 | 110 |
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);