ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 12033 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 ▼ |
---|---|---|---|---|---|---|---|
2823 | 2823 | 2020-03-16 | Escambia | Florida | 12033 | 1 | 0 |
3307 | 3307 | 2020-03-17 | Escambia | Florida | 12033 | 1 | 0 |
3864 | 3864 | 2020-03-18 | Escambia | Florida | 12033 | 1 | 0 |
4529 | 4529 | 2020-03-19 | Escambia | Florida | 12033 | 1 | 0 |
5308 | 5308 | 2020-03-20 | Escambia | Florida | 12033 | 1 | 0 |
6236 | 6236 | 2020-03-21 | Escambia | Florida | 12033 | 1 | 0 |
7275 | 7275 | 2020-03-22 | Escambia | Florida | 12033 | 4 | 0 |
8421 | 8421 | 2020-03-23 | Escambia | Florida | 12033 | 9 | 0 |
9666 | 9666 | 2020-03-24 | Escambia | Florida | 12033 | 13 | 0 |
11040 | 11040 | 2020-03-25 | Escambia | Florida | 12033 | 17 | 0 |
12588 | 12588 | 2020-03-26 | Escambia | Florida | 12033 | 20 | 0 |
14257 | 14257 | 2020-03-27 | Escambia | Florida | 12033 | 28 | 0 |
16041 | 16041 | 2020-03-28 | Escambia | Florida | 12033 | 28 | 0 |
17933 | 17933 | 2020-03-29 | Escambia | Florida | 12033 | 37 | 0 |
19913 | 19913 | 2020-03-30 | Escambia | Florida | 12033 | 81 | 0 |
21991 | 21991 | 2020-03-31 | Escambia | Florida | 12033 | 94 | 0 |
24150 | 24150 | 2020-04-01 | Escambia | Florida | 12033 | 96 | 0 |
26380 | 26380 | 2020-04-02 | Escambia | Florida | 12033 | 101 | 0 |
28682 | 28682 | 2020-04-03 | Escambia | Florida | 12033 | 113 | 0 |
31041 | 31041 | 2020-04-04 | Escambia | Florida | 12033 | 118 | 1 |
33447 | 33447 | 2020-04-05 | Escambia | Florida | 12033 | 125 | 1 |
35892 | 35892 | 2020-04-06 | Escambia | Florida | 12033 | 141 | 1 |
38382 | 38382 | 2020-04-07 | Escambia | Florida | 12033 | 168 | 2 |
40925 | 40925 | 2020-04-08 | Escambia | Florida | 12033 | 182 | 3 |
43499 | 43499 | 2020-04-09 | Escambia | Florida | 12033 | 192 | 3 |
46100 | 46100 | 2020-04-10 | Escambia | Florida | 12033 | 204 | 3 |
48730 | 48730 | 2020-04-11 | Escambia | Florida | 12033 | 210 | 3 |
51391 | 51391 | 2020-04-12 | Escambia | Florida | 12033 | 224 | 3 |
54071 | 54071 | 2020-04-13 | Escambia | Florida | 12033 | 241 | 3 |
56763 | 56763 | 2020-04-14 | Escambia | Florida | 12033 | 247 | 4 |
59471 | 59471 | 2020-04-15 | Escambia | Florida | 12033 | 261 | 4 |
62190 | 62190 | 2020-04-16 | Escambia | Florida | 12033 | 277 | 4 |
64923 | 64923 | 2020-04-17 | Escambia | Florida | 12033 | 290 | 6 |
67671 | 67671 | 2020-04-18 | Escambia | Florida | 12033 | 304 | 8 |
70433 | 70433 | 2020-04-19 | Escambia | Florida | 12033 | 309 | 8 |
73202 | 73202 | 2020-04-20 | Escambia | Florida | 12033 | 315 | 8 |
75978 | 75978 | 2020-04-21 | Escambia | Florida | 12033 | 340 | 10 |
78762 | 78762 | 2020-04-22 | Escambia | Florida | 12033 | 418 | 10 |
81556 | 81556 | 2020-04-23 | Escambia | Florida | 12033 | 420 | 10 |
84356 | 84356 | 2020-04-24 | Escambia | Florida | 12033 | 434 | 11 |
87164 | 87164 | 2020-04-25 | Escambia | Florida | 12033 | 442 | 11 |
89981 | 89981 | 2020-04-26 | Escambia | Florida | 12033 | 457 | 11 |
92799 | 92799 | 2020-04-27 | Escambia | Florida | 12033 | 470 | 11 |
95631 | 95631 | 2020-04-28 | Escambia | Florida | 12033 | 485 | 11 |
98476 | 98476 | 2020-04-29 | Escambia | Florida | 12033 | 496 | 11 |
101326 | 101326 | 2020-04-30 | Escambia | Florida | 12033 | 506 | 11 |
104181 | 104181 | 2020-05-01 | Escambia | Florida | 12033 | 532 | 12 |
107046 | 107046 | 2020-05-02 | Escambia | Florida | 12033 | 538 | 13 |
109915 | 109915 | 2020-05-03 | Escambia | Florida | 12033 | 593 | 13 |
112790 | 112790 | 2020-05-04 | Escambia | Florida | 12033 | 595 | 13 |
115673 | 115673 | 2020-05-05 | Escambia | Florida | 12033 | 598 | 14 |
118633 | 118633 | 2020-05-06 | Escambia | Florida | 12033 | 604 | 15 |
121602 | 121602 | 2020-05-07 | Escambia | Florida | 12033 | 616 | 16 |
124581 | 124581 | 2020-05-08 | Escambia | Florida | 12033 | 618 | 18 |
127568 | 127568 | 2020-05-09 | Escambia | Florida | 12033 | 634 | 18 |
130559 | 130559 | 2020-05-10 | Escambia | Florida | 12033 | 638 | 18 |
133550 | 133550 | 2020-05-11 | Escambia | Florida | 12033 | 641 | 18 |
136539 | 136539 | 2020-05-12 | Escambia | Florida | 12033 | 659 | 19 |
139530 | 139530 | 2020-05-13 | Escambia | Florida | 12033 | 665 | 19 |
142526 | 142526 | 2020-05-14 | Escambia | Florida | 12033 | 671 | 19 |
145526 | 145526 | 2020-05-15 | Escambia | Florida | 12033 | 682 | 20 |
148529 | 148529 | 2020-05-16 | Escambia | Florida | 12033 | 682 | 20 |
151538 | 151538 | 2020-05-17 | Escambia | Florida | 12033 | 689 | 20 |
154550 | 154550 | 2020-05-18 | Escambia | Florida | 12033 | 707 | 20 |
157566 | 157566 | 2020-05-19 | Escambia | Florida | 12033 | 719 | 21 |
160592 | 160592 | 2020-05-20 | Escambia | Florida | 12033 | 723 | 21 |
163620 | 163620 | 2020-05-21 | Escambia | Florida | 12033 | 734 | 24 |
166653 | 166653 | 2020-05-22 | Escambia | Florida | 12033 | 740 | 25 |
169690 | 169690 | 2020-05-23 | Escambia | Florida | 12033 | 749 | 26 |
172731 | 172731 | 2020-05-24 | Escambia | Florida | 12033 | 756 | 26 |
175774 | 175774 | 2020-05-25 | Escambia | Florida | 12033 | 768 | 26 |
178818 | 178818 | 2020-05-26 | Escambia | Florida | 12033 | 769 | 26 |
181862 | 181862 | 2020-05-27 | Escambia | Florida | 12033 | 776 | 29 |
184916 | 184916 | 2020-05-28 | Escambia | Florida | 12033 | 784 | 29 |
187972 | 187972 | 2020-05-29 | Escambia | Florida | 12033 | 791 | 33 |
191037 | 191037 | 2020-05-30 | Escambia | Florida | 12033 | 810 | 33 |
194104 | 194104 | 2020-05-31 | Escambia | Florida | 12033 | 815 | 33 |
197174 | 197174 | 2020-06-01 | Escambia | Florida | 12033 | 828 | 33 |
200247 | 200247 | 2020-06-02 | Escambia | Florida | 12033 | 844 | 34 |
203323 | 203323 | 2020-06-03 | Escambia | Florida | 12033 | 853 | 35 |
206403 | 206403 | 2020-06-04 | Escambia | Florida | 12033 | 866 | 35 |
209484 | 209484 | 2020-06-05 | Escambia | Florida | 12033 | 871 | 36 |
212569 | 212569 | 2020-06-06 | Escambia | Florida | 12033 | 879 | 36 |
215656 | 215656 | 2020-06-07 | Escambia | Florida | 12033 | 888 | 36 |
218747 | 218747 | 2020-06-08 | Escambia | Florida | 12033 | 891 | 36 |
221842 | 221842 | 2020-06-09 | Escambia | Florida | 12033 | 907 | 36 |
224937 | 224937 | 2020-06-10 | Escambia | Florida | 12033 | 915 | 36 |
228039 | 228039 | 2020-06-11 | Escambia | Florida | 12033 | 944 | 37 |
231142 | 231142 | 2020-06-12 | Escambia | Florida | 12033 | 956 | 37 |
234248 | 234248 | 2020-06-13 | Escambia | Florida | 12033 | 961 | 38 |
237355 | 237355 | 2020-06-14 | Escambia | Florida | 12033 | 985 | 38 |
240463 | 240463 | 2020-06-15 | Escambia | Florida | 12033 | 999 | 38 |
243574 | 243574 | 2020-06-16 | Escambia | Florida | 12033 | 1020 | 38 |
246687 | 246687 | 2020-06-17 | Escambia | Florida | 12033 | 1052 | 38 |
249799 | 249799 | 2020-06-18 | Escambia | Florida | 12033 | 1089 | 40 |
252914 | 252914 | 2020-06-19 | Escambia | Florida | 12033 | 1127 | 41 |
256033 | 256033 | 2020-06-20 | Escambia | Florida | 12033 | 1170 | 41 |
259160 | 259160 | 2020-06-21 | Escambia | Florida | 12033 | 1198 | 41 |
262287 | 262287 | 2020-06-22 | Escambia | Florida | 12033 | 1202 | 41 |
265415 | 265415 | 2020-06-23 | Escambia | Florida | 12033 | 1244 | 43 |
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);