ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,517 rows where county = "Lucas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 308 ✖
- 23 172
- 6 101
- 32 66
- 4 59
- 29 49
- 24 42
- 21 37
- 28 24
- 22 23
- 31 22
- 0 20
- 3 20
- 8 20
- 5 15
- 7 14
- 2 13
- 370 12
- 752 11
- 829 11
- 1 8
- 25 8
- 364 8
- 26 7
- 27 7
- 306 7
- 350 7
- 776 7
- 788 7
- 793 7
- 830 7
- 834 7
- 837 7
- 839 7
- 1307 7
- 1381 7
- 1392 7
- 1401 7
- 1408 7
- 1413 7
- 1415 7
- 1416 7
- 1417 7
- 10 6
- 12 6
- 18 6
- 299 6
- 302 6
- 369 6
- 742 6
- 757 6
- 1375 6
- 16 5
- 341 5
- 348 5
- 541 5
- 765 5
- 804 5
- 17 4
- 378 4
- 685 4
- 690 4
- 720 4
- 738 4
- 751 4
- 781 4
- 792 4
- 810 4
- 817 4
- 820 4
- 826 4
- 832 4
- 836 4
- 841 4
- 848 4
- 851 4
- 862 4
- 869 4
- 877 4
- 886 4
- 904 4
- 917 4
- 936 4
- 966 4
- 992 4
- 1005 4
- 1017 4
- 1027 4
- 1044 4
- 1058 4
- 1068 4
- 1087 4
- 1130 4
- 1149 4
- 1193 4
- 1207 4
- 1219 4
- 1304 4
- 1340 4
- 1357 4
- 119 3
- 229 3
- 294 3
- 307 3
- 311 3
- 323 3
- 329 3
- 338 3
- 356 3
- 357 3
- 373 3
- 375 3
- 393 3
- 449 3
- 535 3
- 554 3
- 726 3
- 740 3
- 743 3
- 760 3
- 768 3
- 782 3
- 794 3
- 813 3
- 818 3
- 824 3
- 827 3
- 831 3
- 835 3
- 838 3
- 844 3
- 849 3
- 853 3
- 863 3
- 872 3
- 883 3
- 894 3
- 912 3
- 923 3
- 948 3
- 976 3
- 997 3
- 1011 3
- 1020 3
- 1030 3
- 1045 3
- 1059 3
- 1069 3
- 1114 3
- 1137 3
- 1160 3
- 1197 3
- 1218 3
- 1283 3
- 1335 3
- 1356 3
- 1366 3
- 9 2
- 11 2
- 19 2
- 20 2
- 33 2
- 59 2
- 164 2
- 204 2
- 240 2
- 242 2
- 263 2
- 265 2
- 272 2
- 280 2
- 303 2
- 305 2
- 312 2
- 313 2
- 318 2
- 320 2
- 324 2
- 326 2
- 343 2
- 376 2
- 388 2
- 389 2
- 392 2
- 394 2
- 398 2
- 404 2
- 406 2
- 417 2
- 420 2
- 426 2
- 478 2
- 495 2
- 504 2
- 536 2
- 553 2
- 597 2
- 625 2
- 669 2
- 745 2
- 753 2
- 761 2
- 805 2
- 1420 2
- 36 1
- 44 1
- 55 1
- 58 1
- 61 1
- 66 1
- 114 1
- 117 1
- 120 1
- 133 1
- 151 1
- 155 1
- 161 1
- 165 1
- 179 1
- 187 1
- 195 1
- 203 1
- 207 1
- 209 1
- 214 1
- 218 1
- 219 1
- 228 1
- 233 1
- 248 1
- 252 1
- 256 1
- 266 1
- 267 1
- 270 1
- 282 1
- 286 1
- 289 1
- 291 1
- 293 1
- 298 1
- 301 1
- 304 1
- 308 1
- 310 1
- 314 1
- 316 1
- 319 1
- 321 1
- 331 1
- 332 1
- 333 1
- 337 1
- 339 1
- 342 1
- 355 1
- 358 1
- 361 1
- 367 1
- 399 1
- 400 1
- 403 1
- 405 1
- 409 1
- 414 1
- 431 1
- 436 1
- 438 1
- 446 1
- 458 1
- 459 1
- 465 1
- 474 1
- 483 1
- 489 1
- 502 1
- 505 1
- 513 1
- 531 1
- 540 1
- 544 1
- 555 1
- 559 1
- 565 1
- 567 1
- 575 1
- 580 1
- 591 1
- 605 1
- 609 1
- 611 1
- 616 1
- 631 1
- 634 1
- 647 1
- 648 1
- 654 1
- 667 1
- 675 1
- 682 1
- 692 1
- 695 1
- 709 1
- 732 1
- 747 1
- 748 1
- 749 1
- 755 1
- 767 1
county 1
- Lucas · 1,517 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2605 | 2605 | 2020-03-15 | Lucas | Ohio | 39095 | 1 | 0 |
3068 | 3068 | 2020-03-16 | Lucas | Ohio | 39095 | 1 | 0 |
3594 | 3594 | 2020-03-17 | Lucas | Ohio | 39095 | 1 | 0 |
4208 | 4208 | 2020-03-18 | Lucas | Ohio | 39095 | 1 | 0 |
4940 | 4940 | 2020-03-19 | Lucas | Ohio | 39095 | 1 | 0 |
5803 | 5803 | 2020-03-20 | Lucas | Ohio | 39095 | 2 | 1 |
6804 | 6804 | 2020-03-21 | Lucas | Ohio | 39095 | 4 | 1 |
7915 | 7915 | 2020-03-22 | Lucas | Ohio | 39095 | 5 | 1 |
9120 | 9120 | 2020-03-23 | Lucas | Ohio | 39095 | 9 | 1 |
10436 | 10436 | 2020-03-24 | Lucas | Ohio | 39095 | 11 | 1 |
11885 | 11885 | 2020-03-25 | Lucas | Ohio | 39095 | 23 | 2 |
13493 | 13493 | 2020-03-26 | Lucas | Ohio | 39095 | 35 | 2 |
15231 | 15231 | 2020-03-27 | Lucas | Ohio | 39095 | 50 | 2 |
17073 | 17073 | 2020-03-28 | Lucas | Ohio | 39095 | 67 | 2 |
19007 | 19007 | 2020-03-29 | Lucas | Ohio | 39095 | 94 | 2 |
21052 | 21052 | 2020-03-30 | Lucas | Ohio | 39095 | 114 | 3 |
23184 | 23184 | 2020-03-31 | Lucas | Ohio | 39095 | 133 | 3 |
25379 | 25379 | 2020-04-01 | Lucas | Ohio | 39095 | 171 | 3 |
27647 | 27647 | 2020-04-02 | Lucas | Ohio | 39095 | 206 | 3 |
29976 | 29976 | 2020-04-03 | Lucas | Ohio | 39095 | 233 | 4 |
32365 | 32365 | 2020-04-04 | Lucas | Ohio | 39095 | 272 | 7 |
34798 | 34798 | 2020-04-05 | Lucas | Ohio | 39095 | 302 | 8 |
37267 | 37267 | 2020-04-06 | Lucas | Ohio | 39095 | 321 | 12 |
39784 | 39784 | 2020-04-07 | Lucas | Ohio | 39095 | 347 | 16 |
42344 | 42344 | 2020-04-08 | Lucas | Ohio | 39095 | 371 | 16 |
44929 | 44929 | 2020-04-09 | Lucas | Ohio | 39095 | 403 | 16 |
47544 | 47544 | 2020-04-10 | Lucas | Ohio | 39095 | 443 | 20 |
50200 | 50200 | 2020-04-11 | Lucas | Ohio | 39095 | 490 | 21 |
52873 | 52873 | 2020-04-12 | Lucas | Ohio | 39095 | 503 | 21 |
55557 | 55557 | 2020-04-13 | Lucas | Ohio | 39095 | 514 | 21 |
58258 | 58258 | 2020-04-14 | Lucas | Ohio | 39095 | 540 | 25 |
60973 | 60973 | 2020-04-15 | Lucas | Ohio | 39095 | 596 | 28 |
63699 | 63699 | 2020-04-16 | Lucas | Ohio | 39095 | 644 | 28 |
66442 | 66442 | 2020-04-17 | Lucas | Ohio | 39095 | 682 | 28 |
69199 | 69199 | 2020-04-18 | Lucas | Ohio | 39095 | 724 | 31 |
71966 | 71966 | 2020-04-19 | Lucas | Ohio | 39095 | 789 | 33 |
74741 | 74741 | 2020-04-20 | Lucas | Ohio | 39095 | 823 | 33 |
77522 | 77522 | 2020-04-21 | Lucas | Ohio | 39095 | 853 | 36 |
80312 | 80312 | 2020-04-22 | Lucas | Ohio | 39095 | 878 | 44 |
83111 | 83111 | 2020-04-23 | Lucas | Ohio | 39095 | 936 | 55 |
85915 | 85915 | 2020-04-24 | Lucas | Ohio | 39095 | 985 | 58 |
88729 | 88729 | 2020-04-25 | Lucas | Ohio | 39095 | 1033 | 59 |
91545 | 91545 | 2020-04-26 | Lucas | Ohio | 39095 | 1104 | 59 |
94371 | 94371 | 2020-04-27 | Lucas | Ohio | 39095 | 1130 | 61 |
97208 | 97208 | 2020-04-28 | Lucas | Ohio | 39095 | 1166 | 66 |
100057 | 100057 | 2020-04-29 | Lucas | Ohio | 39095 | 1208 | 114 |
102910 | 102910 | 2020-04-30 | Lucas | Ohio | 39095 | 1251 | 117 |
105773 | 105773 | 2020-05-01 | Lucas | Ohio | 39095 | 1297 | 119 |
108640 | 108640 | 2020-05-02 | Lucas | Ohio | 39095 | 1331 | 119 |
111514 | 111514 | 2020-05-03 | Lucas | Ohio | 39095 | 1376 | 119 |
114395 | 114395 | 2020-05-04 | Lucas | Ohio | 39095 | 1429 | 120 |
117276 | 117276 | 2020-05-05 | Lucas | Ohio | 39095 | 1478 | 133 |
120237 | 120237 | 2020-05-06 | Lucas | Ohio | 39095 | 1527 | 151 |
123214 | 123214 | 2020-05-07 | Lucas | Ohio | 39095 | 1583 | 155 |
126197 | 126197 | 2020-05-08 | Lucas | Ohio | 39095 | 1665 | 161 |
129186 | 129186 | 2020-05-09 | Lucas | Ohio | 39095 | 1710 | 164 |
132175 | 132175 | 2020-05-10 | Lucas | Ohio | 39095 | 1757 | 164 |
135166 | 135166 | 2020-05-11 | Lucas | Ohio | 39095 | 1806 | 165 |
138156 | 138156 | 2020-05-12 | Lucas | Ohio | 39095 | 1836 | 179 |
141152 | 141152 | 2020-05-13 | Lucas | Ohio | 39095 | 1858 | 187 |
144147 | 144147 | 2020-05-14 | Lucas | Ohio | 39095 | 1883 | 195 |
147148 | 147148 | 2020-05-15 | Lucas | Ohio | 39095 | 1921 | 204 |
150155 | 150155 | 2020-05-16 | Lucas | Ohio | 39095 | 1945 | 203 |
152038 | 152038 | 2020-05-17 | Lucas | Iowa | 19117 | 1 | 0 |
153166 | 153166 | 2020-05-17 | Lucas | Ohio | 39095 | 1960 | 204 |
155050 | 155050 | 2020-05-18 | Lucas | Iowa | 19117 | 1 | 0 |
156183 | 156183 | 2020-05-18 | Lucas | Ohio | 39095 | 1986 | 207 |
158066 | 158066 | 2020-05-19 | Lucas | Iowa | 19117 | 2 | 0 |
159203 | 159203 | 2020-05-19 | Lucas | Ohio | 39095 | 1999 | 209 |
161092 | 161092 | 2020-05-20 | Lucas | Iowa | 19117 | 3 | 0 |
162230 | 162230 | 2020-05-20 | Lucas | Ohio | 39095 | 2021 | 214 |
164120 | 164120 | 2020-05-21 | Lucas | Iowa | 19117 | 3 | 0 |
165259 | 165259 | 2020-05-21 | Lucas | Ohio | 39095 | 2056 | 219 |
167153 | 167153 | 2020-05-22 | Lucas | Iowa | 19117 | 4 | 0 |
168295 | 168295 | 2020-05-22 | Lucas | Ohio | 39095 | 2071 | 218 |
170190 | 170190 | 2020-05-23 | Lucas | Iowa | 19117 | 4 | 0 |
171334 | 171334 | 2020-05-23 | Lucas | Ohio | 39095 | 2087 | 228 |
173231 | 173231 | 2020-05-24 | Lucas | Iowa | 19117 | 6 | 0 |
174376 | 174376 | 2020-05-24 | Lucas | Ohio | 39095 | 2107 | 229 |
176275 | 176275 | 2020-05-25 | Lucas | Iowa | 19117 | 6 | 0 |
177420 | 177420 | 2020-05-25 | Lucas | Ohio | 39095 | 2126 | 229 |
179319 | 179319 | 2020-05-26 | Lucas | Iowa | 19117 | 7 | 0 |
180463 | 180463 | 2020-05-26 | Lucas | Ohio | 39095 | 2152 | 229 |
182364 | 182364 | 2020-05-27 | Lucas | Iowa | 19117 | 8 | 0 |
183512 | 183512 | 2020-05-27 | Lucas | Ohio | 39095 | 2162 | 233 |
185418 | 185418 | 2020-05-28 | Lucas | Iowa | 19117 | 12 | 0 |
186569 | 186569 | 2020-05-28 | Lucas | Ohio | 39095 | 2178 | 240 |
188476 | 188476 | 2020-05-29 | Lucas | Iowa | 19117 | 16 | 0 |
189629 | 189629 | 2020-05-29 | Lucas | Ohio | 39095 | 2202 | 240 |
191541 | 191541 | 2020-05-30 | Lucas | Iowa | 19117 | 17 | 0 |
192693 | 192693 | 2020-05-30 | Lucas | Ohio | 39095 | 2241 | 242 |
194608 | 194608 | 2020-05-31 | Lucas | Iowa | 19117 | 17 | 0 |
195763 | 195763 | 2020-05-31 | Lucas | Ohio | 39095 | 2267 | 242 |
197678 | 197678 | 2020-06-01 | Lucas | Iowa | 19117 | 17 | 1 |
198836 | 198836 | 2020-06-01 | Lucas | Ohio | 39095 | 2277 | 248 |
200751 | 200751 | 2020-06-02 | Lucas | Iowa | 19117 | 19 | 1 |
201911 | 201911 | 2020-06-02 | Lucas | Ohio | 39095 | 2282 | 252 |
203827 | 203827 | 2020-06-03 | Lucas | Iowa | 19117 | 19 | 1 |
204988 | 204988 | 2020-06-03 | Lucas | Ohio | 39095 | 2296 | 256 |
206907 | 206907 | 2020-06-04 | Lucas | Iowa | 19117 | 22 | 2 |
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);