ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

787 rows where county = "Madison" and fips = 28089 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

fips 1

  • 28089 · 787 ✖

county 1

  • Madison · 787 ✖
Link rowid date ▲ county state fips cases deaths
2501037 2501037 2022-05-13 Madison Mississippi 28089 24189 329
2497779 2497779 2022-05-12 Madison Mississippi 28089 24189 329
2494521 2494521 2022-05-11 Madison Mississippi 28089 24189 329
2491263 2491263 2022-05-10 Madison Mississippi 28089 24189 329
2488006 2488006 2022-05-09 Madison Mississippi 28089 24189 329
2484748 2484748 2022-05-08 Madison Mississippi 28089 24113 329
2481490 2481490 2022-05-07 Madison Mississippi 28089 24113 329
2478232 2478232 2022-05-06 Madison Mississippi 28089 24113 329
2474974 2474974 2022-05-05 Madison Mississippi 28089 24113 329
2471717 2471717 2022-05-04 Madison Mississippi 28089 24113 329
2468461 2468461 2022-05-03 Madison Mississippi 28089 24113 329
2465206 2465206 2022-05-02 Madison Mississippi 28089 24113 329
2461950 2461950 2022-05-01 Madison Mississippi 28089 24079 329
2458694 2458694 2022-04-30 Madison Mississippi 28089 24079 329
2455438 2455438 2022-04-29 Madison Mississippi 28089 24079 329
2452182 2452182 2022-04-28 Madison Mississippi 28089 24079 329
2448926 2448926 2022-04-27 Madison Mississippi 28089 24079 329
2445670 2445670 2022-04-26 Madison Mississippi 28089 24079 329
2442414 2442414 2022-04-25 Madison Mississippi 28089 24040 328
2439158 2439158 2022-04-24 Madison Mississippi 28089 24040 328
2435902 2435902 2022-04-23 Madison Mississippi 28089 24040 328
2432646 2432646 2022-04-22 Madison Mississippi 28089 24040 328
2429390 2429390 2022-04-21 Madison Mississippi 28089 24040 328
2426134 2426134 2022-04-20 Madison Mississippi 28089 24040 328
2422878 2422878 2022-04-19 Madison Mississippi 28089 24040 328
2419622 2419622 2022-04-18 Madison Mississippi 28089 24040 328
2416366 2416366 2022-04-17 Madison Mississippi 28089 24018 327
2413110 2413110 2022-04-16 Madison Mississippi 28089 24018 327
2409854 2409854 2022-04-15 Madison Mississippi 28089 24018 327
2406598 2406598 2022-04-14 Madison Mississippi 28089 24018 327
2403342 2403342 2022-04-13 Madison Mississippi 28089 24018 327
2400088 2400088 2022-04-12 Madison Mississippi 28089 24018 327
2396832 2396832 2022-04-11 Madison Mississippi 28089 23987 327
2393577 2393577 2022-04-10 Madison Mississippi 28089 23987 327
2390321 2390321 2022-04-09 Madison Mississippi 28089 23987 327
2387065 2387065 2022-04-08 Madison Mississippi 28089 23987 327
2383810 2383810 2022-04-07 Madison Mississippi 28089 23987 327
2380555 2380555 2022-04-06 Madison Mississippi 28089 23987 327
2377300 2377300 2022-04-05 Madison Mississippi 28089 23987 327
2374048 2374048 2022-04-04 Madison Mississippi 28089 23987 327
2370795 2370795 2022-04-03 Madison Mississippi 28089 23969 326
2367542 2367542 2022-04-02 Madison Mississippi 28089 23969 326
2364289 2364289 2022-04-01 Madison Mississippi 28089 23969 326
2361035 2361035 2022-03-31 Madison Mississippi 28089 23969 326
2357781 2357781 2022-03-30 Madison Mississippi 28089 23969 326
2354528 2354528 2022-03-29 Madison Mississippi 28089 23969 326
2351276 2351276 2022-03-28 Madison Mississippi 28089 23969 326
2348023 2348023 2022-03-27 Madison Mississippi 28089 23950 325
2344770 2344770 2022-03-26 Madison Mississippi 28089 23950 325
2341517 2341517 2022-03-25 Madison Mississippi 28089 23950 325
2338264 2338264 2022-03-24 Madison Mississippi 28089 23950 325
2335010 2335010 2022-03-23 Madison Mississippi 28089 23950 325
2331756 2331756 2022-03-22 Madison Mississippi 28089 23950 325
2328504 2328504 2022-03-21 Madison Mississippi 28089 23950 325
2325251 2325251 2022-03-20 Madison Mississippi 28089 23930 323
2321997 2321997 2022-03-19 Madison Mississippi 28089 23930 323
2318743 2318743 2022-03-18 Madison Mississippi 28089 23930 323
2315490 2315490 2022-03-17 Madison Mississippi 28089 23930 323
2312237 2312237 2022-03-16 Madison Mississippi 28089 23930 323
2308984 2308984 2022-03-15 Madison Mississippi 28089 23930 323
2305733 2305733 2022-03-14 Madison Mississippi 28089 23930 323
2302481 2302481 2022-03-13 Madison Mississippi 28089 23911 321
2299229 2299229 2022-03-12 Madison Mississippi 28089 23911 321
2295977 2295977 2022-03-11 Madison Mississippi 28089 23911 321
2292725 2292725 2022-03-10 Madison Mississippi 28089 23911 321
2289473 2289473 2022-03-09 Madison Mississippi 28089 23911 321
2286222 2286222 2022-03-08 Madison Mississippi 28089 23911 321
2282970 2282970 2022-03-07 Madison Mississippi 28089 23905 321
2279717 2279717 2022-03-06 Madison Mississippi 28089 23880 319
2276464 2276464 2022-03-05 Madison Mississippi 28089 23880 319
2273211 2273211 2022-03-04 Madison Mississippi 28089 23880 319
2269959 2269959 2022-03-03 Madison Mississippi 28089 23877 319
2266706 2266706 2022-03-02 Madison Mississippi 28089 23873 319
2263455 2263455 2022-03-01 Madison Mississippi 28089 23869 319
2260204 2260204 2022-02-28 Madison Mississippi 28089 23857 318
2256953 2256953 2022-02-27 Madison Mississippi 28089 23838 318
2253702 2253702 2022-02-26 Madison Mississippi 28089 23838 318
2250451 2250451 2022-02-25 Madison Mississippi 28089 23838 318
2247200 2247200 2022-02-24 Madison Mississippi 28089 23819 318
2243949 2243949 2022-02-23 Madison Mississippi 28089 23803 318
2240698 2240698 2022-02-22 Madison Mississippi 28089 23796 314
2237447 2237447 2022-02-21 Madison Mississippi 28089 23758 314
2234196 2234196 2022-02-20 Madison Mississippi 28089 23758 314
2230945 2230945 2022-02-19 Madison Mississippi 28089 23758 314
2227694 2227694 2022-02-18 Madison Mississippi 28089 23758 314
2224443 2224443 2022-02-17 Madison Mississippi 28089 23681 314
2221192 2221192 2022-02-16 Madison Mississippi 28089 23669 314
2217941 2217941 2022-02-15 Madison Mississippi 28089 23651 312
2214690 2214690 2022-02-14 Madison Mississippi 28089 23630 311
2211438 2211438 2022-02-13 Madison Mississippi 28089 23494 310
2208185 2208185 2022-02-12 Madison Mississippi 28089 23494 310
2204932 2204932 2022-02-11 Madison Mississippi 28089 23494 310
2201679 2201679 2022-02-10 Madison Mississippi 28089 23381 307
2198425 2198425 2022-02-09 Madison Mississippi 28089 23354 305
2195171 2195171 2022-02-08 Madison Mississippi 28089 23296 304
2191917 2191917 2022-02-07 Madison Mississippi 28089 23264 303
2188664 2188664 2022-02-06 Madison Mississippi 28089 22994 303
2185411 2185411 2022-02-05 Madison Mississippi 28089 22994 303
2182159 2182159 2022-02-04 Madison Mississippi 28089 22994 303
2178907 2178907 2022-02-03 Madison Mississippi 28089 22654 302

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);