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

789 rows where county = "Monroe" and fips = 28095 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Mississippi 789

fips 1

  • 28095 · 789 ✖

county 1

  • Monroe · 789 ✖
Link rowid date ▲ county state fips cases deaths
2501040 2501040 2022-05-13 Monroe Mississippi 28095 10997 220
2497782 2497782 2022-05-12 Monroe Mississippi 28095 10997 220
2494524 2494524 2022-05-11 Monroe Mississippi 28095 10997 220
2491266 2491266 2022-05-10 Monroe Mississippi 28095 10997 220
2488009 2488009 2022-05-09 Monroe Mississippi 28095 10997 220
2484751 2484751 2022-05-08 Monroe Mississippi 28095 10985 220
2481493 2481493 2022-05-07 Monroe Mississippi 28095 10985 220
2478235 2478235 2022-05-06 Monroe Mississippi 28095 10985 220
2474977 2474977 2022-05-05 Monroe Mississippi 28095 10985 220
2471720 2471720 2022-05-04 Monroe Mississippi 28095 10985 220
2468464 2468464 2022-05-03 Monroe Mississippi 28095 10985 220
2465209 2465209 2022-05-02 Monroe Mississippi 28095 10985 220
2461953 2461953 2022-05-01 Monroe Mississippi 28095 10984 220
2458697 2458697 2022-04-30 Monroe Mississippi 28095 10984 220
2455441 2455441 2022-04-29 Monroe Mississippi 28095 10984 220
2452185 2452185 2022-04-28 Monroe Mississippi 28095 10984 220
2448929 2448929 2022-04-27 Monroe Mississippi 28095 10984 220
2445673 2445673 2022-04-26 Monroe Mississippi 28095 10984 220
2442417 2442417 2022-04-25 Monroe Mississippi 28095 10981 220
2439161 2439161 2022-04-24 Monroe Mississippi 28095 10981 220
2435905 2435905 2022-04-23 Monroe Mississippi 28095 10981 220
2432649 2432649 2022-04-22 Monroe Mississippi 28095 10981 220
2429393 2429393 2022-04-21 Monroe Mississippi 28095 10981 220
2426137 2426137 2022-04-20 Monroe Mississippi 28095 10981 220
2422881 2422881 2022-04-19 Monroe Mississippi 28095 10981 220
2419625 2419625 2022-04-18 Monroe Mississippi 28095 10981 220
2416369 2416369 2022-04-17 Monroe Mississippi 28095 10979 220
2413113 2413113 2022-04-16 Monroe Mississippi 28095 10979 220
2409857 2409857 2022-04-15 Monroe Mississippi 28095 10979 220
2406601 2406601 2022-04-14 Monroe Mississippi 28095 10979 220
2403345 2403345 2022-04-13 Monroe Mississippi 28095 10979 220
2400091 2400091 2022-04-12 Monroe Mississippi 28095 10979 220
2396835 2396835 2022-04-11 Monroe Mississippi 28095 10977 220
2393580 2393580 2022-04-10 Monroe Mississippi 28095 10977 220
2390324 2390324 2022-04-09 Monroe Mississippi 28095 10977 220
2387068 2387068 2022-04-08 Monroe Mississippi 28095 10977 220
2383813 2383813 2022-04-07 Monroe Mississippi 28095 10977 220
2380558 2380558 2022-04-06 Monroe Mississippi 28095 10977 220
2377303 2377303 2022-04-05 Monroe Mississippi 28095 10977 220
2374051 2374051 2022-04-04 Monroe Mississippi 28095 10977 220
2370798 2370798 2022-04-03 Monroe Mississippi 28095 10968 219
2367545 2367545 2022-04-02 Monroe Mississippi 28095 10968 219
2364292 2364292 2022-04-01 Monroe Mississippi 28095 10968 219
2361038 2361038 2022-03-31 Monroe Mississippi 28095 10968 219
2357784 2357784 2022-03-30 Monroe Mississippi 28095 10968 219
2354531 2354531 2022-03-29 Monroe Mississippi 28095 10968 219
2351279 2351279 2022-03-28 Monroe Mississippi 28095 10968 219
2348026 2348026 2022-03-27 Monroe Mississippi 28095 10964 218
2344773 2344773 2022-03-26 Monroe Mississippi 28095 10964 218
2341520 2341520 2022-03-25 Monroe Mississippi 28095 10964 218
2338267 2338267 2022-03-24 Monroe Mississippi 28095 10964 218
2335013 2335013 2022-03-23 Monroe Mississippi 28095 10964 218
2331759 2331759 2022-03-22 Monroe Mississippi 28095 10964 218
2328507 2328507 2022-03-21 Monroe Mississippi 28095 10964 218
2325254 2325254 2022-03-20 Monroe Mississippi 28095 10957 217
2322000 2322000 2022-03-19 Monroe Mississippi 28095 10957 217
2318746 2318746 2022-03-18 Monroe Mississippi 28095 10957 217
2315493 2315493 2022-03-17 Monroe Mississippi 28095 10957 217
2312240 2312240 2022-03-16 Monroe Mississippi 28095 10957 217
2308987 2308987 2022-03-15 Monroe Mississippi 28095 10957 217
2305736 2305736 2022-03-14 Monroe Mississippi 28095 10957 217
2302484 2302484 2022-03-13 Monroe Mississippi 28095 10952 216
2299232 2299232 2022-03-12 Monroe Mississippi 28095 10952 216
2295980 2295980 2022-03-11 Monroe Mississippi 28095 10952 216
2292728 2292728 2022-03-10 Monroe Mississippi 28095 10952 216
2289476 2289476 2022-03-09 Monroe Mississippi 28095 10952 216
2286225 2286225 2022-03-08 Monroe Mississippi 28095 10952 216
2282973 2282973 2022-03-07 Monroe Mississippi 28095 10952 215
2279720 2279720 2022-03-06 Monroe Mississippi 28095 10949 215
2276467 2276467 2022-03-05 Monroe Mississippi 28095 10949 215
2273214 2273214 2022-03-04 Monroe Mississippi 28095 10949 215
2269962 2269962 2022-03-03 Monroe Mississippi 28095 10937 214
2266709 2266709 2022-03-02 Monroe Mississippi 28095 10930 214
2263458 2263458 2022-03-01 Monroe Mississippi 28095 10927 214
2260207 2260207 2022-02-28 Monroe Mississippi 28095 10925 211
2256956 2256956 2022-02-27 Monroe Mississippi 28095 10920 210
2253705 2253705 2022-02-26 Monroe Mississippi 28095 10920 210
2250454 2250454 2022-02-25 Monroe Mississippi 28095 10920 210
2247203 2247203 2022-02-24 Monroe Mississippi 28095 10910 210
2243952 2243952 2022-02-23 Monroe Mississippi 28095 10895 208
2240701 2240701 2022-02-22 Monroe Mississippi 28095 10885 207
2237450 2237450 2022-02-21 Monroe Mississippi 28095 10863 207
2234199 2234199 2022-02-20 Monroe Mississippi 28095 10863 207
2230948 2230948 2022-02-19 Monroe Mississippi 28095 10863 207
2227697 2227697 2022-02-18 Monroe Mississippi 28095 10863 207
2224446 2224446 2022-02-17 Monroe Mississippi 28095 10839 205
2221195 2221195 2022-02-16 Monroe Mississippi 28095 10838 204
2217944 2217944 2022-02-15 Monroe Mississippi 28095 10823 204
2214693 2214693 2022-02-14 Monroe Mississippi 28095 10805 204
2211441 2211441 2022-02-13 Monroe Mississippi 28095 10749 204
2208188 2208188 2022-02-12 Monroe Mississippi 28095 10749 204
2204935 2204935 2022-02-11 Monroe Mississippi 28095 10749 204
2201682 2201682 2022-02-10 Monroe Mississippi 28095 10709 202
2198428 2198428 2022-02-09 Monroe Mississippi 28095 10679 201
2195174 2195174 2022-02-08 Monroe Mississippi 28095 10661 199
2191920 2191920 2022-02-07 Monroe Mississippi 28095 10606 197
2188667 2188667 2022-02-06 Monroe Mississippi 28095 10235 197
2185414 2185414 2022-02-05 Monroe Mississippi 28095 10235 197
2182162 2182162 2022-02-04 Monroe Mississippi 28095 10235 197
2178910 2178910 2022-02-03 Monroe Mississippi 28095 10116 195

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 104.434ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette