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

776 rows where county = "Warren" and fips = 28149 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Mississippi 776

fips 1

  • 28149 · 776 ✖

county 1

  • Warren · 776 ✖
Link rowid date ▲ county state fips cases deaths
2501068 2501068 2022-05-13 Warren Mississippi 28149 10250 202
2497810 2497810 2022-05-12 Warren Mississippi 28149 10250 202
2494552 2494552 2022-05-11 Warren Mississippi 28149 10250 202
2491294 2491294 2022-05-10 Warren Mississippi 28149 10250 202
2488036 2488036 2022-05-09 Warren Mississippi 28149 10250 202
2484779 2484779 2022-05-08 Warren Mississippi 28149 10232 202
2481521 2481521 2022-05-07 Warren Mississippi 28149 10232 202
2478263 2478263 2022-05-06 Warren Mississippi 28149 10232 202
2475005 2475005 2022-05-05 Warren Mississippi 28149 10232 202
2471748 2471748 2022-05-04 Warren Mississippi 28149 10232 202
2468492 2468492 2022-05-03 Warren Mississippi 28149 10232 202
2465236 2465236 2022-05-02 Warren Mississippi 28149 10232 202
2461981 2461981 2022-05-01 Warren Mississippi 28149 10223 202
2458725 2458725 2022-04-30 Warren Mississippi 28149 10223 202
2455469 2455469 2022-04-29 Warren Mississippi 28149 10223 202
2452213 2452213 2022-04-28 Warren Mississippi 28149 10223 202
2448957 2448957 2022-04-27 Warren Mississippi 28149 10223 202
2445700 2445700 2022-04-26 Warren Mississippi 28149 10223 202
2442445 2442445 2022-04-25 Warren Mississippi 28149 10213 202
2439189 2439189 2022-04-24 Warren Mississippi 28149 10213 202
2435933 2435933 2022-04-23 Warren Mississippi 28149 10213 202
2432677 2432677 2022-04-22 Warren Mississippi 28149 10213 202
2429421 2429421 2022-04-21 Warren Mississippi 28149 10213 202
2426165 2426165 2022-04-20 Warren Mississippi 28149 10213 202
2422909 2422909 2022-04-19 Warren Mississippi 28149 10213 202
2419652 2419652 2022-04-18 Warren Mississippi 28149 10213 202
2416397 2416397 2022-04-17 Warren Mississippi 28149 10209 202
2413141 2413141 2022-04-16 Warren Mississippi 28149 10209 202
2409885 2409885 2022-04-15 Warren Mississippi 28149 10209 202
2406629 2406629 2022-04-14 Warren Mississippi 28149 10209 202
2403373 2403373 2022-04-13 Warren Mississippi 28149 10209 202
2400118 2400118 2022-04-12 Warren Mississippi 28149 10209 202
2396863 2396863 2022-04-11 Warren Mississippi 28149 10203 202
2393608 2393608 2022-04-10 Warren Mississippi 28149 10203 202
2390352 2390352 2022-04-09 Warren Mississippi 28149 10203 202
2387096 2387096 2022-04-08 Warren Mississippi 28149 10203 202
2383841 2383841 2022-04-07 Warren Mississippi 28149 10203 202
2380586 2380586 2022-04-06 Warren Mississippi 28149 10203 202
2377331 2377331 2022-04-05 Warren Mississippi 28149 10203 202
2374078 2374078 2022-04-04 Warren Mississippi 28149 10203 202
2370826 2370826 2022-04-03 Warren Mississippi 28149 10197 202
2367573 2367573 2022-04-02 Warren Mississippi 28149 10197 202
2364320 2364320 2022-04-01 Warren Mississippi 28149 10197 202
2361066 2361066 2022-03-31 Warren Mississippi 28149 10197 202
2357812 2357812 2022-03-30 Warren Mississippi 28149 10197 202
2354559 2354559 2022-03-29 Warren Mississippi 28149 10197 202
2351306 2351306 2022-03-28 Warren Mississippi 28149 10197 202
2348054 2348054 2022-03-27 Warren Mississippi 28149 10195 202
2344801 2344801 2022-03-26 Warren Mississippi 28149 10195 202
2341548 2341548 2022-03-25 Warren Mississippi 28149 10195 202
2338295 2338295 2022-03-24 Warren Mississippi 28149 10195 202
2335041 2335041 2022-03-23 Warren Mississippi 28149 10195 202
2331787 2331787 2022-03-22 Warren Mississippi 28149 10195 202
2328534 2328534 2022-03-21 Warren Mississippi 28149 10195 202
2325282 2325282 2022-03-20 Warren Mississippi 28149 10193 201
2322028 2322028 2022-03-19 Warren Mississippi 28149 10193 201
2318774 2318774 2022-03-18 Warren Mississippi 28149 10193 201
2315521 2315521 2022-03-17 Warren Mississippi 28149 10193 201
2312268 2312268 2022-03-16 Warren Mississippi 28149 10193 201
2309015 2309015 2022-03-15 Warren Mississippi 28149 10193 201
2305763 2305763 2022-03-14 Warren Mississippi 28149 10193 201
2302512 2302512 2022-03-13 Warren Mississippi 28149 10184 201
2299260 2299260 2022-03-12 Warren Mississippi 28149 10184 201
2296008 2296008 2022-03-11 Warren Mississippi 28149 10184 201
2292756 2292756 2022-03-10 Warren Mississippi 28149 10184 201
2289504 2289504 2022-03-09 Warren Mississippi 28149 10184 201
2286252 2286252 2022-03-08 Warren Mississippi 28149 10184 201
2283000 2283000 2022-03-07 Warren Mississippi 28149 10184 200
2279747 2279747 2022-03-06 Warren Mississippi 28149 10180 199
2276494 2276494 2022-03-05 Warren Mississippi 28149 10180 199
2273241 2273241 2022-03-04 Warren Mississippi 28149 10180 199
2269989 2269989 2022-03-03 Warren Mississippi 28149 10179 199
2266736 2266736 2022-03-02 Warren Mississippi 28149 10179 199
2263485 2263485 2022-03-01 Warren Mississippi 28149 10175 199
2260234 2260234 2022-02-28 Warren Mississippi 28149 10173 199
2256983 2256983 2022-02-27 Warren Mississippi 28149 10168 199
2253732 2253732 2022-02-26 Warren Mississippi 28149 10168 199
2250481 2250481 2022-02-25 Warren Mississippi 28149 10168 199
2247230 2247230 2022-02-24 Warren Mississippi 28149 10165 199
2243979 2243979 2022-02-23 Warren Mississippi 28149 10161 199
2240728 2240728 2022-02-22 Warren Mississippi 28149 10157 197
2237477 2237477 2022-02-21 Warren Mississippi 28149 10144 196
2234226 2234226 2022-02-20 Warren Mississippi 28149 10144 196
2230975 2230975 2022-02-19 Warren Mississippi 28149 10144 196
2227724 2227724 2022-02-18 Warren Mississippi 28149 10144 196
2224473 2224473 2022-02-17 Warren Mississippi 28149 10128 195
2221222 2221222 2022-02-16 Warren Mississippi 28149 10128 195
2217971 2217971 2022-02-15 Warren Mississippi 28149 10122 191
2214720 2214720 2022-02-14 Warren Mississippi 28149 10100 191
2211468 2211468 2022-02-13 Warren Mississippi 28149 9962 191
2208215 2208215 2022-02-12 Warren Mississippi 28149 9962 191
2204962 2204962 2022-02-11 Warren Mississippi 28149 9962 191
2201709 2201709 2022-02-10 Warren Mississippi 28149 9918 191
2198455 2198455 2022-02-09 Warren Mississippi 28149 9913 191
2195201 2195201 2022-02-08 Warren Mississippi 28149 9911 191
2191947 2191947 2022-02-07 Warren Mississippi 28149 9890 191
2188694 2188694 2022-02-06 Warren Mississippi 28149 9758 190
2185441 2185441 2022-02-05 Warren Mississippi 28149 9758 190
2182189 2182189 2022-02-04 Warren Mississippi 28149 9758 190
2178937 2178937 2022-02-03 Warren Mississippi 28149 9595 190

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