ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 18177 and state = "Indiana" 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 |
---|---|---|---|---|---|---|---|
2500369 | 2500369 | 2022-05-13 | Wayne | Indiana | 18177 | 18900 | 337 |
2497111 | 2497111 | 2022-05-12 | Wayne | Indiana | 18177 | 18886 | 337 |
2493853 | 2493853 | 2022-05-11 | Wayne | Indiana | 18177 | 18886 | 337 |
2490595 | 2490595 | 2022-05-10 | Wayne | Indiana | 18177 | 18877 | 337 |
2487338 | 2487338 | 2022-05-09 | Wayne | Indiana | 18177 | 18877 | 337 |
2484080 | 2484080 | 2022-05-08 | Wayne | Indiana | 18177 | 18864 | 337 |
2480822 | 2480822 | 2022-05-07 | Wayne | Indiana | 18177 | 18864 | 337 |
2477564 | 2477564 | 2022-05-06 | Wayne | Indiana | 18177 | 18864 | 337 |
2474306 | 2474306 | 2022-05-05 | Wayne | Indiana | 18177 | 18864 | 337 |
2471049 | 2471049 | 2022-05-04 | Wayne | Indiana | 18177 | 18864 | 337 |
2467793 | 2467793 | 2022-05-03 | Wayne | Indiana | 18177 | 18858 | 337 |
2464538 | 2464538 | 2022-05-02 | Wayne | Indiana | 18177 | 18858 | 337 |
2461282 | 2461282 | 2022-05-01 | Wayne | Indiana | 18177 | 18856 | 337 |
2458026 | 2458026 | 2022-04-30 | Wayne | Indiana | 18177 | 18856 | 337 |
2454770 | 2454770 | 2022-04-29 | Wayne | Indiana | 18177 | 18856 | 337 |
2451514 | 2451514 | 2022-04-28 | Wayne | Indiana | 18177 | 18853 | 336 |
2448258 | 2448258 | 2022-04-27 | Wayne | Indiana | 18177 | 18853 | 336 |
2445002 | 2445002 | 2022-04-26 | Wayne | Indiana | 18177 | 18846 | 336 |
2441746 | 2441746 | 2022-04-25 | Wayne | Indiana | 18177 | 18846 | 336 |
2438490 | 2438490 | 2022-04-24 | Wayne | Indiana | 18177 | 18842 | 336 |
2435234 | 2435234 | 2022-04-23 | Wayne | Indiana | 18177 | 18842 | 336 |
2431978 | 2431978 | 2022-04-22 | Wayne | Indiana | 18177 | 18842 | 336 |
2428722 | 2428722 | 2022-04-21 | Wayne | Indiana | 18177 | 18840 | 335 |
2425466 | 2425466 | 2022-04-20 | Wayne | Indiana | 18177 | 18840 | 335 |
2422210 | 2422210 | 2022-04-19 | Wayne | Indiana | 18177 | 18837 | 335 |
2418954 | 2418954 | 2022-04-18 | Wayne | Indiana | 18177 | 18837 | 335 |
2415698 | 2415698 | 2022-04-17 | Wayne | Indiana | 18177 | 18836 | 334 |
2412442 | 2412442 | 2022-04-16 | Wayne | Indiana | 18177 | 18836 | 334 |
2409186 | 2409186 | 2022-04-15 | Wayne | Indiana | 18177 | 18836 | 334 |
2405930 | 2405930 | 2022-04-14 | Wayne | Indiana | 18177 | 18836 | 334 |
2402674 | 2402674 | 2022-04-13 | Wayne | Indiana | 18177 | 18836 | 334 |
2399420 | 2399420 | 2022-04-12 | Wayne | Indiana | 18177 | 18834 | 334 |
2396164 | 2396164 | 2022-04-11 | Wayne | Indiana | 18177 | 18834 | 334 |
2392909 | 2392909 | 2022-04-10 | Wayne | Indiana | 18177 | 18833 | 334 |
2389653 | 2389653 | 2022-04-09 | Wayne | Indiana | 18177 | 18833 | 334 |
2386397 | 2386397 | 2022-04-08 | Wayne | Indiana | 18177 | 18833 | 334 |
2383143 | 2383143 | 2022-04-07 | Wayne | Indiana | 18177 | 18832 | 334 |
2379888 | 2379888 | 2022-04-06 | Wayne | Indiana | 18177 | 18832 | 334 |
2376633 | 2376633 | 2022-04-05 | Wayne | Indiana | 18177 | 18826 | 334 |
2373381 | 2373381 | 2022-04-04 | Wayne | Indiana | 18177 | 18826 | 334 |
2370128 | 2370128 | 2022-04-03 | Wayne | Indiana | 18177 | 18825 | 334 |
2366875 | 2366875 | 2022-04-02 | Wayne | Indiana | 18177 | 18825 | 334 |
2363622 | 2363622 | 2022-04-01 | Wayne | Indiana | 18177 | 18825 | 334 |
2360368 | 2360368 | 2022-03-31 | Wayne | Indiana | 18177 | 18820 | 334 |
2357114 | 2357114 | 2022-03-30 | Wayne | Indiana | 18177 | 18820 | 334 |
2353861 | 2353861 | 2022-03-29 | Wayne | Indiana | 18177 | 19198 | 334 |
2350609 | 2350609 | 2022-03-28 | Wayne | Indiana | 18177 | 19196 | 334 |
2347356 | 2347356 | 2022-03-27 | Wayne | Indiana | 18177 | 19194 | 334 |
2344103 | 2344103 | 2022-03-26 | Wayne | Indiana | 18177 | 19194 | 334 |
2340850 | 2340850 | 2022-03-25 | Wayne | Indiana | 18177 | 19194 | 334 |
2337597 | 2337597 | 2022-03-24 | Wayne | Indiana | 18177 | 19193 | 333 |
2334343 | 2334343 | 2022-03-23 | Wayne | Indiana | 18177 | 19192 | 333 |
2331089 | 2331089 | 2022-03-22 | Wayne | Indiana | 18177 | 19190 | 331 |
2327837 | 2327837 | 2022-03-21 | Wayne | Indiana | 18177 | 19188 | 331 |
2324584 | 2324584 | 2022-03-20 | Wayne | Indiana | 18177 | 19187 | 331 |
2321330 | 2321330 | 2022-03-19 | Wayne | Indiana | 18177 | 19187 | 331 |
2318076 | 2318076 | 2022-03-18 | Wayne | Indiana | 18177 | 19187 | 331 |
2314823 | 2314823 | 2022-03-17 | Wayne | Indiana | 18177 | 19188 | 330 |
2311570 | 2311570 | 2022-03-16 | Wayne | Indiana | 18177 | 19184 | 330 |
2308317 | 2308317 | 2022-03-15 | Wayne | Indiana | 18177 | 19181 | 330 |
2305066 | 2305066 | 2022-03-14 | Wayne | Indiana | 18177 | 19178 | 330 |
2301814 | 2301814 | 2022-03-13 | Wayne | Indiana | 18177 | 19172 | 330 |
2298562 | 2298562 | 2022-03-12 | Wayne | Indiana | 18177 | 19172 | 330 |
2295310 | 2295310 | 2022-03-11 | Wayne | Indiana | 18177 | 19172 | 330 |
2292058 | 2292058 | 2022-03-10 | Wayne | Indiana | 18177 | 19166 | 330 |
2288806 | 2288806 | 2022-03-09 | Wayne | Indiana | 18177 | 19166 | 330 |
2285555 | 2285555 | 2022-03-08 | Wayne | Indiana | 18177 | 19159 | 330 |
2282303 | 2282303 | 2022-03-07 | Wayne | Indiana | 18177 | 19152 | 330 |
2279050 | 2279050 | 2022-03-06 | Wayne | Indiana | 18177 | 19146 | 330 |
2275797 | 2275797 | 2022-03-05 | Wayne | Indiana | 18177 | 19146 | 330 |
2272544 | 2272544 | 2022-03-04 | Wayne | Indiana | 18177 | 19146 | 330 |
2269292 | 2269292 | 2022-03-03 | Wayne | Indiana | 18177 | 19141 | 330 |
2266039 | 2266039 | 2022-03-02 | Wayne | Indiana | 18177 | 19138 | 330 |
2262788 | 2262788 | 2022-03-01 | Wayne | Indiana | 18177 | 19131 | 330 |
2259537 | 2259537 | 2022-02-28 | Wayne | Indiana | 18177 | 19127 | 330 |
2256286 | 2256286 | 2022-02-27 | Wayne | Indiana | 18177 | 19112 | 330 |
2253035 | 2253035 | 2022-02-26 | Wayne | Indiana | 18177 | 19112 | 330 |
2249784 | 2249784 | 2022-02-25 | Wayne | Indiana | 18177 | 19112 | 330 |
2246533 | 2246533 | 2022-02-24 | Wayne | Indiana | 18177 | 19106 | 329 |
2243282 | 2243282 | 2022-02-23 | Wayne | Indiana | 18177 | 19099 | 329 |
2240031 | 2240031 | 2022-02-22 | Wayne | Indiana | 18177 | 19083 | 327 |
2236780 | 2236780 | 2022-02-21 | Wayne | Indiana | 18177 | 19074 | 325 |
2233529 | 2233529 | 2022-02-20 | Wayne | Indiana | 18177 | 19038 | 325 |
2230278 | 2230278 | 2022-02-19 | Wayne | Indiana | 18177 | 19038 | 325 |
2227027 | 2227027 | 2022-02-18 | Wayne | Indiana | 18177 | 19038 | 325 |
2223776 | 2223776 | 2022-02-17 | Wayne | Indiana | 18177 | 19012 | 325 |
2220525 | 2220525 | 2022-02-16 | Wayne | Indiana | 18177 | 19009 | 325 |
2217274 | 2217274 | 2022-02-15 | Wayne | Indiana | 18177 | 18984 | 323 |
2214023 | 2214023 | 2022-02-14 | Wayne | Indiana | 18177 | 18960 | 322 |
2210771 | 2210771 | 2022-02-13 | Wayne | Indiana | 18177 | 18892 | 322 |
2207518 | 2207518 | 2022-02-12 | Wayne | Indiana | 18177 | 18892 | 322 |
2204265 | 2204265 | 2022-02-11 | Wayne | Indiana | 18177 | 18892 | 322 |
2201012 | 2201012 | 2022-02-10 | Wayne | Indiana | 18177 | 18863 | 321 |
2197758 | 2197758 | 2022-02-09 | Wayne | Indiana | 18177 | 18751 | 319 |
2194504 | 2194504 | 2022-02-08 | Wayne | Indiana | 18177 | 18751 | 319 |
2191250 | 2191250 | 2022-02-07 | Wayne | Indiana | 18177 | 18706 | 319 |
2187997 | 2187997 | 2022-02-06 | Wayne | Indiana | 18177 | 18665 | 319 |
2184744 | 2184744 | 2022-02-05 | Wayne | Indiana | 18177 | 18665 | 319 |
2181492 | 2181492 | 2022-02-04 | Wayne | Indiana | 18177 | 18665 | 319 |
2178241 | 2178241 | 2022-02-03 | Wayne | Indiana | 18177 | 18589 | 318 |
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);