ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,567 rows where county = "Escambia" 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 |
14046 | 14046 | 2020-03-27 | Escambia | Alabama | 1053 | 1 | 0 |
14257 | 14257 | 2020-03-27 | Escambia | Florida | 12033 | 28 | 0 |
15824 | 15824 | 2020-03-28 | Escambia | Alabama | 1053 | 1 | 0 |
16041 | 16041 | 2020-03-28 | Escambia | Florida | 12033 | 28 | 0 |
17707 | 17707 | 2020-03-29 | Escambia | Alabama | 1053 | 1 | 0 |
17933 | 17933 | 2020-03-29 | Escambia | Florida | 12033 | 37 | 0 |
19677 | 19677 | 2020-03-30 | Escambia | Alabama | 1053 | 1 | 0 |
19913 | 19913 | 2020-03-30 | Escambia | Florida | 12033 | 81 | 0 |
21749 | 21749 | 2020-03-31 | Escambia | Alabama | 1053 | 1 | 0 |
21991 | 21991 | 2020-03-31 | Escambia | Florida | 12033 | 94 | 0 |
23905 | 23905 | 2020-04-01 | Escambia | Alabama | 1053 | 1 | 0 |
24150 | 24150 | 2020-04-01 | Escambia | Florida | 12033 | 96 | 0 |
26127 | 26127 | 2020-04-02 | Escambia | Alabama | 1053 | 2 | 0 |
26380 | 26380 | 2020-04-02 | Escambia | Florida | 12033 | 101 | 0 |
28423 | 28423 | 2020-04-03 | Escambia | Alabama | 1053 | 2 | 0 |
28682 | 28682 | 2020-04-03 | Escambia | Florida | 12033 | 113 | 0 |
30780 | 30780 | 2020-04-04 | Escambia | Alabama | 1053 | 2 | 0 |
33184 | 33184 | 2020-04-05 | Escambia | Alabama | 1053 | 3 | 0 |
35623 | 35623 | 2020-04-06 | Escambia | Alabama | 1053 | 3 | 0 |
38111 | 38111 | 2020-04-07 | Escambia | Alabama | 1053 | 3 | 0 |
40653 | 40653 | 2020-04-08 | Escambia | Alabama | 1053 | 5 | 0 |
43226 | 43226 | 2020-04-09 | Escambia | Alabama | 1053 | 5 | 0 |
45824 | 45824 | 2020-04-10 | Escambia | Alabama | 1053 | 6 | 0 |
48453 | 48453 | 2020-04-11 | Escambia | Alabama | 1053 | 8 | 0 |
51114 | 51114 | 2020-04-12 | Escambia | Alabama | 1053 | 8 | 0 |
53792 | 53792 | 2020-04-13 | Escambia | Alabama | 1053 | 10 | 0 |
56484 | 56484 | 2020-04-14 | Escambia | Alabama | 1053 | 10 | 0 |
59192 | 59192 | 2020-04-15 | Escambia | Alabama | 1053 | 11 | 0 |
61910 | 61910 | 2020-04-16 | Escambia | Alabama | 1053 | 12 | 0 |
64643 | 64643 | 2020-04-17 | Escambia | Alabama | 1053 | 14 | 0 |
67391 | 67391 | 2020-04-18 | Escambia | Alabama | 1053 | 12 | 0 |
70153 | 70153 | 2020-04-19 | Escambia | Alabama | 1053 | 15 | 0 |
72922 | 72922 | 2020-04-20 | Escambia | Alabama | 1053 | 16 | 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 |
75698 | 75698 | 2020-04-21 | Escambia | Alabama | 1053 | 17 | 1 |
78481 | 78481 | 2020-04-22 | Escambia | Alabama | 1053 | 18 | 1 |
81274 | 81274 | 2020-04-23 | Escambia | Alabama | 1053 | 21 | 1 |
84075 | 84075 | 2020-04-24 | Escambia | Alabama | 1053 | 22 | 1 |
86883 | 86883 | 2020-04-25 | Escambia | Alabama | 1053 | 22 | 1 |
89699 | 89699 | 2020-04-26 | Escambia | Alabama | 1053 | 25 | 1 |
92517 | 92517 | 2020-04-27 | Escambia | Alabama | 1053 | 26 | 1 |
95347 | 95347 | 2020-04-28 | Escambia | Alabama | 1053 | 27 | 1 |
98192 | 98192 | 2020-04-29 | Escambia | Alabama | 1053 | 27 | 1 |
101042 | 101042 | 2020-04-30 | Escambia | Alabama | 1053 | 28 | 1 |
38382 | 38382 | 2020-04-07 | Escambia | Florida | 12033 | 168 | 2 |
103897 | 103897 | 2020-05-01 | Escambia | Alabama | 1053 | 29 | 2 |
106762 | 106762 | 2020-05-02 | Escambia | Alabama | 1053 | 30 | 2 |
109631 | 109631 | 2020-05-03 | Escambia | Alabama | 1053 | 31 | 2 |
112506 | 112506 | 2020-05-04 | Escambia | Alabama | 1053 | 32 | 2 |
115389 | 115389 | 2020-05-05 | Escambia | Alabama | 1053 | 31 | 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 |
118348 | 118348 | 2020-05-06 | Escambia | Alabama | 1053 | 30 | 3 |
121314 | 121314 | 2020-05-07 | Escambia | Alabama | 1053 | 33 | 3 |
124294 | 124294 | 2020-05-08 | Escambia | Alabama | 1053 | 35 | 3 |
127279 | 127279 | 2020-05-09 | Escambia | Alabama | 1053 | 36 | 3 |
130269 | 130269 | 2020-05-10 | Escambia | Alabama | 1053 | 36 | 3 |
133259 | 133259 | 2020-05-11 | Escambia | Alabama | 1053 | 37 | 3 |
136249 | 136249 | 2020-05-12 | Escambia | Alabama | 1053 | 38 | 3 |
139240 | 139240 | 2020-05-13 | Escambia | Alabama | 1053 | 38 | 3 |
142236 | 142236 | 2020-05-14 | Escambia | Alabama | 1053 | 39 | 3 |
145235 | 145235 | 2020-05-15 | Escambia | Alabama | 1053 | 39 | 3 |
148238 | 148238 | 2020-05-16 | Escambia | Alabama | 1053 | 39 | 3 |
151247 | 151247 | 2020-05-17 | Escambia | Alabama | 1053 | 39 | 3 |
154259 | 154259 | 2020-05-18 | Escambia | Alabama | 1053 | 39 | 3 |
157275 | 157275 | 2020-05-19 | Escambia | Alabama | 1053 | 39 | 3 |
160299 | 160299 | 2020-05-20 | Escambia | Alabama | 1053 | 39 | 3 |
163327 | 163327 | 2020-05-21 | Escambia | Alabama | 1053 | 39 | 3 |
166359 | 166359 | 2020-05-22 | Escambia | Alabama | 1053 | 39 | 3 |
169395 | 169395 | 2020-05-23 | Escambia | Alabama | 1053 | 40 | 3 |
172436 | 172436 | 2020-05-24 | Escambia | Alabama | 1053 | 43 | 3 |
175479 | 175479 | 2020-05-25 | Escambia | Alabama | 1053 | 43 | 3 |
178524 | 178524 | 2020-05-26 | Escambia | Alabama | 1053 | 45 | 3 |
181568 | 181568 | 2020-05-27 | Escambia | Alabama | 1053 | 48 | 3 |
184620 | 184620 | 2020-05-28 | Escambia | Alabama | 1053 | 49 | 3 |
187677 | 187677 | 2020-05-29 | Escambia | Alabama | 1053 | 57 | 3 |
190741 | 190741 | 2020-05-30 | Escambia | Alabama | 1053 | 57 | 3 |
193807 | 193807 | 2020-05-31 | Escambia | Alabama | 1053 | 63 | 3 |
196877 | 196877 | 2020-06-01 | Escambia | Alabama | 1053 | 72 | 3 |
199950 | 199950 | 2020-06-02 | Escambia | Alabama | 1053 | 74 | 3 |
203026 | 203026 | 2020-06-03 | Escambia | Alabama | 1053 | 75 | 3 |
206105 | 206105 | 2020-06-04 | Escambia | Alabama | 1053 | 75 | 3 |
209187 | 209187 | 2020-06-05 | Escambia | Alabama | 1053 | 79 | 3 |
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);