ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Pinellas" and state = "Florida" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1042 | 1042 | 2020-03-10 | Pinellas | Florida | 12103 | 2 | 0 |
1212 | 1212 | 2020-03-11 | Pinellas | Florida | 12103 | 2 | 0 |
1424 | 1424 | 2020-03-12 | Pinellas | Florida | 12103 | 2 | 0 |
1692 | 1692 | 2020-03-13 | Pinellas | Florida | 12103 | 2 | 0 |
2014 | 2014 | 2020-03-14 | Pinellas | Florida | 12103 | 2 | 0 |
2398 | 2398 | 2020-03-15 | Pinellas | Florida | 12103 | 2 | 0 |
2835 | 2835 | 2020-03-16 | Pinellas | Florida | 12103 | 4 | 0 |
3319 | 3319 | 2020-03-17 | Pinellas | Florida | 12103 | 4 | 0 |
3877 | 3877 | 2020-03-18 | Pinellas | Florida | 12103 | 12 | 0 |
4546 | 4546 | 2020-03-19 | Pinellas | Florida | 12103 | 16 | 0 |
5326 | 5326 | 2020-03-20 | Pinellas | Florida | 12103 | 22 | 0 |
6256 | 6256 | 2020-03-21 | Pinellas | Florida | 12103 | 29 | 0 |
7296 | 7296 | 2020-03-22 | Pinellas | Florida | 12103 | 38 | 0 |
8442 | 8442 | 2020-03-23 | Pinellas | Florida | 12103 | 41 | 0 |
9687 | 9687 | 2020-03-24 | Pinellas | Florida | 12103 | 45 | 1 |
11062 | 11062 | 2020-03-25 | Pinellas | Florida | 12103 | 54 | 1 |
12610 | 12610 | 2020-03-26 | Pinellas | Florida | 12103 | 65 | 1 |
14280 | 14280 | 2020-03-27 | Pinellas | Florida | 12103 | 82 | 1 |
16065 | 16065 | 2020-03-28 | Pinellas | Florida | 12103 | 111 | 4 |
17958 | 17958 | 2020-03-29 | Pinellas | Florida | 12103 | 116 | 5 |
19939 | 19939 | 2020-03-30 | Pinellas | Florida | 12103 | 129 | 5 |
22017 | 22017 | 2020-03-31 | Pinellas | Florida | 12103 | 167 | 5 |
24180 | 24180 | 2020-04-01 | Pinellas | Florida | 12103 | 233 | 5 |
26410 | 26410 | 2020-04-02 | Pinellas | Florida | 12103 | 273 | 6 |
28713 | 28713 | 2020-04-03 | Pinellas | Florida | 12103 | 318 | 7 |
31073 | 31073 | 2020-04-04 | Pinellas | Florida | 12103 | 342 | 7 |
33479 | 33479 | 2020-04-05 | Pinellas | Florida | 12103 | 359 | 8 |
35925 | 35925 | 2020-04-06 | Pinellas | Florida | 12103 | 372 | 8 |
38416 | 38416 | 2020-04-07 | Pinellas | Florida | 12103 | 387 | 9 |
40960 | 40960 | 2020-04-08 | Pinellas | Florida | 12103 | 395 | 10 |
43534 | 43534 | 2020-04-09 | Pinellas | Florida | 12103 | 422 | 10 |
46136 | 46136 | 2020-04-10 | Pinellas | Florida | 12103 | 431 | 12 |
48766 | 48766 | 2020-04-11 | Pinellas | Florida | 12103 | 446 | 12 |
51427 | 51427 | 2020-04-12 | Pinellas | Florida | 12103 | 455 | 13 |
54107 | 54107 | 2020-04-13 | Pinellas | Florida | 12103 | 479 | 13 |
56799 | 56799 | 2020-04-14 | Pinellas | Florida | 12103 | 494 | 14 |
59507 | 59507 | 2020-04-15 | Pinellas | Florida | 12103 | 513 | 14 |
62226 | 62226 | 2020-04-16 | Pinellas | Florida | 12103 | 530 | 14 |
64959 | 64959 | 2020-04-17 | Pinellas | Florida | 12103 | 565 | 16 |
67707 | 67707 | 2020-04-18 | Pinellas | Florida | 12103 | 587 | 16 |
70469 | 70469 | 2020-04-19 | Pinellas | Florida | 12103 | 592 | 16 |
73238 | 73238 | 2020-04-20 | Pinellas | Florida | 12103 | 607 | 16 |
76014 | 76014 | 2020-04-21 | Pinellas | Florida | 12103 | 632 | 18 |
78798 | 78798 | 2020-04-22 | Pinellas | Florida | 12103 | 638 | 19 |
81592 | 81592 | 2020-04-23 | Pinellas | Florida | 12103 | 656 | 23 |
84392 | 84392 | 2020-04-24 | Pinellas | Florida | 12103 | 673 | 24 |
87200 | 87200 | 2020-04-25 | Pinellas | Florida | 12103 | 677 | 24 |
90017 | 90017 | 2020-04-26 | Pinellas | Florida | 12103 | 687 | 24 |
92835 | 92835 | 2020-04-27 | Pinellas | Florida | 12103 | 698 | 25 |
95667 | 95667 | 2020-04-28 | Pinellas | Florida | 12103 | 709 | 31 |
98512 | 98512 | 2020-04-29 | Pinellas | Florida | 12103 | 718 | 34 |
101362 | 101362 | 2020-04-30 | Pinellas | Florida | 12103 | 729 | 37 |
104217 | 104217 | 2020-05-01 | Pinellas | Florida | 12103 | 748 | 38 |
107082 | 107082 | 2020-05-02 | Pinellas | Florida | 12103 | 757 | 41 |
109951 | 109951 | 2020-05-03 | Pinellas | Florida | 12103 | 766 | 41 |
112826 | 112826 | 2020-05-04 | Pinellas | Florida | 12103 | 784 | 42 |
115709 | 115709 | 2020-05-05 | Pinellas | Florida | 12103 | 788 | 44 |
118669 | 118669 | 2020-05-06 | Pinellas | Florida | 12103 | 801 | 50 |
121638 | 121638 | 2020-05-07 | Pinellas | Florida | 12103 | 820 | 56 |
124617 | 124617 | 2020-05-08 | Pinellas | Florida | 12103 | 828 | 59 |
127604 | 127604 | 2020-05-09 | Pinellas | Florida | 12103 | 848 | 59 |
130595 | 130595 | 2020-05-10 | Pinellas | Florida | 12103 | 861 | 60 |
133586 | 133586 | 2020-05-11 | Pinellas | Florida | 12103 | 876 | 61 |
136575 | 136575 | 2020-05-12 | Pinellas | Florida | 12103 | 909 | 62 |
139566 | 139566 | 2020-05-13 | Pinellas | Florida | 12103 | 923 | 63 |
142562 | 142562 | 2020-05-14 | Pinellas | Florida | 12103 | 962 | 65 |
145562 | 145562 | 2020-05-15 | Pinellas | Florida | 12103 | 997 | 66 |
148565 | 148565 | 2020-05-16 | Pinellas | Florida | 12103 | 1008 | 67 |
151574 | 151574 | 2020-05-17 | Pinellas | Florida | 12103 | 1022 | 67 |
154586 | 154586 | 2020-05-18 | Pinellas | Florida | 12103 | 1051 | 68 |
157602 | 157602 | 2020-05-19 | Pinellas | Florida | 12103 | 1062 | 71 |
160628 | 160628 | 2020-05-20 | Pinellas | Florida | 12103 | 1075 | 72 |
163656 | 163656 | 2020-05-21 | Pinellas | Florida | 12103 | 1109 | 73 |
166689 | 166689 | 2020-05-22 | Pinellas | Florida | 12103 | 1116 | 73 |
169726 | 169726 | 2020-05-23 | Pinellas | Florida | 12103 | 1153 | 75 |
172767 | 172767 | 2020-05-24 | Pinellas | Florida | 12103 | 1173 | 75 |
175810 | 175810 | 2020-05-25 | Pinellas | Florida | 12103 | 1187 | 75 |
178854 | 178854 | 2020-05-26 | Pinellas | Florida | 12103 | 1196 | 75 |
181898 | 181898 | 2020-05-27 | Pinellas | Florida | 12103 | 1205 | 79 |
184952 | 184952 | 2020-05-28 | Pinellas | Florida | 12103 | 1218 | 80 |
188008 | 188008 | 2020-05-29 | Pinellas | Florida | 12103 | 1238 | 82 |
191073 | 191073 | 2020-05-30 | Pinellas | Florida | 12103 | 1262 | 82 |
194140 | 194140 | 2020-05-31 | Pinellas | Florida | 12103 | 1297 | 82 |
197210 | 197210 | 2020-06-01 | Pinellas | Florida | 12103 | 1313 | 83 |
200283 | 200283 | 2020-06-02 | Pinellas | Florida | 12103 | 1335 | 90 |
203359 | 203359 | 2020-06-03 | Pinellas | Florida | 12103 | 1361 | 90 |
206439 | 206439 | 2020-06-04 | Pinellas | Florida | 12103 | 1397 | 91 |
209520 | 209520 | 2020-06-05 | Pinellas | Florida | 12103 | 1478 | 95 |
212605 | 212605 | 2020-06-06 | Pinellas | Florida | 12103 | 1532 | 95 |
215692 | 215692 | 2020-06-07 | Pinellas | Florida | 12103 | 1584 | 95 |
218783 | 218783 | 2020-06-08 | Pinellas | Florida | 12103 | 1638 | 95 |
221878 | 221878 | 2020-06-09 | Pinellas | Florida | 12103 | 1679 | 99 |
224973 | 224973 | 2020-06-10 | Pinellas | Florida | 12103 | 1746 | 100 |
228075 | 228075 | 2020-06-11 | Pinellas | Florida | 12103 | 1862 | 101 |
231178 | 231178 | 2020-06-12 | Pinellas | Florida | 12103 | 1941 | 102 |
234284 | 234284 | 2020-06-13 | Pinellas | Florida | 12103 | 2103 | 102 |
237391 | 237391 | 2020-06-14 | Pinellas | Florida | 12103 | 2235 | 102 |
240499 | 240499 | 2020-06-15 | Pinellas | Florida | 12103 | 2389 | 102 |
243610 | 243610 | 2020-06-16 | Pinellas | Florida | 12103 | 2523 | 107 |
246723 | 246723 | 2020-06-17 | Pinellas | Florida | 12103 | 2684 | 110 |
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);