ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Fountain" 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 |
---|---|---|---|---|---|---|---|
2500302 | 2500302 | 2022-05-13 | Fountain | Indiana | 18045 | 5491 | 103 |
2497044 | 2497044 | 2022-05-12 | Fountain | Indiana | 18045 | 5481 | 103 |
2493786 | 2493786 | 2022-05-11 | Fountain | Indiana | 18045 | 5481 | 103 |
2490528 | 2490528 | 2022-05-10 | Fountain | Indiana | 18045 | 5466 | 103 |
2487271 | 2487271 | 2022-05-09 | Fountain | Indiana | 18045 | 5466 | 103 |
2484013 | 2484013 | 2022-05-08 | Fountain | Indiana | 18045 | 5462 | 103 |
2480755 | 2480755 | 2022-05-07 | Fountain | Indiana | 18045 | 5462 | 103 |
2477497 | 2477497 | 2022-05-06 | Fountain | Indiana | 18045 | 5462 | 103 |
2474239 | 2474239 | 2022-05-05 | Fountain | Indiana | 18045 | 5462 | 103 |
2470982 | 2470982 | 2022-05-04 | Fountain | Indiana | 18045 | 5462 | 103 |
2467726 | 2467726 | 2022-05-03 | Fountain | Indiana | 18045 | 5458 | 103 |
2464471 | 2464471 | 2022-05-02 | Fountain | Indiana | 18045 | 5458 | 103 |
2461215 | 2461215 | 2022-05-01 | Fountain | Indiana | 18045 | 5456 | 103 |
2457959 | 2457959 | 2022-04-30 | Fountain | Indiana | 18045 | 5456 | 103 |
2454703 | 2454703 | 2022-04-29 | Fountain | Indiana | 18045 | 5456 | 103 |
2451447 | 2451447 | 2022-04-28 | Fountain | Indiana | 18045 | 5448 | 102 |
2448191 | 2448191 | 2022-04-27 | Fountain | Indiana | 18045 | 5448 | 102 |
2444935 | 2444935 | 2022-04-26 | Fountain | Indiana | 18045 | 5432 | 102 |
2441679 | 2441679 | 2022-04-25 | Fountain | Indiana | 18045 | 5432 | 102 |
2438423 | 2438423 | 2022-04-24 | Fountain | Indiana | 18045 | 5431 | 102 |
2435167 | 2435167 | 2022-04-23 | Fountain | Indiana | 18045 | 5431 | 102 |
2431911 | 2431911 | 2022-04-22 | Fountain | Indiana | 18045 | 5431 | 102 |
2428655 | 2428655 | 2022-04-21 | Fountain | Indiana | 18045 | 5430 | 102 |
2425399 | 2425399 | 2022-04-20 | Fountain | Indiana | 18045 | 5430 | 102 |
2422143 | 2422143 | 2022-04-19 | Fountain | Indiana | 18045 | 5424 | 102 |
2418887 | 2418887 | 2022-04-18 | Fountain | Indiana | 18045 | 5424 | 102 |
2415631 | 2415631 | 2022-04-17 | Fountain | Indiana | 18045 | 5423 | 102 |
2412375 | 2412375 | 2022-04-16 | Fountain | Indiana | 18045 | 5423 | 102 |
2409119 | 2409119 | 2022-04-15 | Fountain | Indiana | 18045 | 5423 | 102 |
2405863 | 2405863 | 2022-04-14 | Fountain | Indiana | 18045 | 5423 | 102 |
2402608 | 2402608 | 2022-04-13 | Fountain | Indiana | 18045 | 5423 | 102 |
2399353 | 2399353 | 2022-04-12 | Fountain | Indiana | 18045 | 5421 | 102 |
2396098 | 2396098 | 2022-04-11 | Fountain | Indiana | 18045 | 5421 | 102 |
2392842 | 2392842 | 2022-04-10 | Fountain | Indiana | 18045 | 5418 | 102 |
2389586 | 2389586 | 2022-04-09 | Fountain | Indiana | 18045 | 5418 | 102 |
2386331 | 2386331 | 2022-04-08 | Fountain | Indiana | 18045 | 5418 | 102 |
2383076 | 2383076 | 2022-04-07 | Fountain | Indiana | 18045 | 5411 | 102 |
2379821 | 2379821 | 2022-04-06 | Fountain | Indiana | 18045 | 5411 | 102 |
2376567 | 2376567 | 2022-04-05 | Fountain | Indiana | 18045 | 5408 | 102 |
2373315 | 2373315 | 2022-04-04 | Fountain | Indiana | 18045 | 5408 | 102 |
2370062 | 2370062 | 2022-04-03 | Fountain | Indiana | 18045 | 5405 | 102 |
2366809 | 2366809 | 2022-04-02 | Fountain | Indiana | 18045 | 5405 | 102 |
2363556 | 2363556 | 2022-04-01 | Fountain | Indiana | 18045 | 5405 | 102 |
2360302 | 2360302 | 2022-03-31 | Fountain | Indiana | 18045 | 5395 | 101 |
2357048 | 2357048 | 2022-03-30 | Fountain | Indiana | 18045 | 5395 | 101 |
2353795 | 2353795 | 2022-03-29 | Fountain | Indiana | 18045 | 5404 | 101 |
2350543 | 2350543 | 2022-03-28 | Fountain | Indiana | 18045 | 5396 | 101 |
2347290 | 2347290 | 2022-03-27 | Fountain | Indiana | 18045 | 5394 | 101 |
2344037 | 2344037 | 2022-03-26 | Fountain | Indiana | 18045 | 5394 | 101 |
2340784 | 2340784 | 2022-03-25 | Fountain | Indiana | 18045 | 5394 | 101 |
2337531 | 2337531 | 2022-03-24 | Fountain | Indiana | 18045 | 5393 | 101 |
2334277 | 2334277 | 2022-03-23 | Fountain | Indiana | 18045 | 5389 | 101 |
2331023 | 2331023 | 2022-03-22 | Fountain | Indiana | 18045 | 5383 | 101 |
2327771 | 2327771 | 2022-03-21 | Fountain | Indiana | 18045 | 5382 | 101 |
2324518 | 2324518 | 2022-03-20 | Fountain | Indiana | 18045 | 5382 | 101 |
2321264 | 2321264 | 2022-03-19 | Fountain | Indiana | 18045 | 5382 | 101 |
2318010 | 2318010 | 2022-03-18 | Fountain | Indiana | 18045 | 5382 | 101 |
2314757 | 2314757 | 2022-03-17 | Fountain | Indiana | 18045 | 5383 | 100 |
2311504 | 2311504 | 2022-03-16 | Fountain | Indiana | 18045 | 5382 | 100 |
2308251 | 2308251 | 2022-03-15 | Fountain | Indiana | 18045 | 5382 | 100 |
2305000 | 2305000 | 2022-03-14 | Fountain | Indiana | 18045 | 5381 | 100 |
2301748 | 2301748 | 2022-03-13 | Fountain | Indiana | 18045 | 5378 | 100 |
2298496 | 2298496 | 2022-03-12 | Fountain | Indiana | 18045 | 5378 | 100 |
2295244 | 2295244 | 2022-03-11 | Fountain | Indiana | 18045 | 5378 | 100 |
2291992 | 2291992 | 2022-03-10 | Fountain | Indiana | 18045 | 5376 | 99 |
2288740 | 2288740 | 2022-03-09 | Fountain | Indiana | 18045 | 5375 | 99 |
2285489 | 2285489 | 2022-03-08 | Fountain | Indiana | 18045 | 5375 | 98 |
2282237 | 2282237 | 2022-03-07 | Fountain | Indiana | 18045 | 5374 | 97 |
2278984 | 2278984 | 2022-03-06 | Fountain | Indiana | 18045 | 5369 | 97 |
2275731 | 2275731 | 2022-03-05 | Fountain | Indiana | 18045 | 5369 | 97 |
2272478 | 2272478 | 2022-03-04 | Fountain | Indiana | 18045 | 5369 | 97 |
2269226 | 2269226 | 2022-03-03 | Fountain | Indiana | 18045 | 5357 | 97 |
2265973 | 2265973 | 2022-03-02 | Fountain | Indiana | 18045 | 5356 | 97 |
2262722 | 2262722 | 2022-03-01 | Fountain | Indiana | 18045 | 5352 | 97 |
2259471 | 2259471 | 2022-02-28 | Fountain | Indiana | 18045 | 5350 | 97 |
2256220 | 2256220 | 2022-02-27 | Fountain | Indiana | 18045 | 5343 | 97 |
2252969 | 2252969 | 2022-02-26 | Fountain | Indiana | 18045 | 5343 | 97 |
2249718 | 2249718 | 2022-02-25 | Fountain | Indiana | 18045 | 5343 | 97 |
2246467 | 2246467 | 2022-02-24 | Fountain | Indiana | 18045 | 5338 | 97 |
2243216 | 2243216 | 2022-02-23 | Fountain | Indiana | 18045 | 5336 | 97 |
2239965 | 2239965 | 2022-02-22 | Fountain | Indiana | 18045 | 5336 | 97 |
2236714 | 2236714 | 2022-02-21 | Fountain | Indiana | 18045 | 5332 | 97 |
2233463 | 2233463 | 2022-02-20 | Fountain | Indiana | 18045 | 5318 | 97 |
2230212 | 2230212 | 2022-02-19 | Fountain | Indiana | 18045 | 5318 | 97 |
2226961 | 2226961 | 2022-02-18 | Fountain | Indiana | 18045 | 5318 | 97 |
2223710 | 2223710 | 2022-02-17 | Fountain | Indiana | 18045 | 5313 | 97 |
2220459 | 2220459 | 2022-02-16 | Fountain | Indiana | 18045 | 5303 | 96 |
2217208 | 2217208 | 2022-02-15 | Fountain | Indiana | 18045 | 5286 | 95 |
2213957 | 2213957 | 2022-02-14 | Fountain | Indiana | 18045 | 5282 | 95 |
2210705 | 2210705 | 2022-02-13 | Fountain | Indiana | 18045 | 5262 | 95 |
2207452 | 2207452 | 2022-02-12 | Fountain | Indiana | 18045 | 5262 | 95 |
2204199 | 2204199 | 2022-02-11 | Fountain | Indiana | 18045 | 5262 | 95 |
2200946 | 2200946 | 2022-02-10 | Fountain | Indiana | 18045 | 5253 | 94 |
2197692 | 2197692 | 2022-02-09 | Fountain | Indiana | 18045 | 5229 | 94 |
2194438 | 2194438 | 2022-02-08 | Fountain | Indiana | 18045 | 5229 | 94 |
2191184 | 2191184 | 2022-02-07 | Fountain | Indiana | 18045 | 5219 | 93 |
2187931 | 2187931 | 2022-02-06 | Fountain | Indiana | 18045 | 5216 | 92 |
2184678 | 2184678 | 2022-02-05 | Fountain | Indiana | 18045 | 5216 | 92 |
2181426 | 2181426 | 2022-02-04 | Fountain | Indiana | 18045 | 5216 | 92 |
2178175 | 2178175 | 2022-02-03 | Fountain | Indiana | 18045 | 5213 | 92 |
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);