ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
710 rows where fips = 20145 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 202 ✖
- 3 28
- 1174 26
- 2118 21
- 2117 16
- 8 15
- 1143 13
- 1182 13
- 7 11
- 1166 11
- 1179 10
- 1172 9
- 1132 7
- 1142 7
- 1165 7
- 1168 7
- 1178 7
- 2116 7
- 2137 7
- 2139 7
- 1144 6
- 1180 6
- 1183 6
- 2 5
- 5 5
- 954 5
- 1137 5
- 1149 5
- 1215 5
- 1566 5
- 1635 5
- 1659 5
- 1772 5
- 2068 5
- 2119 5
- 2120 5
- 4 4
- 9 4
- 68 4
- 262 4
- 1130 4
- 1145 4
- 2115 4
- 63 3
- 79 3
- 210 3
- 249 3
- 263 3
- 312 3
- 374 3
- 393 3
- 401 3
- 411 3
- 418 3
- 438 3
- 458 3
- 495 3
- 591 3
- 622 3
- 660 3
- 742 3
- 847 3
- 888 3
- 1012 3
- 1033 3
- 1065 3
- 1094 3
- 1106 3
- 1119 3
- 1129 3
- 1131 3
- 1146 3
- 1160 3
- 1173 3
- 1181 3
- 1184 3
- 1191 3
- 1207 3
- 1226 3
- 1253 3
- 1283 3
- 1333 3
- 1391 3
- 1430 3
- 1461 3
- 1489 3
- 1509 3
- 1527 3
- 1558 3
- 1576 3
- 1594 3
- 1620 3
- 1707 3
- 1871 3
- 1964 3
- 2051 3
- 2103 3
- 2113 3
- 151 2
- 180 2
- 187 2
- 245 2
- 266 2
- 281 2
- 344 2
- 368 2
- 382 2
- 385 2
- 397 2
- 399 2
- 406 2
- 409 2
- 413 2
- 415 2
- 431 2
- 435 2
- 440 2
- 443 2
- 468 2
- 482 2
- 549 2
- 675 2
- 717 2
- 804 2
- 834 2
- 852 2
- 872 2
- 914 2
- 967 2
- 982 2
- 1017 2
- 1027 2
- 1045 2
- 1056 2
- 1077 2
- 1085 2
- 1098 2
- 1107 2
- 1109 2
- 1116 2
- 1125 2
- 1128 2
- 1133 2
- 1134 2
- 1147 2
- 1148 2
- 1156 2
- 1176 2
- 1187 2
- 1197 2
- 1204 2
- 1206 2
- 1211 2
- 1218 2
- 1230 2
- 1241 2
- 1259 2
- 1267 2
- 1300 2
- 1322 2
- 1351 2
- 1371 2
- 1409 2
- 1423 2
- 1441 2
- 1451 2
- 1468 2
- 1481 2
- 1497 2
- 1504 2
- 1513 2
- 1517 2
- 1533 2
- 1550 2
- 1561 2
- 1568 2
- 1570 2
- 1584 2
- 1593 2
- 1606 2
- 1613 2
- 1627 2
- 1643 2
- 1680 2
- 1693 2
- 1718 2
- 1737 2
- 1830 2
- 1898 2
- 1929 2
- 2024 2
- 2035 2
- 2062 2
- 2090 2
- 2095 2
- 2106 2
- 2110 2
- 2121 2
- 528 1
- 541 1
- 610 1
- 1175 1
- 2138 1
state 1
- Kansas · 710 ✖
fips 1
- 20145 · 710 ✖
county 1
- Pawnee 710
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500545 | 2500545 | 2022-05-13 | Pawnee | Kansas | 20145 | 2138 | 24 |
2497287 | 2497287 | 2022-05-12 | Pawnee | Kansas | 20145 | 2139 | 24 |
2494029 | 2494029 | 2022-05-11 | Pawnee | Kansas | 20145 | 2139 | 24 |
2490771 | 2490771 | 2022-05-10 | Pawnee | Kansas | 20145 | 2139 | 24 |
2487514 | 2487514 | 2022-05-09 | Pawnee | Kansas | 20145 | 2139 | 24 |
2484256 | 2484256 | 2022-05-08 | Pawnee | Kansas | 20145 | 2139 | 24 |
2480998 | 2480998 | 2022-05-07 | Pawnee | Kansas | 20145 | 2139 | 24 |
2477740 | 2477740 | 2022-05-06 | Pawnee | Kansas | 20145 | 2139 | 24 |
2474482 | 2474482 | 2022-05-05 | Pawnee | Kansas | 20145 | 2137 | 24 |
2471225 | 2471225 | 2022-05-04 | Pawnee | Kansas | 20145 | 2137 | 24 |
2467969 | 2467969 | 2022-05-03 | Pawnee | Kansas | 20145 | 2137 | 24 |
2464714 | 2464714 | 2022-05-02 | Pawnee | Kansas | 20145 | 2137 | 24 |
2461458 | 2461458 | 2022-05-01 | Pawnee | Kansas | 20145 | 2137 | 24 |
2458202 | 2458202 | 2022-04-30 | Pawnee | Kansas | 20145 | 2137 | 24 |
2454946 | 2454946 | 2022-04-29 | Pawnee | Kansas | 20145 | 2137 | 24 |
2451690 | 2451690 | 2022-04-28 | Pawnee | Kansas | 20145 | 2118 | 24 |
2448434 | 2448434 | 2022-04-27 | Pawnee | Kansas | 20145 | 2118 | 24 |
2445178 | 2445178 | 2022-04-26 | Pawnee | Kansas | 20145 | 2118 | 24 |
2441922 | 2441922 | 2022-04-25 | Pawnee | Kansas | 20145 | 2118 | 24 |
2438666 | 2438666 | 2022-04-24 | Pawnee | Kansas | 20145 | 2118 | 24 |
2435410 | 2435410 | 2022-04-23 | Pawnee | Kansas | 20145 | 2118 | 24 |
2432154 | 2432154 | 2022-04-22 | Pawnee | Kansas | 20145 | 2118 | 24 |
2428898 | 2428898 | 2022-04-21 | Pawnee | Kansas | 20145 | 2116 | 24 |
2425642 | 2425642 | 2022-04-20 | Pawnee | Kansas | 20145 | 2116 | 24 |
2422386 | 2422386 | 2022-04-19 | Pawnee | Kansas | 20145 | 2116 | 24 |
2419130 | 2419130 | 2022-04-18 | Pawnee | Kansas | 20145 | 2116 | 24 |
2415874 | 2415874 | 2022-04-17 | Pawnee | Kansas | 20145 | 2116 | 24 |
2412618 | 2412618 | 2022-04-16 | Pawnee | Kansas | 20145 | 2116 | 24 |
2409362 | 2409362 | 2022-04-15 | Pawnee | Kansas | 20145 | 2116 | 24 |
2406106 | 2406106 | 2022-04-14 | Pawnee | Kansas | 20145 | 2117 | 24 |
2402850 | 2402850 | 2022-04-13 | Pawnee | Kansas | 20145 | 2117 | 24 |
2399596 | 2399596 | 2022-04-12 | Pawnee | Kansas | 20145 | 2117 | 24 |
2396340 | 2396340 | 2022-04-11 | Pawnee | Kansas | 20145 | 2117 | 24 |
2393085 | 2393085 | 2022-04-10 | Pawnee | Kansas | 20145 | 2117 | 24 |
2389829 | 2389829 | 2022-04-09 | Pawnee | Kansas | 20145 | 2117 | 24 |
2386573 | 2386573 | 2022-04-08 | Pawnee | Kansas | 20145 | 2117 | 24 |
2383319 | 2383319 | 2022-04-07 | Pawnee | Kansas | 20145 | 2118 | 24 |
2380064 | 2380064 | 2022-04-06 | Pawnee | Kansas | 20145 | 2118 | 24 |
2376809 | 2376809 | 2022-04-05 | Pawnee | Kansas | 20145 | 2118 | 24 |
2373557 | 2373557 | 2022-04-04 | Pawnee | Kansas | 20145 | 2118 | 24 |
2370304 | 2370304 | 2022-04-03 | Pawnee | Kansas | 20145 | 2118 | 24 |
2367051 | 2367051 | 2022-04-02 | Pawnee | Kansas | 20145 | 2118 | 24 |
2363798 | 2363798 | 2022-04-01 | Pawnee | Kansas | 20145 | 2118 | 24 |
2360544 | 2360544 | 2022-03-31 | Pawnee | Kansas | 20145 | 2117 | 24 |
2357290 | 2357290 | 2022-03-30 | Pawnee | Kansas | 20145 | 2117 | 24 |
2354037 | 2354037 | 2022-03-29 | Pawnee | Kansas | 20145 | 2117 | 24 |
2350785 | 2350785 | 2022-03-28 | Pawnee | Kansas | 20145 | 2117 | 24 |
2347532 | 2347532 | 2022-03-27 | Pawnee | Kansas | 20145 | 2117 | 24 |
2344279 | 2344279 | 2022-03-26 | Pawnee | Kansas | 20145 | 2117 | 24 |
2341026 | 2341026 | 2022-03-25 | Pawnee | Kansas | 20145 | 2117 | 24 |
2337773 | 2337773 | 2022-03-24 | Pawnee | Kansas | 20145 | 2117 | 24 |
2334519 | 2334519 | 2022-03-23 | Pawnee | Kansas | 20145 | 2117 | 24 |
2331265 | 2331265 | 2022-03-22 | Pawnee | Kansas | 20145 | 2118 | 24 |
2328013 | 2328013 | 2022-03-21 | Pawnee | Kansas | 20145 | 2118 | 24 |
2324760 | 2324760 | 2022-03-20 | Pawnee | Kansas | 20145 | 2119 | 24 |
2321506 | 2321506 | 2022-03-19 | Pawnee | Kansas | 20145 | 2119 | 24 |
2318252 | 2318252 | 2022-03-18 | Pawnee | Kansas | 20145 | 2119 | 24 |
2314999 | 2314999 | 2022-03-17 | Pawnee | Kansas | 20145 | 2121 | 24 |
2311746 | 2311746 | 2022-03-16 | Pawnee | Kansas | 20145 | 2121 | 24 |
2308493 | 2308493 | 2022-03-15 | Pawnee | Kansas | 20145 | 2120 | 24 |
2305242 | 2305242 | 2022-03-14 | Pawnee | Kansas | 20145 | 2120 | 24 |
2301990 | 2301990 | 2022-03-13 | Pawnee | Kansas | 20145 | 2120 | 24 |
2298738 | 2298738 | 2022-03-12 | Pawnee | Kansas | 20145 | 2120 | 24 |
2295486 | 2295486 | 2022-03-11 | Pawnee | Kansas | 20145 | 2120 | 24 |
2292234 | 2292234 | 2022-03-10 | Pawnee | Kansas | 20145 | 2119 | 23 |
2288982 | 2288982 | 2022-03-09 | Pawnee | Kansas | 20145 | 2119 | 23 |
2285731 | 2285731 | 2022-03-08 | Pawnee | Kansas | 20145 | 2118 | 23 |
2282479 | 2282479 | 2022-03-07 | Pawnee | Kansas | 20145 | 2118 | 23 |
2279226 | 2279226 | 2022-03-06 | Pawnee | Kansas | 20145 | 2118 | 23 |
2275973 | 2275973 | 2022-03-05 | Pawnee | Kansas | 20145 | 2118 | 23 |
2272720 | 2272720 | 2022-03-04 | Pawnee | Kansas | 20145 | 2118 | 23 |
2269468 | 2269468 | 2022-03-03 | Pawnee | Kansas | 20145 | 2115 | 23 |
2266215 | 2266215 | 2022-03-02 | Pawnee | Kansas | 20145 | 2115 | 23 |
2262964 | 2262964 | 2022-03-01 | Pawnee | Kansas | 20145 | 2115 | 23 |
2259713 | 2259713 | 2022-02-28 | Pawnee | Kansas | 20145 | 2115 | 23 |
2256462 | 2256462 | 2022-02-27 | Pawnee | Kansas | 20145 | 2113 | 23 |
2253211 | 2253211 | 2022-02-26 | Pawnee | Kansas | 20145 | 2113 | 23 |
2249960 | 2249960 | 2022-02-25 | Pawnee | Kansas | 20145 | 2113 | 23 |
2246709 | 2246709 | 2022-02-24 | Pawnee | Kansas | 20145 | 2110 | 23 |
2243458 | 2243458 | 2022-02-23 | Pawnee | Kansas | 20145 | 2110 | 23 |
2240207 | 2240207 | 2022-02-22 | Pawnee | Kansas | 20145 | 2106 | 23 |
2236956 | 2236956 | 2022-02-21 | Pawnee | Kansas | 20145 | 2106 | 23 |
2233705 | 2233705 | 2022-02-20 | Pawnee | Kansas | 20145 | 2103 | 23 |
2230454 | 2230454 | 2022-02-19 | Pawnee | Kansas | 20145 | 2103 | 23 |
2227203 | 2227203 | 2022-02-18 | Pawnee | Kansas | 20145 | 2103 | 23 |
2223952 | 2223952 | 2022-02-17 | Pawnee | Kansas | 20145 | 2095 | 23 |
2220701 | 2220701 | 2022-02-16 | Pawnee | Kansas | 20145 | 2095 | 23 |
2217450 | 2217450 | 2022-02-15 | Pawnee | Kansas | 20145 | 2090 | 23 |
2214199 | 2214199 | 2022-02-14 | Pawnee | Kansas | 20145 | 2090 | 23 |
2210947 | 2210947 | 2022-02-13 | Pawnee | Kansas | 20145 | 2068 | 23 |
2207694 | 2207694 | 2022-02-12 | Pawnee | Kansas | 20145 | 2068 | 23 |
2204441 | 2204441 | 2022-02-11 | Pawnee | Kansas | 20145 | 2068 | 23 |
2201188 | 2201188 | 2022-02-10 | Pawnee | Kansas | 20145 | 2068 | 23 |
2197934 | 2197934 | 2022-02-09 | Pawnee | Kansas | 20145 | 2068 | 23 |
2194680 | 2194680 | 2022-02-08 | Pawnee | Kansas | 20145 | 2062 | 23 |
2191426 | 2191426 | 2022-02-07 | Pawnee | Kansas | 20145 | 2062 | 23 |
2188173 | 2188173 | 2022-02-06 | Pawnee | Kansas | 20145 | 2051 | 23 |
2184920 | 2184920 | 2022-02-05 | Pawnee | Kansas | 20145 | 2051 | 23 |
2181668 | 2181668 | 2022-02-04 | Pawnee | Kansas | 20145 | 2051 | 23 |
2178417 | 2178417 | 2022-02-03 | Pawnee | Kansas | 20145 | 2035 | 21 |
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);