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

779 rows where county = "Marshall" and state = "Indiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Indiana · 779 ✖

fips 1

  • 18099 779

county 1

  • Marshall · 779 ✖
Link rowid date ▲ county state fips cases deaths
2500329 2500329 2022-05-13 Marshall Indiana 18099 12437 197
2497071 2497071 2022-05-12 Marshall Indiana 18099 12427 197
2493813 2493813 2022-05-11 Marshall Indiana 18099 12427 197
2490555 2490555 2022-05-10 Marshall Indiana 18099 12415 197
2487298 2487298 2022-05-09 Marshall Indiana 18099 12415 197
2484040 2484040 2022-05-08 Marshall Indiana 18099 12400 197
2480782 2480782 2022-05-07 Marshall Indiana 18099 12400 197
2477524 2477524 2022-05-06 Marshall Indiana 18099 12400 197
2474266 2474266 2022-05-05 Marshall Indiana 18099 12400 197
2471009 2471009 2022-05-04 Marshall Indiana 18099 12400 197
2467753 2467753 2022-05-03 Marshall Indiana 18099 12395 197
2464498 2464498 2022-05-02 Marshall Indiana 18099 12395 197
2461242 2461242 2022-05-01 Marshall Indiana 18099 12394 197
2457986 2457986 2022-04-30 Marshall Indiana 18099 12394 197
2454730 2454730 2022-04-29 Marshall Indiana 18099 12394 197
2451474 2451474 2022-04-28 Marshall Indiana 18099 12386 197
2448218 2448218 2022-04-27 Marshall Indiana 18099 12386 197
2444962 2444962 2022-04-26 Marshall Indiana 18099 12381 197
2441706 2441706 2022-04-25 Marshall Indiana 18099 12381 197
2438450 2438450 2022-04-24 Marshall Indiana 18099 12370 197
2435194 2435194 2022-04-23 Marshall Indiana 18099 12370 197
2431938 2431938 2022-04-22 Marshall Indiana 18099 12370 197
2428682 2428682 2022-04-21 Marshall Indiana 18099 12355 197
2425426 2425426 2022-04-20 Marshall Indiana 18099 12355 197
2422170 2422170 2022-04-19 Marshall Indiana 18099 12342 196
2418914 2418914 2022-04-18 Marshall Indiana 18099 12342 196
2415658 2415658 2022-04-17 Marshall Indiana 18099 12322 196
2412402 2412402 2022-04-16 Marshall Indiana 18099 12322 196
2409146 2409146 2022-04-15 Marshall Indiana 18099 12322 196
2405890 2405890 2022-04-14 Marshall Indiana 18099 12322 196
2402635 2402635 2022-04-13 Marshall Indiana 18099 12322 196
2399380 2399380 2022-04-12 Marshall Indiana 18099 12319 195
2396125 2396125 2022-04-11 Marshall Indiana 18099 12319 195
2392869 2392869 2022-04-10 Marshall Indiana 18099 12319 195
2389613 2389613 2022-04-09 Marshall Indiana 18099 12319 195
2386358 2386358 2022-04-08 Marshall Indiana 18099 12319 195
2383103 2383103 2022-04-07 Marshall Indiana 18099 12319 195
2379848 2379848 2022-04-06 Marshall Indiana 18099 12319 195
2376594 2376594 2022-04-05 Marshall Indiana 18099 12317 195
2373342 2373342 2022-04-04 Marshall Indiana 18099 12317 195
2370089 2370089 2022-04-03 Marshall Indiana 18099 12316 195
2366836 2366836 2022-04-02 Marshall Indiana 18099 12316 195
2363583 2363583 2022-04-01 Marshall Indiana 18099 12316 195
2360329 2360329 2022-03-31 Marshall Indiana 18099 12315 195
2357075 2357075 2022-03-30 Marshall Indiana 18099 12315 195
2353822 2353822 2022-03-29 Marshall Indiana 18099 12328 195
2350570 2350570 2022-03-28 Marshall Indiana 18099 12327 195
2347317 2347317 2022-03-27 Marshall Indiana 18099 12325 195
2344064 2344064 2022-03-26 Marshall Indiana 18099 12325 195
2340811 2340811 2022-03-25 Marshall Indiana 18099 12325 195
2337558 2337558 2022-03-24 Marshall Indiana 18099 12322 195
2334304 2334304 2022-03-23 Marshall Indiana 18099 12317 195
2331050 2331050 2022-03-22 Marshall Indiana 18099 12317 195
2327798 2327798 2022-03-21 Marshall Indiana 18099 12316 195
2324545 2324545 2022-03-20 Marshall Indiana 18099 12315 195
2321291 2321291 2022-03-19 Marshall Indiana 18099 12315 195
2318037 2318037 2022-03-18 Marshall Indiana 18099 12315 195
2314784 2314784 2022-03-17 Marshall Indiana 18099 12312 193
2311531 2311531 2022-03-16 Marshall Indiana 18099 12309 193
2308278 2308278 2022-03-15 Marshall Indiana 18099 12304 193
2305027 2305027 2022-03-14 Marshall Indiana 18099 12303 193
2301775 2301775 2022-03-13 Marshall Indiana 18099 12300 193
2298523 2298523 2022-03-12 Marshall Indiana 18099 12300 193
2295271 2295271 2022-03-11 Marshall Indiana 18099 12300 193
2292019 2292019 2022-03-10 Marshall Indiana 18099 12299 193
2288767 2288767 2022-03-09 Marshall Indiana 18099 12297 193
2285516 2285516 2022-03-08 Marshall Indiana 18099 12294 193
2282264 2282264 2022-03-07 Marshall Indiana 18099 12294 193
2279011 2279011 2022-03-06 Marshall Indiana 18099 12290 193
2275758 2275758 2022-03-05 Marshall Indiana 18099 12290 193
2272505 2272505 2022-03-04 Marshall Indiana 18099 12290 193
2269253 2269253 2022-03-03 Marshall Indiana 18099 12289 193
2266000 2266000 2022-03-02 Marshall Indiana 18099 12287 193
2262749 2262749 2022-03-01 Marshall Indiana 18099 12284 192
2259498 2259498 2022-02-28 Marshall Indiana 18099 12283 192
2256247 2256247 2022-02-27 Marshall Indiana 18099 12279 192
2252996 2252996 2022-02-26 Marshall Indiana 18099 12279 192
2249745 2249745 2022-02-25 Marshall Indiana 18099 12279 192
2246494 2246494 2022-02-24 Marshall Indiana 18099 12275 190
2243243 2243243 2022-02-23 Marshall Indiana 18099 12269 190
2239992 2239992 2022-02-22 Marshall Indiana 18099 12268 190
2236741 2236741 2022-02-21 Marshall Indiana 18099 12264 190
2233490 2233490 2022-02-20 Marshall Indiana 18099 12255 190
2230239 2230239 2022-02-19 Marshall Indiana 18099 12255 190
2226988 2226988 2022-02-18 Marshall Indiana 18099 12255 190
2223737 2223737 2022-02-17 Marshall Indiana 18099 12246 190
2220486 2220486 2022-02-16 Marshall Indiana 18099 12239 190
2217235 2217235 2022-02-15 Marshall Indiana 18099 12229 189
2213984 2213984 2022-02-14 Marshall Indiana 18099 12217 189
2210732 2210732 2022-02-13 Marshall Indiana 18099 12203 189
2207479 2207479 2022-02-12 Marshall Indiana 18099 12203 189
2204226 2204226 2022-02-11 Marshall Indiana 18099 12203 189
2200973 2200973 2022-02-10 Marshall Indiana 18099 12190 188
2197719 2197719 2022-02-09 Marshall Indiana 18099 12148 188
2194465 2194465 2022-02-08 Marshall Indiana 18099 12148 188
2191211 2191211 2022-02-07 Marshall Indiana 18099 12126 188
2187958 2187958 2022-02-06 Marshall Indiana 18099 12101 187
2184705 2184705 2022-02-05 Marshall Indiana 18099 12101 187
2181453 2181453 2022-02-04 Marshall Indiana 18099 12101 187
2178202 2178202 2022-02-03 Marshall Indiana 18099 12079 187

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