ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,562 rows where county = "Leon" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3868 | 3868 | 2020-03-18 | Leon | Florida | 12073 | 1 | 0 |
4536 | 4536 | 2020-03-19 | Leon | Florida | 12073 | 3 | 0 |
5315 | 5315 | 2020-03-20 | Leon | Florida | 12073 | 4 | 0 |
6244 | 6244 | 2020-03-21 | Leon | Florida | 12073 | 4 | 0 |
7284 | 7284 | 2020-03-22 | Leon | Florida | 12073 | 4 | 0 |
8430 | 8430 | 2020-03-23 | Leon | Florida | 12073 | 5 | 0 |
9675 | 9675 | 2020-03-24 | Leon | Florida | 12073 | 6 | 0 |
11050 | 11050 | 2020-03-25 | Leon | Florida | 12073 | 7 | 0 |
12598 | 12598 | 2020-03-26 | Leon | Florida | 12073 | 12 | 0 |
14267 | 14267 | 2020-03-27 | Leon | Florida | 12073 | 15 | 0 |
16052 | 16052 | 2020-03-28 | Leon | Florida | 12073 | 17 | 0 |
17945 | 17945 | 2020-03-29 | Leon | Florida | 12073 | 16 | 0 |
19926 | 19926 | 2020-03-30 | Leon | Florida | 12073 | 21 | 0 |
21434 | 21434 | 2020-03-30 | Leon | Texas | 48289 | 1 | 0 |
22004 | 22004 | 2020-03-31 | Leon | Florida | 12073 | 26 | 0 |
23573 | 23573 | 2020-03-31 | Leon | Texas | 48289 | 1 | 0 |
24165 | 24165 | 2020-04-01 | Leon | Florida | 12073 | 32 | 0 |
25784 | 25784 | 2020-04-01 | Leon | Texas | 48289 | 2 | 0 |
26395 | 26395 | 2020-04-02 | Leon | Florida | 12073 | 34 | 0 |
28070 | 28070 | 2020-04-02 | Leon | Texas | 48289 | 2 | 0 |
28698 | 28698 | 2020-04-03 | Leon | Florida | 12073 | 38 | 0 |
30406 | 30406 | 2020-04-03 | Leon | Texas | 48289 | 2 | 0 |
31058 | 31058 | 2020-04-04 | Leon | Florida | 12073 | 41 | 0 |
32801 | 32801 | 2020-04-04 | Leon | Texas | 48289 | 2 | 0 |
33464 | 33464 | 2020-04-05 | Leon | Florida | 12073 | 41 | 0 |
35239 | 35239 | 2020-04-05 | Leon | Texas | 48289 | 2 | 0 |
35910 | 35910 | 2020-04-06 | Leon | Florida | 12073 | 58 | 0 |
37715 | 37715 | 2020-04-06 | Leon | Texas | 48289 | 2 | 0 |
38401 | 38401 | 2020-04-07 | Leon | Florida | 12073 | 67 | 0 |
40243 | 40243 | 2020-04-07 | Leon | Texas | 48289 | 2 | 0 |
40945 | 40945 | 2020-04-08 | Leon | Florida | 12073 | 71 | 0 |
42811 | 42811 | 2020-04-08 | Leon | Texas | 48289 | 2 | 0 |
43519 | 43519 | 2020-04-09 | Leon | Florida | 12073 | 77 | 0 |
45401 | 45401 | 2020-04-09 | Leon | Texas | 48289 | 2 | 0 |
46120 | 46120 | 2020-04-10 | Leon | Florida | 12073 | 90 | 0 |
48022 | 48022 | 2020-04-10 | Leon | Texas | 48289 | 3 | 0 |
48750 | 48750 | 2020-04-11 | Leon | Florida | 12073 | 112 | 0 |
50680 | 50680 | 2020-04-11 | Leon | Texas | 48289 | 3 | 0 |
51411 | 51411 | 2020-04-12 | Leon | Florida | 12073 | 119 | 0 |
53355 | 53355 | 2020-04-12 | Leon | Texas | 48289 | 3 | 0 |
54091 | 54091 | 2020-04-13 | Leon | Florida | 12073 | 149 | 0 |
56043 | 56043 | 2020-04-13 | Leon | Texas | 48289 | 3 | 0 |
56783 | 56783 | 2020-04-14 | Leon | Florida | 12073 | 149 | 0 |
58748 | 58748 | 2020-04-14 | Leon | Texas | 48289 | 3 | 0 |
59491 | 59491 | 2020-04-15 | Leon | Florida | 12073 | 155 | 0 |
61466 | 61466 | 2020-04-15 | Leon | Texas | 48289 | 4 | 0 |
62210 | 62210 | 2020-04-16 | Leon | Florida | 12073 | 164 | 0 |
64194 | 64194 | 2020-04-16 | Leon | Texas | 48289 | 4 | 0 |
64943 | 64943 | 2020-04-17 | Leon | Florida | 12073 | 173 | 1 |
66941 | 66941 | 2020-04-17 | Leon | Texas | 48289 | 5 | 0 |
67691 | 67691 | 2020-04-18 | Leon | Florida | 12073 | 168 | 1 |
69701 | 69701 | 2020-04-18 | Leon | Texas | 48289 | 5 | 0 |
70453 | 70453 | 2020-04-19 | Leon | Florida | 12073 | 175 | 1 |
72470 | 72470 | 2020-04-19 | Leon | Texas | 48289 | 5 | 0 |
73222 | 73222 | 2020-04-20 | Leon | Florida | 12073 | 183 | 1 |
75246 | 75246 | 2020-04-20 | Leon | Texas | 48289 | 5 | 0 |
75998 | 75998 | 2020-04-21 | Leon | Florida | 12073 | 185 | 1 |
78028 | 78028 | 2020-04-21 | Leon | Texas | 48289 | 5 | 0 |
78782 | 78782 | 2020-04-22 | Leon | Florida | 12073 | 185 | 1 |
80819 | 80819 | 2020-04-22 | Leon | Texas | 48289 | 5 | 0 |
81576 | 81576 | 2020-04-23 | Leon | Florida | 12073 | 190 | 2 |
83620 | 83620 | 2020-04-23 | Leon | Texas | 48289 | 5 | 0 |
84376 | 84376 | 2020-04-24 | Leon | Florida | 12073 | 206 | 2 |
86425 | 86425 | 2020-04-24 | Leon | Texas | 48289 | 5 | 0 |
87184 | 87184 | 2020-04-25 | Leon | Florida | 12073 | 207 | 2 |
89240 | 89240 | 2020-04-25 | Leon | Texas | 48289 | 5 | 0 |
90001 | 90001 | 2020-04-26 | Leon | Florida | 12073 | 209 | 2 |
92057 | 92057 | 2020-04-26 | Leon | Texas | 48289 | 5 | 0 |
92819 | 92819 | 2020-04-27 | Leon | Florida | 12073 | 211 | 3 |
94886 | 94886 | 2020-04-27 | Leon | Texas | 48289 | 5 | 0 |
95651 | 95651 | 2020-04-28 | Leon | Florida | 12073 | 212 | 3 |
97726 | 97726 | 2020-04-28 | Leon | Texas | 48289 | 5 | 0 |
98496 | 98496 | 2020-04-29 | Leon | Florida | 12073 | 213 | 3 |
100576 | 100576 | 2020-04-29 | Leon | Texas | 48289 | 5 | 0 |
101346 | 101346 | 2020-04-30 | Leon | Florida | 12073 | 218 | 3 |
103431 | 103431 | 2020-04-30 | Leon | Texas | 48289 | 5 | 0 |
104201 | 104201 | 2020-05-01 | Leon | Florida | 12073 | 225 | 3 |
106295 | 106295 | 2020-05-01 | Leon | Texas | 48289 | 6 | 0 |
107066 | 107066 | 2020-05-02 | Leon | Florida | 12073 | 232 | 3 |
109164 | 109164 | 2020-05-02 | Leon | Texas | 48289 | 6 | 0 |
109935 | 109935 | 2020-05-03 | Leon | Florida | 12073 | 233 | 4 |
112038 | 112038 | 2020-05-03 | Leon | Texas | 48289 | 6 | 0 |
112810 | 112810 | 2020-05-04 | Leon | Florida | 12073 | 242 | 5 |
114920 | 114920 | 2020-05-04 | Leon | Texas | 48289 | 6 | 0 |
115693 | 115693 | 2020-05-05 | Leon | Florida | 12073 | 242 | 5 |
117879 | 117879 | 2020-05-05 | Leon | Texas | 48289 | 7 | 0 |
118653 | 118653 | 2020-05-06 | Leon | Florida | 12073 | 242 | 6 |
120843 | 120843 | 2020-05-06 | Leon | Texas | 48289 | 7 | 0 |
121622 | 121622 | 2020-05-07 | Leon | Florida | 12073 | 248 | 6 |
123822 | 123822 | 2020-05-07 | Leon | Texas | 48289 | 7 | 0 |
124601 | 124601 | 2020-05-08 | Leon | Florida | 12073 | 248 | 6 |
126806 | 126806 | 2020-05-08 | Leon | Texas | 48289 | 9 | 0 |
127588 | 127588 | 2020-05-09 | Leon | Florida | 12073 | 251 | 6 |
129795 | 129795 | 2020-05-09 | Leon | Texas | 48289 | 9 | 0 |
130579 | 130579 | 2020-05-10 | Leon | Florida | 12073 | 253 | 6 |
132785 | 132785 | 2020-05-10 | Leon | Texas | 48289 | 9 | 0 |
133570 | 133570 | 2020-05-11 | Leon | Florida | 12073 | 253 | 6 |
135776 | 135776 | 2020-05-11 | Leon | Texas | 48289 | 9 | 0 |
136559 | 136559 | 2020-05-12 | Leon | Florida | 12073 | 265 | 6 |
138766 | 138766 | 2020-05-12 | Leon | Texas | 48289 | 9 | 0 |
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);