ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Jasper" and fips = 18073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2457973 | 2457973 | 2022-04-30 | Jasper | Indiana | 18073 | 9079 | 149 |
2454717 | 2454717 | 2022-04-29 | Jasper | Indiana | 18073 | 9079 | 149 |
2451461 | 2451461 | 2022-04-28 | Jasper | Indiana | 18073 | 9068 | 149 |
2448205 | 2448205 | 2022-04-27 | Jasper | Indiana | 18073 | 9068 | 149 |
2444949 | 2444949 | 2022-04-26 | Jasper | Indiana | 18073 | 9057 | 148 |
2441693 | 2441693 | 2022-04-25 | Jasper | Indiana | 18073 | 9057 | 148 |
2438437 | 2438437 | 2022-04-24 | Jasper | Indiana | 18073 | 9039 | 148 |
2435181 | 2435181 | 2022-04-23 | Jasper | Indiana | 18073 | 9039 | 148 |
2431925 | 2431925 | 2022-04-22 | Jasper | Indiana | 18073 | 9039 | 148 |
2428669 | 2428669 | 2022-04-21 | Jasper | Indiana | 18073 | 9025 | 148 |
2425413 | 2425413 | 2022-04-20 | Jasper | Indiana | 18073 | 9025 | 148 |
2422157 | 2422157 | 2022-04-19 | Jasper | Indiana | 18073 | 9022 | 148 |
2418901 | 2418901 | 2022-04-18 | Jasper | Indiana | 18073 | 9022 | 148 |
2415645 | 2415645 | 2022-04-17 | Jasper | Indiana | 18073 | 9016 | 148 |
2412389 | 2412389 | 2022-04-16 | Jasper | Indiana | 18073 | 9016 | 148 |
2409133 | 2409133 | 2022-04-15 | Jasper | Indiana | 18073 | 9016 | 148 |
2405877 | 2405877 | 2022-04-14 | Jasper | Indiana | 18073 | 9016 | 148 |
2402622 | 2402622 | 2022-04-13 | Jasper | Indiana | 18073 | 9016 | 148 |
2399367 | 2399367 | 2022-04-12 | Jasper | Indiana | 18073 | 9015 | 148 |
2396112 | 2396112 | 2022-04-11 | Jasper | Indiana | 18073 | 9015 | 148 |
2392856 | 2392856 | 2022-04-10 | Jasper | Indiana | 18073 | 9012 | 148 |
2389600 | 2389600 | 2022-04-09 | Jasper | Indiana | 18073 | 9012 | 148 |
2386345 | 2386345 | 2022-04-08 | Jasper | Indiana | 18073 | 9012 | 148 |
2383090 | 2383090 | 2022-04-07 | Jasper | Indiana | 18073 | 9010 | 148 |
2379835 | 2379835 | 2022-04-06 | Jasper | Indiana | 18073 | 9010 | 148 |
2376581 | 2376581 | 2022-04-05 | Jasper | Indiana | 18073 | 9010 | 148 |
2373329 | 2373329 | 2022-04-04 | Jasper | Indiana | 18073 | 9010 | 148 |
2370076 | 2370076 | 2022-04-03 | Jasper | Indiana | 18073 | 9008 | 148 |
2366823 | 2366823 | 2022-04-02 | Jasper | Indiana | 18073 | 9008 | 148 |
2363570 | 2363570 | 2022-04-01 | Jasper | Indiana | 18073 | 9008 | 148 |
2360316 | 2360316 | 2022-03-31 | Jasper | Indiana | 18073 | 9005 | 147 |
2357062 | 2357062 | 2022-03-30 | Jasper | Indiana | 18073 | 9005 | 147 |
2353809 | 2353809 | 2022-03-29 | Jasper | Indiana | 18073 | 9015 | 147 |
2350557 | 2350557 | 2022-03-28 | Jasper | Indiana | 18073 | 9013 | 147 |
2347304 | 2347304 | 2022-03-27 | Jasper | Indiana | 18073 | 9010 | 147 |
2344051 | 2344051 | 2022-03-26 | Jasper | Indiana | 18073 | 9010 | 147 |
2340798 | 2340798 | 2022-03-25 | Jasper | Indiana | 18073 | 9010 | 147 |
2337545 | 2337545 | 2022-03-24 | Jasper | Indiana | 18073 | 9008 | 147 |
2334291 | 2334291 | 2022-03-23 | Jasper | Indiana | 18073 | 9003 | 147 |
2331037 | 2331037 | 2022-03-22 | Jasper | Indiana | 18073 | 9002 | 147 |
2327785 | 2327785 | 2022-03-21 | Jasper | Indiana | 18073 | 8997 | 147 |
2324532 | 2324532 | 2022-03-20 | Jasper | Indiana | 18073 | 8994 | 147 |
2321278 | 2321278 | 2022-03-19 | Jasper | Indiana | 18073 | 8994 | 147 |
2318024 | 2318024 | 2022-03-18 | Jasper | Indiana | 18073 | 8994 | 147 |
2314771 | 2314771 | 2022-03-17 | Jasper | Indiana | 18073 | 8993 | 147 |
2311518 | 2311518 | 2022-03-16 | Jasper | Indiana | 18073 | 8991 | 146 |
2308265 | 2308265 | 2022-03-15 | Jasper | Indiana | 18073 | 8991 | 146 |
2305014 | 2305014 | 2022-03-14 | Jasper | Indiana | 18073 | 8987 | 146 |
2301762 | 2301762 | 2022-03-13 | Jasper | Indiana | 18073 | 8983 | 145 |
2298510 | 2298510 | 2022-03-12 | Jasper | Indiana | 18073 | 8983 | 145 |
2295258 | 2295258 | 2022-03-11 | Jasper | Indiana | 18073 | 8983 | 145 |
2292006 | 2292006 | 2022-03-10 | Jasper | Indiana | 18073 | 8983 | 145 |
2288754 | 2288754 | 2022-03-09 | Jasper | Indiana | 18073 | 8983 | 145 |
2285503 | 2285503 | 2022-03-08 | Jasper | Indiana | 18073 | 8976 | 144 |
2282251 | 2282251 | 2022-03-07 | Jasper | Indiana | 18073 | 8974 | 144 |
2278998 | 2278998 | 2022-03-06 | Jasper | Indiana | 18073 | 8969 | 144 |
2275745 | 2275745 | 2022-03-05 | Jasper | Indiana | 18073 | 8969 | 144 |
2272492 | 2272492 | 2022-03-04 | Jasper | Indiana | 18073 | 8969 | 144 |
2269240 | 2269240 | 2022-03-03 | Jasper | Indiana | 18073 | 8967 | 144 |
2265987 | 2265987 | 2022-03-02 | Jasper | Indiana | 18073 | 8966 | 143 |
2262736 | 2262736 | 2022-03-01 | Jasper | Indiana | 18073 | 8965 | 143 |
2259485 | 2259485 | 2022-02-28 | Jasper | Indiana | 18073 | 8964 | 143 |
2256234 | 2256234 | 2022-02-27 | Jasper | Indiana | 18073 | 8955 | 143 |
2252983 | 2252983 | 2022-02-26 | Jasper | Indiana | 18073 | 8955 | 143 |
2249732 | 2249732 | 2022-02-25 | Jasper | Indiana | 18073 | 8955 | 143 |
2246481 | 2246481 | 2022-02-24 | Jasper | Indiana | 18073 | 8950 | 143 |
2243230 | 2243230 | 2022-02-23 | Jasper | Indiana | 18073 | 8946 | 143 |
2239979 | 2239979 | 2022-02-22 | Jasper | Indiana | 18073 | 8943 | 143 |
2236728 | 2236728 | 2022-02-21 | Jasper | Indiana | 18073 | 8937 | 143 |
2233477 | 2233477 | 2022-02-20 | Jasper | Indiana | 18073 | 8921 | 143 |
2230226 | 2230226 | 2022-02-19 | Jasper | Indiana | 18073 | 8921 | 143 |
2226975 | 2226975 | 2022-02-18 | Jasper | Indiana | 18073 | 8921 | 143 |
2223724 | 2223724 | 2022-02-17 | Jasper | Indiana | 18073 | 8912 | 143 |
2220473 | 2220473 | 2022-02-16 | Jasper | Indiana | 18073 | 8908 | 139 |
2217222 | 2217222 | 2022-02-15 | Jasper | Indiana | 18073 | 8906 | 138 |
2213971 | 2213971 | 2022-02-14 | Jasper | Indiana | 18073 | 8898 | 137 |
2210719 | 2210719 | 2022-02-13 | Jasper | Indiana | 18073 | 8883 | 137 |
2207466 | 2207466 | 2022-02-12 | Jasper | Indiana | 18073 | 8883 | 137 |
2204213 | 2204213 | 2022-02-11 | Jasper | Indiana | 18073 | 8883 | 137 |
2200960 | 2200960 | 2022-02-10 | Jasper | Indiana | 18073 | 8873 | 136 |
2197706 | 2197706 | 2022-02-09 | Jasper | Indiana | 18073 | 8847 | 135 |
2194452 | 2194452 | 2022-02-08 | Jasper | Indiana | 18073 | 8847 | 135 |
2191198 | 2191198 | 2022-02-07 | Jasper | Indiana | 18073 | 8836 | 135 |
2187945 | 2187945 | 2022-02-06 | Jasper | Indiana | 18073 | 8817 | 135 |
2184692 | 2184692 | 2022-02-05 | Jasper | Indiana | 18073 | 8817 | 135 |
2181440 | 2181440 | 2022-02-04 | Jasper | Indiana | 18073 | 8817 | 135 |
2178189 | 2178189 | 2022-02-03 | Jasper | Indiana | 18073 | 8804 | 135 |
2174936 | 2174936 | 2022-02-02 | Jasper | Indiana | 18073 | 8781 | 132 |
2171683 | 2171683 | 2022-02-01 | Jasper | Indiana | 18073 | 8749 | 129 |
2168430 | 2168430 | 2022-01-31 | Jasper | Indiana | 18073 | 8708 | 127 |
2165175 | 2165175 | 2022-01-30 | Jasper | Indiana | 18073 | 8641 | 126 |
2161920 | 2161920 | 2022-01-29 | Jasper | Indiana | 18073 | 8641 | 126 |
2158665 | 2158665 | 2022-01-28 | Jasper | Indiana | 18073 | 8641 | 126 |
2155411 | 2155411 | 2022-01-27 | Jasper | Indiana | 18073 | 8567 | 125 |
2152158 | 2152158 | 2022-01-26 | Jasper | Indiana | 18073 | 8523 | 122 |
2148906 | 2148906 | 2022-01-25 | Jasper | Indiana | 18073 | 8504 | 122 |
2145654 | 2145654 | 2022-01-24 | Jasper | Indiana | 18073 | 8471 | 122 |
2142399 | 2142399 | 2022-01-23 | Jasper | Indiana | 18073 | 8334 | 122 |
2139144 | 2139144 | 2022-01-22 | Jasper | Indiana | 18073 | 8334 | 122 |
2135888 | 2135888 | 2022-01-21 | Jasper | Indiana | 18073 | 8334 | 122 |
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);