ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Collier" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1035 | 1035 | 2020-03-10 | Collier | Florida | 12021 | 3 | 0 |
1204 | 1204 | 2020-03-11 | Collier | Florida | 12021 | 3 | 0 |
1414 | 1414 | 2020-03-12 | Collier | Florida | 12021 | 3 | 0 |
1680 | 1680 | 2020-03-13 | Collier | Florida | 12021 | 3 | 0 |
2002 | 2002 | 2020-03-14 | Collier | Florida | 12021 | 3 | 0 |
2386 | 2386 | 2020-03-15 | Collier | Florida | 12021 | 5 | 0 |
2821 | 2821 | 2020-03-16 | Collier | Florida | 12021 | 6 | 0 |
3305 | 3305 | 2020-03-17 | Collier | Florida | 12021 | 7 | 0 |
3862 | 3862 | 2020-03-18 | Collier | Florida | 12021 | 13 | 0 |
4527 | 4527 | 2020-03-19 | Collier | Florida | 12021 | 18 | 0 |
5306 | 5306 | 2020-03-20 | Collier | Florida | 12021 | 25 | 0 |
6234 | 6234 | 2020-03-21 | Collier | Florida | 12021 | 28 | 0 |
7271 | 7271 | 2020-03-22 | Collier | Florida | 12021 | 33 | 0 |
8417 | 8417 | 2020-03-23 | Collier | Florida | 12021 | 39 | 0 |
9662 | 9662 | 2020-03-24 | Collier | Florida | 12021 | 41 | 0 |
11036 | 11036 | 2020-03-25 | Collier | Florida | 12021 | 57 | 0 |
12584 | 12584 | 2020-03-26 | Collier | Florida | 12021 | 67 | 0 |
14253 | 14253 | 2020-03-27 | Collier | Florida | 12021 | 85 | 0 |
16037 | 16037 | 2020-03-28 | Collier | Florida | 12021 | 95 | 0 |
17929 | 17929 | 2020-03-29 | Collier | Florida | 12021 | 111 | 1 |
19909 | 19909 | 2020-03-30 | Collier | Florida | 12021 | 127 | 1 |
21987 | 21987 | 2020-03-31 | Collier | Florida | 12021 | 146 | 1 |
24146 | 24146 | 2020-04-01 | Collier | Florida | 12021 | 158 | 1 |
26376 | 26376 | 2020-04-02 | Collier | Florida | 12021 | 178 | 2 |
28678 | 28678 | 2020-04-03 | Collier | Florida | 12021 | 203 | 2 |
31036 | 31036 | 2020-04-04 | Collier | Florida | 12021 | 221 | 2 |
33442 | 33442 | 2020-04-05 | Collier | Florida | 12021 | 231 | 2 |
35887 | 35887 | 2020-04-06 | Collier | Florida | 12021 | 249 | 3 |
38377 | 38377 | 2020-04-07 | Collier | Florida | 12021 | 271 | 3 |
40920 | 40920 | 2020-04-08 | Collier | Florida | 12021 | 282 | 3 |
43494 | 43494 | 2020-04-09 | Collier | Florida | 12021 | 303 | 3 |
46095 | 46095 | 2020-04-10 | Collier | Florida | 12021 | 327 | 3 |
48725 | 48725 | 2020-04-11 | Collier | Florida | 12021 | 352 | 4 |
51386 | 51386 | 2020-04-12 | Collier | Florida | 12021 | 361 | 4 |
54066 | 54066 | 2020-04-13 | Collier | Florida | 12021 | 376 | 5 |
56758 | 56758 | 2020-04-14 | Collier | Florida | 12021 | 380 | 5 |
59466 | 59466 | 2020-04-15 | Collier | Florida | 12021 | 396 | 5 |
62185 | 62185 | 2020-04-16 | Collier | Florida | 12021 | 416 | 6 |
64918 | 64918 | 2020-04-17 | Collier | Florida | 12021 | 445 | 8 |
67666 | 67666 | 2020-04-18 | Collier | Florida | 12021 | 457 | 8 |
70428 | 70428 | 2020-04-19 | Collier | Florida | 12021 | 463 | 8 |
73197 | 73197 | 2020-04-20 | Collier | Florida | 12021 | 470 | 9 |
75973 | 75973 | 2020-04-21 | Collier | Florida | 12021 | 477 | 10 |
78757 | 78757 | 2020-04-22 | Collier | Florida | 12021 | 483 | 10 |
81551 | 81551 | 2020-04-23 | Collier | Florida | 12021 | 507 | 14 |
84351 | 84351 | 2020-04-24 | Collier | Florida | 12021 | 526 | 15 |
87159 | 87159 | 2020-04-25 | Collier | Florida | 12021 | 535 | 15 |
89976 | 89976 | 2020-04-26 | Collier | Florida | 12021 | 552 | 15 |
92794 | 92794 | 2020-04-27 | Collier | Florida | 12021 | 562 | 15 |
95626 | 95626 | 2020-04-28 | Collier | Florida | 12021 | 568 | 16 |
98471 | 98471 | 2020-04-29 | Collier | Florida | 12021 | 581 | 17 |
101321 | 101321 | 2020-04-30 | Collier | Florida | 12021 | 596 | 19 |
104176 | 104176 | 2020-05-01 | Collier | Florida | 12021 | 610 | 21 |
107041 | 107041 | 2020-05-02 | Collier | Florida | 12021 | 628 | 21 |
109910 | 109910 | 2020-05-03 | Collier | Florida | 12021 | 640 | 21 |
112785 | 112785 | 2020-05-04 | Collier | Florida | 12021 | 653 | 22 |
115668 | 115668 | 2020-05-05 | Collier | Florida | 12021 | 656 | 25 |
118628 | 118628 | 2020-05-06 | Collier | Florida | 12021 | 677 | 27 |
121597 | 121597 | 2020-05-07 | Collier | Florida | 12021 | 705 | 27 |
124576 | 124576 | 2020-05-08 | Collier | Florida | 12021 | 712 | 27 |
127563 | 127563 | 2020-05-09 | Collier | Florida | 12021 | 734 | 27 |
130554 | 130554 | 2020-05-10 | Collier | Florida | 12021 | 752 | 27 |
133545 | 133545 | 2020-05-11 | Collier | Florida | 12021 | 766 | 28 |
136534 | 136534 | 2020-05-12 | Collier | Florida | 12021 | 843 | 32 |
139525 | 139525 | 2020-05-13 | Collier | Florida | 12021 | 864 | 34 |
142521 | 142521 | 2020-05-14 | Collier | Florida | 12021 | 882 | 35 |
145521 | 145521 | 2020-05-15 | Collier | Florida | 12021 | 915 | 37 |
148524 | 148524 | 2020-05-16 | Collier | Florida | 12021 | 923 | 37 |
151533 | 151533 | 2020-05-17 | Collier | Florida | 12021 | 948 | 37 |
154545 | 154545 | 2020-05-18 | Collier | Florida | 12021 | 1006 | 37 |
157561 | 157561 | 2020-05-19 | Collier | Florida | 12021 | 1030 | 40 |
160587 | 160587 | 2020-05-20 | Collier | Florida | 12021 | 1058 | 40 |
163615 | 163615 | 2020-05-21 | Collier | Florida | 12021 | 1112 | 41 |
166648 | 166648 | 2020-05-22 | Collier | Florida | 12021 | 1160 | 42 |
169685 | 169685 | 2020-05-23 | Collier | Florida | 12021 | 1195 | 45 |
172726 | 172726 | 2020-05-24 | Collier | Florida | 12021 | 1251 | 45 |
175769 | 175769 | 2020-05-25 | Collier | Florida | 12021 | 1282 | 46 |
178813 | 178813 | 2020-05-26 | Collier | Florida | 12021 | 1305 | 46 |
181857 | 181857 | 2020-05-27 | Collier | Florida | 12021 | 1334 | 46 |
184911 | 184911 | 2020-05-28 | Collier | Florida | 12021 | 1401 | 49 |
187967 | 187967 | 2020-05-29 | Collier | Florida | 12021 | 1454 | 49 |
191032 | 191032 | 2020-05-30 | Collier | Florida | 12021 | 1514 | 49 |
194099 | 194099 | 2020-05-31 | Collier | Florida | 12021 | 1539 | 49 |
197169 | 197169 | 2020-06-01 | Collier | Florida | 12021 | 1580 | 49 |
200242 | 200242 | 2020-06-02 | Collier | Florida | 12021 | 1605 | 49 |
203318 | 203318 | 2020-06-03 | Collier | Florida | 12021 | 1679 | 49 |
206398 | 206398 | 2020-06-04 | Collier | Florida | 12021 | 1814 | 53 |
209479 | 209479 | 2020-06-05 | Collier | Florida | 12021 | 1874 | 55 |
212564 | 212564 | 2020-06-06 | Collier | Florida | 12021 | 1968 | 56 |
215651 | 215651 | 2020-06-07 | Collier | Florida | 12021 | 2039 | 56 |
218742 | 218742 | 2020-06-08 | Collier | Florida | 12021 | 2070 | 57 |
221837 | 221837 | 2020-06-09 | Collier | Florida | 12021 | 2128 | 57 |
224932 | 224932 | 2020-06-10 | Collier | Florida | 12021 | 2230 | 57 |
228034 | 228034 | 2020-06-11 | Collier | Florida | 12021 | 2291 | 59 |
231137 | 231137 | 2020-06-12 | Collier | Florida | 12021 | 2364 | 59 |
234243 | 234243 | 2020-06-13 | Collier | Florida | 12021 | 2435 | 60 |
237350 | 237350 | 2020-06-14 | Collier | Florida | 12021 | 2526 | 60 |
240458 | 240458 | 2020-06-15 | Collier | Florida | 12021 | 2592 | 60 |
243569 | 243569 | 2020-06-16 | Collier | Florida | 12021 | 2729 | 60 |
246682 | 246682 | 2020-06-17 | Collier | Florida | 12021 | 2817 | 60 |
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);