ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Canadian" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 394 ✖
- 16254 9
- 38719 8
- 2 7
- 16337 7
- 16434 7
- 16513 7
- 16832 7
- 16909 7
- 17046 7
- 17127 7
- 17220 7
- 17284 7
- 17335 7
- 17370 7
- 17392 7
- 17415 7
- 17434 7
- 17461 7
- 17478 7
- 17530 7
- 17627 7
- 17762 7
- 18115 7
- 18582 7
- 19148 7
- 19664 7
- 20204 7
- 20768 7
- 21209 7
- 21595 7
- 21936 7
- 22226 7
- 22572 7
- 22956 7
- 23177 7
- 23345 7
- 23538 7
- 23744 7
- 23915 7
- 24129 7
- 24485 7
- 24799 7
- 25092 7
- 25428 7
- 26560 7
- 28798 7
- 32699 7
- 35570 7
- 37338 7
- 37939 7
- 38287 7
- 38506 7
- 38944 7
- 39029 7
- 39163 7
- 39259 7
- 39383 7
- 39499 7
- 39614 7
- 39719 7
- 39776 7
- 128 4
- 133 4
- 98 3
- 116 3
- 11 2
- 40 2
- 56 2
- 91 2
- 103 2
- 107 2
- 111 2
- 120 2
- 141 2
- 142 2
- 144 2
- 4692 2
- 6515 2
- 10015 2
- 10582 2
- 39889 2
- 1 1
- 4 1
- 5 1
- 6 1
- 12 1
- 15 1
- 19 1
- 24 1
- 28 1
- 29 1
- 32 1
- 33 1
- 35 1
- 48 1
- 52 1
- 57 1
- 62 1
- 63 1
- 65 1
- 69 1
- 72 1
- 73 1
- 75 1
- 76 1
- 82 1
- 86 1
- 88 1
- 90 1
- 96 1
- 97 1
- 100 1
- 102 1
- 110 1
- 114 1
- 115 1
- 117 1
- 118 1
- 122 1
- 123 1
- 124 1
- 126 1
- 129 1
- 132 1
- 137 1
- 143 1
- 146 1
- 148 1
- 150 1
- 156 1
- 160 1
- 167 1
- 175 1
- 186 1
- 192 1
- 197 1
- 200 1
- 207 1
- 218 1
- 227 1
- 238 1
- 249 1
- 258 1
- 266 1
- 280 1
- 289 1
- 293 1
- 307 1
- 325 1
- 337 1
- 360 1
- 387 1
- 409 1
- 430 1
- 456 1
- 479 1
- 502 1
- 519 1
- 543 1
- 594 1
- 608 1
- 631 1
- 652 1
- 667 1
- 674 1
- 686 1
- 717 1
- 744 1
- 786 1
- 795 1
- 830 1
- 877 1
- 913 1
- 941 1
- 988 1
- 1009 1
- 1059 1
- 1078 1
- 1089 1
- 1106 1
- 1128 1
- 1152 1
- 1174 1
- 1194 1
- 1208 1
- 1224 1
- 1238 1
- 1256 1
- 1275 1
- 1298 1
- 1314 1
- 1331 1
- 1339 1
- 1343 1
- 1347 1
- 1361 1
- 1393 1
- 1409 1
- 1413 1
- 1420 1
- 1433 1
- 1455 1
- 1488 1
- 1502 1
- 1509 1
- 1518 1
- 1541 1
- 1547 1
- 1556 1
- 1568 1
- 1599 1
- 1615 1
- 1626 1
- 1634 1
- 1644 1
- 1664 1
- 1678 1
- 1695 1
- 1716 1
- 1736 1
- 1752 1
- 1783 1
- 1798 1
- 1827 1
- 1896 1
- 1928 1
- 1951 1
- 1998 1
- 2044 1
- 2087 1
- 2122 1
- 2178 1
- 2210 1
- 2267 1
- 2325 1
- 2360 1
- 2379 1
- 2415 1
- 2461 1
- 2499 1
- 2519 1
- 2558 1
- 2594 1
- 2648 1
- 2716 1
- 2764 1
- 2828 1
- 2870 1
- 2898 1
- 2957 1
- 3012 1
- 3073 1
- 3227 1
- 3324 1
- 3350 1
- 3386 1
- 3469 1
- 3607 1
- 3674 1
- 3754 1
- 3813 1
- 3846 1
- 3896 1
- 3987 1
- 4009 1
- 4070 1
- 4112 1
- 4163 1
- 4208 1
- 4232 1
- 4289 1
- 4334 1
- 4411 1
- 4478 1
- 4768 1
- 4807 1
- 4883 1
- 4967 1
- 5095 1
- 5230 1
- 5443 1
- 5534 1
- 5582 1
- 5721 1
- 5834 1
- 5913 1
- 6081 1
- 6221 1
- 6313 1
- 6417 1
- 6665 1
- 6890 1
- 6953 1
- 7002 1
- 7075 1
- 7258 1
- 7320 1
- 7479 1
- 7668 1
- 7811 1
- 7864 1
- 7960 1
- 8105 1
- 8162 1
- 8305 1
- 8484 1
- 8643 1
- 8731 1
- 8859 1
- 9016 1
- 9153 1
- 9272 1
- 9422 1
- 9550 1
- 9648 1
- 9737 1
- 9842 1
- 10150 1
- 10225 1
- 10351 1
- 10404 1
- 10486 1
- 10984 1
- 11246 1
- 11400 1
- 11448 1
- 11585 1
- 11752 1
- 11996 1
- 12127 1
- 12333 1
- 12437 1
- 12524 1
- 12709 1
- 12814 1
- 12900 1
- 13045 1
- 13134 1
- 13206 1
- 13242 1
- 13313 1
- 13384 1
- 13483 1
- 13725 1
- 13840 1
- 13881 1
- 13921 1
- 13978 1
- 14047 1
- 14152 1
- 14204 1
- 14290 1
- 14349 1
- 14387 1
- 14471 1
- 14571 1
- 14724 1
- 14835 1
- 14951 1
- 15004 1
- 15056 1
- 15157 1
- 15192 1
- 15235 1
- 15289 1
- 15322 1
- 15377 1
- 15400 1
- 15447 1
- 15452 1
- 15469 1
- 15490 1
- 15551 1
- 15575 1
- 15595 1
- 15658 1
- 15675 1
- 15717 1
- 15759 1
- 15843 1
- 15884 1
- 15885 1
- 15965 1
- 16007 1
- 16026 1
- 16062 1
- 16089 1
- 16096 1
- 16100 1
- 16157 1
- 16190 1
- 16211 1
- 16235 1
- 16246 1
state 1
- Oklahoma 789
fips 1
- 40017 789
county 1
- Canadian · 789 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501741 | 2501741 | 2022-05-13 | Canadian | Oklahoma | 40017 | 39889 | 390 |
2498483 | 2498483 | 2022-05-12 | Canadian | Oklahoma | 40017 | 39889 | 390 |
2495225 | 2495225 | 2022-05-11 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2491967 | 2491967 | 2022-05-10 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2488709 | 2488709 | 2022-05-09 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2485452 | 2485452 | 2022-05-08 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2482194 | 2482194 | 2022-05-07 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2478936 | 2478936 | 2022-05-06 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2475678 | 2475678 | 2022-05-05 | Canadian | Oklahoma | 40017 | 39776 | 390 |
2472421 | 2472421 | 2022-05-04 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2469165 | 2469165 | 2022-05-03 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2465909 | 2465909 | 2022-05-02 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2462654 | 2462654 | 2022-05-01 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2459398 | 2459398 | 2022-04-30 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2456142 | 2456142 | 2022-04-29 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2452886 | 2452886 | 2022-04-28 | Canadian | Oklahoma | 40017 | 39719 | 388 |
2449630 | 2449630 | 2022-04-27 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2446373 | 2446373 | 2022-04-26 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2443118 | 2443118 | 2022-04-25 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2439862 | 2439862 | 2022-04-24 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2436606 | 2436606 | 2022-04-23 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2433350 | 2433350 | 2022-04-22 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2430094 | 2430094 | 2022-04-21 | Canadian | Oklahoma | 40017 | 39614 | 386 |
2426838 | 2426838 | 2022-04-20 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2423582 | 2423582 | 2022-04-19 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2420325 | 2420325 | 2022-04-18 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2417070 | 2417070 | 2022-04-17 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2413814 | 2413814 | 2022-04-16 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2410558 | 2410558 | 2022-04-15 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2407302 | 2407302 | 2022-04-14 | Canadian | Oklahoma | 40017 | 39499 | 386 |
2404046 | 2404046 | 2022-04-13 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2400791 | 2400791 | 2022-04-12 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2397536 | 2397536 | 2022-04-11 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2394281 | 2394281 | 2022-04-10 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2391025 | 2391025 | 2022-04-09 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2387769 | 2387769 | 2022-04-08 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2384514 | 2384514 | 2022-04-07 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2381259 | 2381259 | 2022-04-06 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2378004 | 2378004 | 2022-04-05 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2374750 | 2374750 | 2022-04-04 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2371498 | 2371498 | 2022-04-03 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2368245 | 2368245 | 2022-04-02 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2364992 | 2364992 | 2022-04-01 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2361739 | 2361739 | 2022-03-31 | Canadian | Oklahoma | 40017 | 39259 | 382 |
2358485 | 2358485 | 2022-03-30 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2355231 | 2355231 | 2022-03-29 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2351978 | 2351978 | 2022-03-28 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2348726 | 2348726 | 2022-03-27 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2345473 | 2345473 | 2022-03-26 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2342220 | 2342220 | 2022-03-25 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2338967 | 2338967 | 2022-03-24 | Canadian | Oklahoma | 40017 | 39163 | 381 |
2335713 | 2335713 | 2022-03-23 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2332459 | 2332459 | 2022-03-22 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2329206 | 2329206 | 2022-03-21 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2325954 | 2325954 | 2022-03-20 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2322701 | 2322701 | 2022-03-19 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2319447 | 2319447 | 2022-03-18 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2316193 | 2316193 | 2022-03-17 | Canadian | Oklahoma | 40017 | 39029 | 374 |
2312940 | 2312940 | 2022-03-16 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2309687 | 2309687 | 2022-03-15 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2306434 | 2306434 | 2022-03-14 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2303183 | 2303183 | 2022-03-13 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2299931 | 2299931 | 2022-03-12 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2296679 | 2296679 | 2022-03-11 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2293427 | 2293427 | 2022-03-10 | Canadian | Oklahoma | 40017 | 38944 | 371 |
2290175 | 2290175 | 2022-03-09 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2286923 | 2286923 | 2022-03-08 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2283671 | 2283671 | 2022-03-07 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2280419 | 2280419 | 2022-03-06 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2277166 | 2277166 | 2022-03-05 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2273913 | 2273913 | 2022-03-04 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2270660 | 2270660 | 2022-03-03 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2267408 | 2267408 | 2022-03-02 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2264155 | 2264155 | 2022-03-01 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2260905 | 2260905 | 2022-02-28 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2257654 | 2257654 | 2022-02-27 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2254403 | 2254403 | 2022-02-26 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2251152 | 2251152 | 2022-02-25 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2247901 | 2247901 | 2022-02-24 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2244650 | 2244650 | 2022-02-23 | Canadian | Oklahoma | 40017 | 38506 | 358 |
2241399 | 2241399 | 2022-02-22 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2238148 | 2238148 | 2022-02-21 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2234897 | 2234897 | 2022-02-20 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2231646 | 2231646 | 2022-02-19 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2228395 | 2228395 | 2022-02-18 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2225144 | 2225144 | 2022-02-17 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2221893 | 2221893 | 2022-02-16 | Canadian | Oklahoma | 40017 | 38287 | 352 |
2218642 | 2218642 | 2022-02-15 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2215391 | 2215391 | 2022-02-14 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2212140 | 2212140 | 2022-02-13 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2208887 | 2208887 | 2022-02-12 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2205634 | 2205634 | 2022-02-11 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2202381 | 2202381 | 2022-02-10 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2199127 | 2199127 | 2022-02-09 | Canadian | Oklahoma | 40017 | 37939 | 346 |
2195873 | 2195873 | 2022-02-08 | Canadian | Oklahoma | 40017 | 37338 | 331 |
2192619 | 2192619 | 2022-02-07 | Canadian | Oklahoma | 40017 | 37338 | 331 |
2189365 | 2189365 | 2022-02-06 | Canadian | Oklahoma | 40017 | 37338 | 331 |
2186112 | 2186112 | 2022-02-05 | Canadian | Oklahoma | 40017 | 37338 | 331 |
2182860 | 2182860 | 2022-02-04 | Canadian | Oklahoma | 40017 | 37338 | 331 |
2179608 | 2179608 | 2022-02-03 | Canadian | Oklahoma | 40017 | 37338 | 331 |
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);