ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where county = "Jefferson" and deaths = 22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2241424 | 2241424 | 2022-02-22 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2238173 | 2238173 | 2022-02-21 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2234922 | 2234922 | 2022-02-20 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2231671 | 2231671 | 2022-02-19 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2228420 | 2228420 | 2022-02-18 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2225169 | 2225169 | 2022-02-17 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2221918 | 2221918 | 2022-02-16 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2167515 | 2167515 | 2022-01-30 | Jefferson | Washington | 53031 | 2452 | 22 |
2164260 | 2164260 | 2022-01-29 | Jefferson | Washington | 53031 | 2452 | 22 |
2161005 | 2161005 | 2022-01-28 | Jefferson | Washington | 53031 | 2452 | 22 |
2156306 | 2156306 | 2022-01-27 | Jefferson | Montana | 30043 | 2305 | 22 |
2157749 | 2157749 | 2022-01-27 | Jefferson | Washington | 53031 | 2385 | 22 |
2153053 | 2153053 | 2022-01-26 | Jefferson | Montana | 30043 | 2278 | 22 |
2154496 | 2154496 | 2022-01-26 | Jefferson | Washington | 53031 | 2385 | 22 |
2149801 | 2149801 | 2022-01-25 | Jefferson | Montana | 30043 | 2247 | 22 |
2151243 | 2151243 | 2022-01-25 | Jefferson | Washington | 53031 | 2291 | 22 |
2146549 | 2146549 | 2022-01-24 | Jefferson | Montana | 30043 | 2222 | 22 |
2147991 | 2147991 | 2022-01-24 | Jefferson | Washington | 53031 | 2291 | 22 |
2143294 | 2143294 | 2022-01-23 | Jefferson | Montana | 30043 | 2180 | 22 |
2144739 | 2144739 | 2022-01-23 | Jefferson | Washington | 53031 | 2191 | 22 |
2140039 | 2140039 | 2022-01-22 | Jefferson | Montana | 30043 | 2180 | 22 |
2141484 | 2141484 | 2022-01-22 | Jefferson | Washington | 53031 | 2191 | 22 |
2136783 | 2136783 | 2022-01-21 | Jefferson | Montana | 30043 | 2180 | 22 |
2138228 | 2138228 | 2022-01-21 | Jefferson | Washington | 53031 | 2191 | 22 |
2133531 | 2133531 | 2022-01-20 | Jefferson | Montana | 30043 | 2152 | 22 |
2134973 | 2134973 | 2022-01-20 | Jefferson | Washington | 53031 | 2128 | 22 |
2130278 | 2130278 | 2022-01-19 | Jefferson | Montana | 30043 | 2117 | 22 |
2131721 | 2131721 | 2022-01-19 | Jefferson | Washington | 53031 | 2080 | 22 |
2127024 | 2127024 | 2022-01-18 | Jefferson | Montana | 30043 | 2091 | 22 |
2128467 | 2128467 | 2022-01-18 | Jefferson | Washington | 53031 | 2046 | 22 |
2123772 | 2123772 | 2022-01-17 | Jefferson | Montana | 30043 | 2062 | 22 |
2125214 | 2125214 | 2022-01-17 | Jefferson | Washington | 53031 | 1949 | 22 |
2120520 | 2120520 | 2022-01-16 | Jefferson | Montana | 30043 | 2062 | 22 |
2121962 | 2121962 | 2022-01-16 | Jefferson | Washington | 53031 | 1949 | 22 |
2117268 | 2117268 | 2022-01-15 | Jefferson | Montana | 30043 | 2062 | 22 |
2118710 | 2118710 | 2022-01-15 | Jefferson | Washington | 53031 | 1949 | 22 |
2114017 | 2114017 | 2022-01-14 | Jefferson | Montana | 30043 | 2062 | 22 |
2115458 | 2115458 | 2022-01-14 | Jefferson | Washington | 53031 | 1949 | 22 |
2110765 | 2110765 | 2022-01-13 | Jefferson | Montana | 30043 | 2045 | 22 |
2107514 | 2107514 | 2022-01-12 | Jefferson | Montana | 30043 | 2022 | 22 |
2104263 | 2104263 | 2022-01-11 | Jefferson | Montana | 30043 | 2006 | 22 |
2101012 | 2101012 | 2022-01-10 | Jefferson | Montana | 30043 | 1996 | 22 |
2097761 | 2097761 | 2022-01-09 | Jefferson | Montana | 30043 | 1984 | 22 |
2094509 | 2094509 | 2022-01-08 | Jefferson | Montana | 30043 | 1984 | 22 |
2091257 | 2091257 | 2022-01-07 | Jefferson | Montana | 30043 | 1984 | 22 |
2088006 | 2088006 | 2022-01-06 | Jefferson | Montana | 30043 | 1977 | 22 |
2084754 | 2084754 | 2022-01-05 | Jefferson | Montana | 30043 | 1967 | 22 |
1219675 | 1219675 | 2021-04-14 | Jefferson | Idaho | 16051 | 2931 | 22 |
1216427 | 1216427 | 2021-04-13 | Jefferson | Idaho | 16051 | 2923 | 22 |
1213180 | 1213180 | 2021-04-12 | Jefferson | Idaho | 16051 | 2920 | 22 |
1209932 | 1209932 | 2021-04-11 | Jefferson | Idaho | 16051 | 2902 | 22 |
1206683 | 1206683 | 2021-04-10 | Jefferson | Idaho | 16051 | 2902 | 22 |
1203435 | 1203435 | 2021-04-09 | Jefferson | Idaho | 16051 | 2902 | 22 |
1200187 | 1200187 | 2021-04-08 | Jefferson | Idaho | 16051 | 2889 | 22 |
1196938 | 1196938 | 2021-04-07 | Jefferson | Idaho | 16051 | 2883 | 22 |
1193690 | 1193690 | 2021-04-06 | Jefferson | Idaho | 16051 | 2876 | 22 |
1190440 | 1190440 | 2021-04-05 | Jefferson | Idaho | 16051 | 2865 | 22 |
1187193 | 1187193 | 2021-04-04 | Jefferson | Idaho | 16051 | 2844 | 22 |
1183946 | 1183946 | 2021-04-03 | Jefferson | Idaho | 16051 | 2844 | 22 |
1180699 | 1180699 | 2021-04-02 | Jefferson | Idaho | 16051 | 2844 | 22 |
1177452 | 1177452 | 2021-04-01 | Jefferson | Idaho | 16051 | 2832 | 22 |
1174205 | 1174205 | 2021-03-31 | Jefferson | Idaho | 16051 | 2816 | 22 |
1170958 | 1170958 | 2021-03-30 | Jefferson | Idaho | 16051 | 2803 | 22 |
1167710 | 1167710 | 2021-03-29 | Jefferson | Idaho | 16051 | 2786 | 22 |
1164462 | 1164462 | 2021-03-28 | Jefferson | Idaho | 16051 | 2775 | 22 |
1161214 | 1161214 | 2021-03-27 | Jefferson | Idaho | 16051 | 2775 | 22 |
1157966 | 1157966 | 2021-03-26 | Jefferson | Idaho | 16051 | 2763 | 22 |
1154719 | 1154719 | 2021-03-25 | Jefferson | Idaho | 16051 | 2750 | 22 |
1151472 | 1151472 | 2021-03-24 | Jefferson | Idaho | 16051 | 2725 | 22 |
1148225 | 1148225 | 2021-03-23 | Jefferson | Idaho | 16051 | 2711 | 22 |
1144978 | 1144978 | 2021-03-22 | Jefferson | Idaho | 16051 | 2697 | 22 |
1141731 | 1141731 | 2021-03-21 | Jefferson | Idaho | 16051 | 2686 | 22 |
1138485 | 1138485 | 2021-03-20 | Jefferson | Idaho | 16051 | 2686 | 22 |
1135239 | 1135239 | 2021-03-19 | Jefferson | Idaho | 16051 | 2675 | 22 |
1131992 | 1131992 | 2021-03-18 | Jefferson | Idaho | 16051 | 2663 | 22 |
1128744 | 1128744 | 2021-03-17 | Jefferson | Idaho | 16051 | 2647 | 22 |
1125498 | 1125498 | 2021-03-16 | Jefferson | Idaho | 16051 | 2630 | 22 |
1122252 | 1122252 | 2021-03-15 | Jefferson | Idaho | 16051 | 2612 | 22 |
1119005 | 1119005 | 2021-03-14 | Jefferson | Idaho | 16051 | 2596 | 22 |
1115758 | 1115758 | 2021-03-13 | Jefferson | Idaho | 16051 | 2596 | 22 |
1112512 | 1112512 | 2021-03-12 | Jefferson | Idaho | 16051 | 2581 | 22 |
1109266 | 1109266 | 2021-03-11 | Jefferson | Idaho | 16051 | 2570 | 22 |
1106020 | 1106020 | 2021-03-10 | Jefferson | Idaho | 16051 | 2559 | 22 |
1102774 | 1102774 | 2021-03-09 | Jefferson | Idaho | 16051 | 2534 | 22 |
1099528 | 1099528 | 2021-03-08 | Jefferson | Idaho | 16051 | 2521 | 22 |
1096280 | 1096280 | 2021-03-07 | Jefferson | Idaho | 16051 | 2502 | 22 |
1093034 | 1093034 | 2021-03-06 | Jefferson | Idaho | 16051 | 2502 | 22 |
1089788 | 1089788 | 2021-03-05 | Jefferson | Idaho | 16051 | 2494 | 22 |
1086543 | 1086543 | 2021-03-04 | Jefferson | Idaho | 16051 | 2482 | 22 |
1083297 | 1083297 | 2021-03-03 | Jefferson | Idaho | 16051 | 2474 | 22 |
1080051 | 1080051 | 2021-03-02 | Jefferson | Idaho | 16051 | 2467 | 22 |
1076806 | 1076806 | 2021-03-01 | Jefferson | Idaho | 16051 | 2455 | 22 |
1073560 | 1073560 | 2021-02-28 | Jefferson | Idaho | 16051 | 2447 | 22 |
1070314 | 1070314 | 2021-02-27 | Jefferson | Idaho | 16051 | 2447 | 22 |
1067069 | 1067069 | 2021-02-26 | Jefferson | Idaho | 16051 | 2444 | 22 |
1063824 | 1063824 | 2021-02-25 | Jefferson | Idaho | 16051 | 2439 | 22 |
1050612 | 1050612 | 2021-02-21 | Jefferson | Florida | 12065 | 1390 | 22 |
1047365 | 1047365 | 2021-02-20 | Jefferson | Florida | 12065 | 1390 | 22 |
1044120 | 1044120 | 2021-02-19 | Jefferson | Florida | 12065 | 1385 | 22 |
1040875 | 1040875 | 2021-02-18 | Jefferson | Florida | 12065 | 1380 | 22 |
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);