ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Morgan" and fips = 18109 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 |
---|---|---|---|---|---|---|---|
2500334 | 2500334 | 2022-05-13 | Morgan | Indiana | 18109 | 16603 | 287 |
2497076 | 2497076 | 2022-05-12 | Morgan | Indiana | 18109 | 16575 | 287 |
2493818 | 2493818 | 2022-05-11 | Morgan | Indiana | 18109 | 16575 | 287 |
2490560 | 2490560 | 2022-05-10 | Morgan | Indiana | 18109 | 16553 | 287 |
2487303 | 2487303 | 2022-05-09 | Morgan | Indiana | 18109 | 16553 | 287 |
2484045 | 2484045 | 2022-05-08 | Morgan | Indiana | 18109 | 16529 | 287 |
2480787 | 2480787 | 2022-05-07 | Morgan | Indiana | 18109 | 16529 | 287 |
2477529 | 2477529 | 2022-05-06 | Morgan | Indiana | 18109 | 16529 | 287 |
2474271 | 2474271 | 2022-05-05 | Morgan | Indiana | 18109 | 16529 | 287 |
2471014 | 2471014 | 2022-05-04 | Morgan | Indiana | 18109 | 16529 | 287 |
2467758 | 2467758 | 2022-05-03 | Morgan | Indiana | 18109 | 16514 | 287 |
2464503 | 2464503 | 2022-05-02 | Morgan | Indiana | 18109 | 16514 | 287 |
2461247 | 2461247 | 2022-05-01 | Morgan | Indiana | 18109 | 16507 | 287 |
2457991 | 2457991 | 2022-04-30 | Morgan | Indiana | 18109 | 16507 | 287 |
2454735 | 2454735 | 2022-04-29 | Morgan | Indiana | 18109 | 16507 | 287 |
2451479 | 2451479 | 2022-04-28 | Morgan | Indiana | 18109 | 16501 | 286 |
2448223 | 2448223 | 2022-04-27 | Morgan | Indiana | 18109 | 16501 | 286 |
2444967 | 2444967 | 2022-04-26 | Morgan | Indiana | 18109 | 16486 | 286 |
2441711 | 2441711 | 2022-04-25 | Morgan | Indiana | 18109 | 16486 | 286 |
2438455 | 2438455 | 2022-04-24 | Morgan | Indiana | 18109 | 16473 | 286 |
2435199 | 2435199 | 2022-04-23 | Morgan | Indiana | 18109 | 16473 | 286 |
2431943 | 2431943 | 2022-04-22 | Morgan | Indiana | 18109 | 16473 | 286 |
2428687 | 2428687 | 2022-04-21 | Morgan | Indiana | 18109 | 16460 | 286 |
2425431 | 2425431 | 2022-04-20 | Morgan | Indiana | 18109 | 16460 | 286 |
2422175 | 2422175 | 2022-04-19 | Morgan | Indiana | 18109 | 16456 | 286 |
2418919 | 2418919 | 2022-04-18 | Morgan | Indiana | 18109 | 16456 | 286 |
2415663 | 2415663 | 2022-04-17 | Morgan | Indiana | 18109 | 16451 | 286 |
2412407 | 2412407 | 2022-04-16 | Morgan | Indiana | 18109 | 16451 | 286 |
2409151 | 2409151 | 2022-04-15 | Morgan | Indiana | 18109 | 16451 | 286 |
2405895 | 2405895 | 2022-04-14 | Morgan | Indiana | 18109 | 16451 | 286 |
2402640 | 2402640 | 2022-04-13 | Morgan | Indiana | 18109 | 16451 | 286 |
2399385 | 2399385 | 2022-04-12 | Morgan | Indiana | 18109 | 16449 | 286 |
2396130 | 2396130 | 2022-04-11 | Morgan | Indiana | 18109 | 16449 | 286 |
2392874 | 2392874 | 2022-04-10 | Morgan | Indiana | 18109 | 16448 | 286 |
2389618 | 2389618 | 2022-04-09 | Morgan | Indiana | 18109 | 16448 | 286 |
2386363 | 2386363 | 2022-04-08 | Morgan | Indiana | 18109 | 16448 | 286 |
2383108 | 2383108 | 2022-04-07 | Morgan | Indiana | 18109 | 16444 | 286 |
2379853 | 2379853 | 2022-04-06 | Morgan | Indiana | 18109 | 16444 | 286 |
2376599 | 2376599 | 2022-04-05 | Morgan | Indiana | 18109 | 16441 | 286 |
2373347 | 2373347 | 2022-04-04 | Morgan | Indiana | 18109 | 16441 | 286 |
2370094 | 2370094 | 2022-04-03 | Morgan | Indiana | 18109 | 16440 | 286 |
2366841 | 2366841 | 2022-04-02 | Morgan | Indiana | 18109 | 16440 | 286 |
2363588 | 2363588 | 2022-04-01 | Morgan | Indiana | 18109 | 16440 | 286 |
2360334 | 2360334 | 2022-03-31 | Morgan | Indiana | 18109 | 16438 | 286 |
2357080 | 2357080 | 2022-03-30 | Morgan | Indiana | 18109 | 16438 | 286 |
2353827 | 2353827 | 2022-03-29 | Morgan | Indiana | 18109 | 16468 | 286 |
2350575 | 2350575 | 2022-03-28 | Morgan | Indiana | 18109 | 16466 | 286 |
2347322 | 2347322 | 2022-03-27 | Morgan | Indiana | 18109 | 16463 | 286 |
2344069 | 2344069 | 2022-03-26 | Morgan | Indiana | 18109 | 16463 | 286 |
2340816 | 2340816 | 2022-03-25 | Morgan | Indiana | 18109 | 16463 | 286 |
2337563 | 2337563 | 2022-03-24 | Morgan | Indiana | 18109 | 16461 | 285 |
2334309 | 2334309 | 2022-03-23 | Morgan | Indiana | 18109 | 16459 | 284 |
2331055 | 2331055 | 2022-03-22 | Morgan | Indiana | 18109 | 16457 | 282 |
2327803 | 2327803 | 2022-03-21 | Morgan | Indiana | 18109 | 16450 | 281 |
2324550 | 2324550 | 2022-03-20 | Morgan | Indiana | 18109 | 16443 | 281 |
2321296 | 2321296 | 2022-03-19 | Morgan | Indiana | 18109 | 16443 | 281 |
2318042 | 2318042 | 2022-03-18 | Morgan | Indiana | 18109 | 16443 | 281 |
2314789 | 2314789 | 2022-03-17 | Morgan | Indiana | 18109 | 16444 | 279 |
2311536 | 2311536 | 2022-03-16 | Morgan | Indiana | 18109 | 16442 | 279 |
2308283 | 2308283 | 2022-03-15 | Morgan | Indiana | 18109 | 16441 | 279 |
2305032 | 2305032 | 2022-03-14 | Morgan | Indiana | 18109 | 16437 | 279 |
2301780 | 2301780 | 2022-03-13 | Morgan | Indiana | 18109 | 16431 | 279 |
2298528 | 2298528 | 2022-03-12 | Morgan | Indiana | 18109 | 16431 | 279 |
2295276 | 2295276 | 2022-03-11 | Morgan | Indiana | 18109 | 16431 | 279 |
2292024 | 2292024 | 2022-03-10 | Morgan | Indiana | 18109 | 16426 | 278 |
2288772 | 2288772 | 2022-03-09 | Morgan | Indiana | 18109 | 16425 | 278 |
2285521 | 2285521 | 2022-03-08 | Morgan | Indiana | 18109 | 16416 | 278 |
2282269 | 2282269 | 2022-03-07 | Morgan | Indiana | 18109 | 16413 | 278 |
2279016 | 2279016 | 2022-03-06 | Morgan | Indiana | 18109 | 16404 | 278 |
2275763 | 2275763 | 2022-03-05 | Morgan | Indiana | 18109 | 16404 | 278 |
2272510 | 2272510 | 2022-03-04 | Morgan | Indiana | 18109 | 16404 | 278 |
2269258 | 2269258 | 2022-03-03 | Morgan | Indiana | 18109 | 16401 | 276 |
2266005 | 2266005 | 2022-03-02 | Morgan | Indiana | 18109 | 16398 | 276 |
2262754 | 2262754 | 2022-03-01 | Morgan | Indiana | 18109 | 16394 | 275 |
2259503 | 2259503 | 2022-02-28 | Morgan | Indiana | 18109 | 16386 | 275 |
2256252 | 2256252 | 2022-02-27 | Morgan | Indiana | 18109 | 16369 | 273 |
2253001 | 2253001 | 2022-02-26 | Morgan | Indiana | 18109 | 16369 | 273 |
2249750 | 2249750 | 2022-02-25 | Morgan | Indiana | 18109 | 16369 | 273 |
2246499 | 2246499 | 2022-02-24 | Morgan | Indiana | 18109 | 16360 | 273 |
2243248 | 2243248 | 2022-02-23 | Morgan | Indiana | 18109 | 16341 | 272 |
2239997 | 2239997 | 2022-02-22 | Morgan | Indiana | 18109 | 16338 | 271 |
2236746 | 2236746 | 2022-02-21 | Morgan | Indiana | 18109 | 16328 | 271 |
2233495 | 2233495 | 2022-02-20 | Morgan | Indiana | 18109 | 16306 | 270 |
2230244 | 2230244 | 2022-02-19 | Morgan | Indiana | 18109 | 16306 | 270 |
2226993 | 2226993 | 2022-02-18 | Morgan | Indiana | 18109 | 16306 | 270 |
2223742 | 2223742 | 2022-02-17 | Morgan | Indiana | 18109 | 16291 | 269 |
2220491 | 2220491 | 2022-02-16 | Morgan | Indiana | 18109 | 16283 | 269 |
2217240 | 2217240 | 2022-02-15 | Morgan | Indiana | 18109 | 16277 | 268 |
2213989 | 2213989 | 2022-02-14 | Morgan | Indiana | 18109 | 16264 | 267 |
2210737 | 2210737 | 2022-02-13 | Morgan | Indiana | 18109 | 16209 | 267 |
2207484 | 2207484 | 2022-02-12 | Morgan | Indiana | 18109 | 16209 | 267 |
2204231 | 2204231 | 2022-02-11 | Morgan | Indiana | 18109 | 16209 | 267 |
2200978 | 2200978 | 2022-02-10 | Morgan | Indiana | 18109 | 16179 | 266 |
2197724 | 2197724 | 2022-02-09 | Morgan | Indiana | 18109 | 16116 | 265 |
2194470 | 2194470 | 2022-02-08 | Morgan | Indiana | 18109 | 16116 | 265 |
2191216 | 2191216 | 2022-02-07 | Morgan | Indiana | 18109 | 16092 | 265 |
2187963 | 2187963 | 2022-02-06 | Morgan | Indiana | 18109 | 16050 | 263 |
2184710 | 2184710 | 2022-02-05 | Morgan | Indiana | 18109 | 16050 | 263 |
2181458 | 2181458 | 2022-02-04 | Morgan | Indiana | 18109 | 16050 | 263 |
2178207 | 2178207 | 2022-02-03 | Morgan | Indiana | 18109 | 16003 | 262 |
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);