home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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 = "DeSoto" and state = "Mississippi" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Mississippi · 787 ✖

fips 1

  • 28033 787

county 1

  • DeSoto · 787 ✖
Link rowid date ▲ county state fips cases deaths
2501009 2501009 2022-05-13 DeSoto Mississippi 28033 50344 554
2497751 2497751 2022-05-12 DeSoto Mississippi 28033 50344 554
2494493 2494493 2022-05-11 DeSoto Mississippi 28033 50344 554
2491235 2491235 2022-05-10 DeSoto Mississippi 28033 50344 554
2487978 2487978 2022-05-09 DeSoto Mississippi 28033 50344 554
2484720 2484720 2022-05-08 DeSoto Mississippi 28033 50216 554
2481462 2481462 2022-05-07 DeSoto Mississippi 28033 50216 554
2478204 2478204 2022-05-06 DeSoto Mississippi 28033 50216 554
2474946 2474946 2022-05-05 DeSoto Mississippi 28033 50216 554
2471689 2471689 2022-05-04 DeSoto Mississippi 28033 50216 554
2468433 2468433 2022-05-03 DeSoto Mississippi 28033 50216 554
2465178 2465178 2022-05-02 DeSoto Mississippi 28033 50216 554
2461922 2461922 2022-05-01 DeSoto Mississippi 28033 50175 553
2458666 2458666 2022-04-30 DeSoto Mississippi 28033 50175 553
2455410 2455410 2022-04-29 DeSoto Mississippi 28033 50175 553
2452154 2452154 2022-04-28 DeSoto Mississippi 28033 50175 553
2448898 2448898 2022-04-27 DeSoto Mississippi 28033 50175 553
2445642 2445642 2022-04-26 DeSoto Mississippi 28033 50175 553
2442386 2442386 2022-04-25 DeSoto Mississippi 28033 50130 553
2439130 2439130 2022-04-24 DeSoto Mississippi 28033 50130 553
2435874 2435874 2022-04-23 DeSoto Mississippi 28033 50130 553
2432618 2432618 2022-04-22 DeSoto Mississippi 28033 50130 553
2429362 2429362 2022-04-21 DeSoto Mississippi 28033 50130 553
2426106 2426106 2022-04-20 DeSoto Mississippi 28033 50130 553
2422850 2422850 2022-04-19 DeSoto Mississippi 28033 50130 553
2419594 2419594 2022-04-18 DeSoto Mississippi 28033 50130 553
2416338 2416338 2022-04-17 DeSoto Mississippi 28033 50104 553
2413082 2413082 2022-04-16 DeSoto Mississippi 28033 50104 553
2409826 2409826 2022-04-15 DeSoto Mississippi 28033 50104 553
2406570 2406570 2022-04-14 DeSoto Mississippi 28033 50104 553
2403314 2403314 2022-04-13 DeSoto Mississippi 28033 50104 553
2400060 2400060 2022-04-12 DeSoto Mississippi 28033 50104 553
2396804 2396804 2022-04-11 DeSoto Mississippi 28033 50061 553
2393549 2393549 2022-04-10 DeSoto Mississippi 28033 50061 553
2390293 2390293 2022-04-09 DeSoto Mississippi 28033 50061 553
2387037 2387037 2022-04-08 DeSoto Mississippi 28033 50061 553
2383782 2383782 2022-04-07 DeSoto Mississippi 28033 50061 553
2380527 2380527 2022-04-06 DeSoto Mississippi 28033 50061 553
2377272 2377272 2022-04-05 DeSoto Mississippi 28033 50061 553
2374020 2374020 2022-04-04 DeSoto Mississippi 28033 50061 553
2370767 2370767 2022-04-03 DeSoto Mississippi 28033 50008 553
2367514 2367514 2022-04-02 DeSoto Mississippi 28033 50008 553
2364261 2364261 2022-04-01 DeSoto Mississippi 28033 50008 553
2361007 2361007 2022-03-31 DeSoto Mississippi 28033 50008 553
2357753 2357753 2022-03-30 DeSoto Mississippi 28033 50008 553
2354500 2354500 2022-03-29 DeSoto Mississippi 28033 50008 553
2351248 2351248 2022-03-28 DeSoto Mississippi 28033 50008 553
2347995 2347995 2022-03-27 DeSoto Mississippi 28033 49981 548
2344742 2344742 2022-03-26 DeSoto Mississippi 28033 49981 548
2341489 2341489 2022-03-25 DeSoto Mississippi 28033 49981 548
2338236 2338236 2022-03-24 DeSoto Mississippi 28033 49981 548
2334982 2334982 2022-03-23 DeSoto Mississippi 28033 49981 548
2331728 2331728 2022-03-22 DeSoto Mississippi 28033 49981 548
2328476 2328476 2022-03-21 DeSoto Mississippi 28033 49981 548
2325223 2325223 2022-03-20 DeSoto Mississippi 28033 49944 544
2321969 2321969 2022-03-19 DeSoto Mississippi 28033 49944 544
2318715 2318715 2022-03-18 DeSoto Mississippi 28033 49944 544
2315462 2315462 2022-03-17 DeSoto Mississippi 28033 49944 544
2312209 2312209 2022-03-16 DeSoto Mississippi 28033 49944 544
2308956 2308956 2022-03-15 DeSoto Mississippi 28033 49944 544
2305705 2305705 2022-03-14 DeSoto Mississippi 28033 49944 544
2302453 2302453 2022-03-13 DeSoto Mississippi 28033 49914 540
2299201 2299201 2022-03-12 DeSoto Mississippi 28033 49914 540
2295949 2295949 2022-03-11 DeSoto Mississippi 28033 49914 540
2292697 2292697 2022-03-10 DeSoto Mississippi 28033 49914 540
2289445 2289445 2022-03-09 DeSoto Mississippi 28033 49914 540
2286194 2286194 2022-03-08 DeSoto Mississippi 28033 49914 540
2282942 2282942 2022-03-07 DeSoto Mississippi 28033 49909 539
2279689 2279689 2022-03-06 DeSoto Mississippi 28033 49887 539
2276436 2276436 2022-03-05 DeSoto Mississippi 28033 49887 539
2273183 2273183 2022-03-04 DeSoto Mississippi 28033 49887 539
2269931 2269931 2022-03-03 DeSoto Mississippi 28033 49872 539
2266678 2266678 2022-03-02 DeSoto Mississippi 28033 49851 539
2263427 2263427 2022-03-01 DeSoto Mississippi 28033 49837 539
2260176 2260176 2022-02-28 DeSoto Mississippi 28033 49826 537
2256925 2256925 2022-02-27 DeSoto Mississippi 28033 49772 536
2253674 2253674 2022-02-26 DeSoto Mississippi 28033 49772 536
2250423 2250423 2022-02-25 DeSoto Mississippi 28033 49772 536
2247172 2247172 2022-02-24 DeSoto Mississippi 28033 49724 534
2243921 2243921 2022-02-23 DeSoto Mississippi 28033 49706 534
2240670 2240670 2022-02-22 DeSoto Mississippi 28033 49668 530
2237419 2237419 2022-02-21 DeSoto Mississippi 28033 49549 528
2234168 2234168 2022-02-20 DeSoto Mississippi 28033 49549 528
2230917 2230917 2022-02-19 DeSoto Mississippi 28033 49549 528
2227666 2227666 2022-02-18 DeSoto Mississippi 28033 49549 528
2224415 2224415 2022-02-17 DeSoto Mississippi 28033 49509 525
2221164 2221164 2022-02-16 DeSoto Mississippi 28033 49484 524
2217913 2217913 2022-02-15 DeSoto Mississippi 28033 49387 522
2214662 2214662 2022-02-14 DeSoto Mississippi 28033 49208 518
2211410 2211410 2022-02-13 DeSoto Mississippi 28033 48924 514
2208157 2208157 2022-02-12 DeSoto Mississippi 28033 48924 514
2204904 2204904 2022-02-11 DeSoto Mississippi 28033 48924 514
2201651 2201651 2022-02-10 DeSoto Mississippi 28033 48821 506
2198397 2198397 2022-02-09 DeSoto Mississippi 28033 48746 503
2195143 2195143 2022-02-08 DeSoto Mississippi 28033 48557 498
2191889 2191889 2022-02-07 DeSoto Mississippi 28033 48441 495
2188636 2188636 2022-02-06 DeSoto Mississippi 28033 47659 494
2185383 2185383 2022-02-05 DeSoto Mississippi 28033 47659 494
2182131 2182131 2022-02-04 DeSoto Mississippi 28033 47659 494
2178879 2178879 2022-02-03 DeSoto Mississippi 28033 47274 494

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);
Powered by Datasette · Queries took 107.124ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette