ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Marshall" and fips = 18099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
Advanced export
JSON shape: default, array, newline-delimited
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);