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 date
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 |
31041 | 31041 | 2020-04-04 | Escambia | Florida | 12033 | 118 | 1 |
33184 | 33184 | 2020-04-05 | Escambia | Alabama | 1053 | 3 | 0 |
33447 | 33447 | 2020-04-05 | Escambia | Florida | 12033 | 125 | 1 |
35623 | 35623 | 2020-04-06 | Escambia | Alabama | 1053 | 3 | 0 |
35892 | 35892 | 2020-04-06 | Escambia | Florida | 12033 | 141 | 1 |
38111 | 38111 | 2020-04-07 | Escambia | Alabama | 1053 | 3 | 0 |
38382 | 38382 | 2020-04-07 | Escambia | Florida | 12033 | 168 | 2 |
40653 | 40653 | 2020-04-08 | Escambia | Alabama | 1053 | 5 | 0 |
40925 | 40925 | 2020-04-08 | Escambia | Florida | 12033 | 182 | 3 |
43226 | 43226 | 2020-04-09 | Escambia | Alabama | 1053 | 5 | 0 |
43499 | 43499 | 2020-04-09 | Escambia | Florida | 12033 | 192 | 3 |
45824 | 45824 | 2020-04-10 | Escambia | Alabama | 1053 | 6 | 0 |
46100 | 46100 | 2020-04-10 | Escambia | Florida | 12033 | 204 | 3 |
48453 | 48453 | 2020-04-11 | Escambia | Alabama | 1053 | 8 | 0 |
48730 | 48730 | 2020-04-11 | Escambia | Florida | 12033 | 210 | 3 |
51114 | 51114 | 2020-04-12 | Escambia | Alabama | 1053 | 8 | 0 |
51391 | 51391 | 2020-04-12 | Escambia | Florida | 12033 | 224 | 3 |
53792 | 53792 | 2020-04-13 | Escambia | Alabama | 1053 | 10 | 0 |
54071 | 54071 | 2020-04-13 | Escambia | Florida | 12033 | 241 | 3 |
56484 | 56484 | 2020-04-14 | Escambia | Alabama | 1053 | 10 | 0 |
56763 | 56763 | 2020-04-14 | Escambia | Florida | 12033 | 247 | 4 |
59192 | 59192 | 2020-04-15 | Escambia | Alabama | 1053 | 11 | 0 |
59471 | 59471 | 2020-04-15 | Escambia | Florida | 12033 | 261 | 4 |
61910 | 61910 | 2020-04-16 | Escambia | Alabama | 1053 | 12 | 0 |
62190 | 62190 | 2020-04-16 | Escambia | Florida | 12033 | 277 | 4 |
64643 | 64643 | 2020-04-17 | Escambia | Alabama | 1053 | 14 | 0 |
64923 | 64923 | 2020-04-17 | Escambia | Florida | 12033 | 290 | 6 |
67391 | 67391 | 2020-04-18 | Escambia | Alabama | 1053 | 12 | 0 |
67671 | 67671 | 2020-04-18 | Escambia | Florida | 12033 | 304 | 8 |
70153 | 70153 | 2020-04-19 | Escambia | Alabama | 1053 | 15 | 0 |
70433 | 70433 | 2020-04-19 | Escambia | Florida | 12033 | 309 | 8 |
72922 | 72922 | 2020-04-20 | Escambia | Alabama | 1053 | 16 | 0 |
73202 | 73202 | 2020-04-20 | Escambia | Florida | 12033 | 315 | 8 |
75698 | 75698 | 2020-04-21 | Escambia | Alabama | 1053 | 17 | 1 |
75978 | 75978 | 2020-04-21 | Escambia | Florida | 12033 | 340 | 10 |
78481 | 78481 | 2020-04-22 | Escambia | Alabama | 1053 | 18 | 1 |
78762 | 78762 | 2020-04-22 | Escambia | Florida | 12033 | 418 | 10 |
81274 | 81274 | 2020-04-23 | Escambia | Alabama | 1053 | 21 | 1 |
81556 | 81556 | 2020-04-23 | Escambia | Florida | 12033 | 420 | 10 |
84075 | 84075 | 2020-04-24 | Escambia | Alabama | 1053 | 22 | 1 |
84356 | 84356 | 2020-04-24 | Escambia | Florida | 12033 | 434 | 11 |
86883 | 86883 | 2020-04-25 | Escambia | Alabama | 1053 | 22 | 1 |
87164 | 87164 | 2020-04-25 | Escambia | Florida | 12033 | 442 | 11 |
89699 | 89699 | 2020-04-26 | Escambia | Alabama | 1053 | 25 | 1 |
89981 | 89981 | 2020-04-26 | Escambia | Florida | 12033 | 457 | 11 |
92517 | 92517 | 2020-04-27 | Escambia | Alabama | 1053 | 26 | 1 |
92799 | 92799 | 2020-04-27 | Escambia | Florida | 12033 | 470 | 11 |
95347 | 95347 | 2020-04-28 | Escambia | Alabama | 1053 | 27 | 1 |
95631 | 95631 | 2020-04-28 | Escambia | Florida | 12033 | 485 | 11 |
98192 | 98192 | 2020-04-29 | Escambia | Alabama | 1053 | 27 | 1 |
98476 | 98476 | 2020-04-29 | Escambia | Florida | 12033 | 496 | 11 |
101042 | 101042 | 2020-04-30 | Escambia | Alabama | 1053 | 28 | 1 |
101326 | 101326 | 2020-04-30 | Escambia | Florida | 12033 | 506 | 11 |
103897 | 103897 | 2020-05-01 | Escambia | Alabama | 1053 | 29 | 2 |
104181 | 104181 | 2020-05-01 | Escambia | Florida | 12033 | 532 | 12 |
106762 | 106762 | 2020-05-02 | Escambia | Alabama | 1053 | 30 | 2 |
107046 | 107046 | 2020-05-02 | Escambia | Florida | 12033 | 538 | 13 |
109631 | 109631 | 2020-05-03 | Escambia | Alabama | 1053 | 31 | 2 |
109915 | 109915 | 2020-05-03 | Escambia | Florida | 12033 | 593 | 13 |
112506 | 112506 | 2020-05-04 | Escambia | Alabama | 1053 | 32 | 2 |
112790 | 112790 | 2020-05-04 | Escambia | Florida | 12033 | 595 | 13 |
115389 | 115389 | 2020-05-05 | Escambia | Alabama | 1053 | 31 | 2 |
115673 | 115673 | 2020-05-05 | Escambia | Florida | 12033 | 598 | 14 |
118348 | 118348 | 2020-05-06 | Escambia | Alabama | 1053 | 30 | 3 |
118633 | 118633 | 2020-05-06 | Escambia | Florida | 12033 | 604 | 15 |
121314 | 121314 | 2020-05-07 | Escambia | Alabama | 1053 | 33 | 3 |
121602 | 121602 | 2020-05-07 | Escambia | Florida | 12033 | 616 | 16 |
124294 | 124294 | 2020-05-08 | Escambia | Alabama | 1053 | 35 | 3 |
124581 | 124581 | 2020-05-08 | Escambia | Florida | 12033 | 618 | 18 |
127279 | 127279 | 2020-05-09 | Escambia | Alabama | 1053 | 36 | 3 |
127568 | 127568 | 2020-05-09 | Escambia | Florida | 12033 | 634 | 18 |
130269 | 130269 | 2020-05-10 | Escambia | Alabama | 1053 | 36 | 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);