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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
3868 | 3868 | 2020-03-18 | Leon | Florida | 12073 | 1 | 0 |
21434 | 21434 | 2020-03-30 | Leon | Texas | 48289 | 1 | 0 |
23573 | 23573 | 2020-03-31 | Leon | Texas | 48289 | 1 | 0 |
25784 | 25784 | 2020-04-01 | Leon | Texas | 48289 | 2 | 0 |
28070 | 28070 | 2020-04-02 | Leon | Texas | 48289 | 2 | 0 |
30406 | 30406 | 2020-04-03 | Leon | Texas | 48289 | 2 | 0 |
32801 | 32801 | 2020-04-04 | Leon | Texas | 48289 | 2 | 0 |
35239 | 35239 | 2020-04-05 | Leon | Texas | 48289 | 2 | 0 |
37715 | 37715 | 2020-04-06 | Leon | Texas | 48289 | 2 | 0 |
40243 | 40243 | 2020-04-07 | Leon | Texas | 48289 | 2 | 0 |
42811 | 42811 | 2020-04-08 | Leon | Texas | 48289 | 2 | 0 |
45401 | 45401 | 2020-04-09 | Leon | Texas | 48289 | 2 | 0 |
4536 | 4536 | 2020-03-19 | Leon | Florida | 12073 | 3 | 0 |
48022 | 48022 | 2020-04-10 | Leon | Texas | 48289 | 3 | 0 |
50680 | 50680 | 2020-04-11 | Leon | Texas | 48289 | 3 | 0 |
53355 | 53355 | 2020-04-12 | Leon | Texas | 48289 | 3 | 0 |
56043 | 56043 | 2020-04-13 | Leon | Texas | 48289 | 3 | 0 |
58748 | 58748 | 2020-04-14 | Leon | Texas | 48289 | 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 |
61466 | 61466 | 2020-04-15 | Leon | Texas | 48289 | 4 | 0 |
64194 | 64194 | 2020-04-16 | Leon | Texas | 48289 | 4 | 0 |
8430 | 8430 | 2020-03-23 | Leon | Florida | 12073 | 5 | 0 |
66941 | 66941 | 2020-04-17 | Leon | Texas | 48289 | 5 | 0 |
69701 | 69701 | 2020-04-18 | Leon | Texas | 48289 | 5 | 0 |
72470 | 72470 | 2020-04-19 | Leon | Texas | 48289 | 5 | 0 |
75246 | 75246 | 2020-04-20 | Leon | Texas | 48289 | 5 | 0 |
78028 | 78028 | 2020-04-21 | Leon | Texas | 48289 | 5 | 0 |
80819 | 80819 | 2020-04-22 | Leon | Texas | 48289 | 5 | 0 |
83620 | 83620 | 2020-04-23 | Leon | Texas | 48289 | 5 | 0 |
86425 | 86425 | 2020-04-24 | Leon | Texas | 48289 | 5 | 0 |
89240 | 89240 | 2020-04-25 | Leon | Texas | 48289 | 5 | 0 |
92057 | 92057 | 2020-04-26 | Leon | Texas | 48289 | 5 | 0 |
94886 | 94886 | 2020-04-27 | Leon | Texas | 48289 | 5 | 0 |
97726 | 97726 | 2020-04-28 | Leon | Texas | 48289 | 5 | 0 |
100576 | 100576 | 2020-04-29 | Leon | Texas | 48289 | 5 | 0 |
103431 | 103431 | 2020-04-30 | Leon | Texas | 48289 | 5 | 0 |
9675 | 9675 | 2020-03-24 | Leon | Florida | 12073 | 6 | 0 |
106295 | 106295 | 2020-05-01 | Leon | Texas | 48289 | 6 | 0 |
109164 | 109164 | 2020-05-02 | Leon | Texas | 48289 | 6 | 0 |
112038 | 112038 | 2020-05-03 | Leon | Texas | 48289 | 6 | 0 |
114920 | 114920 | 2020-05-04 | Leon | Texas | 48289 | 6 | 0 |
11050 | 11050 | 2020-03-25 | Leon | Florida | 12073 | 7 | 0 |
117879 | 117879 | 2020-05-05 | Leon | Texas | 48289 | 7 | 0 |
120843 | 120843 | 2020-05-06 | Leon | Texas | 48289 | 7 | 0 |
123822 | 123822 | 2020-05-07 | Leon | Texas | 48289 | 7 | 0 |
126806 | 126806 | 2020-05-08 | Leon | Texas | 48289 | 9 | 0 |
129795 | 129795 | 2020-05-09 | Leon | Texas | 48289 | 9 | 0 |
132785 | 132785 | 2020-05-10 | Leon | Texas | 48289 | 9 | 0 |
135776 | 135776 | 2020-05-11 | Leon | Texas | 48289 | 9 | 0 |
138766 | 138766 | 2020-05-12 | Leon | Texas | 48289 | 9 | 0 |
141762 | 141762 | 2020-05-13 | Leon | Texas | 48289 | 9 | 0 |
144759 | 144759 | 2020-05-14 | Leon | Texas | 48289 | 9 | 0 |
147763 | 147763 | 2020-05-15 | Leon | Texas | 48289 | 9 | 0 |
150771 | 150771 | 2020-05-16 | Leon | Texas | 48289 | 9 | 0 |
153782 | 153782 | 2020-05-17 | Leon | Texas | 48289 | 9 | 0 |
156799 | 156799 | 2020-05-18 | Leon | Texas | 48289 | 9 | 0 |
159821 | 159821 | 2020-05-19 | Leon | Texas | 48289 | 9 | 0 |
162849 | 162849 | 2020-05-20 | Leon | Texas | 48289 | 9 | 0 |
165878 | 165878 | 2020-05-21 | Leon | Texas | 48289 | 9 | 0 |
168914 | 168914 | 2020-05-22 | Leon | Texas | 48289 | 9 | 0 |
171954 | 171954 | 2020-05-23 | Leon | Texas | 48289 | 9 | 0 |
174997 | 174997 | 2020-05-24 | Leon | Texas | 48289 | 9 | 0 |
178041 | 178041 | 2020-05-25 | Leon | Texas | 48289 | 9 | 0 |
181085 | 181085 | 2020-05-26 | Leon | Texas | 48289 | 9 | 0 |
184135 | 184135 | 2020-05-27 | Leon | Texas | 48289 | 9 | 0 |
187192 | 187192 | 2020-05-28 | Leon | Texas | 48289 | 10 | 0 |
190256 | 190256 | 2020-05-29 | Leon | Texas | 48289 | 10 | 0 |
193322 | 193322 | 2020-05-30 | Leon | Texas | 48289 | 10 | 0 |
196392 | 196392 | 2020-05-31 | Leon | Texas | 48289 | 10 | 0 |
199465 | 199465 | 2020-06-01 | Leon | Texas | 48289 | 10 | 0 |
202541 | 202541 | 2020-06-02 | Leon | Texas | 48289 | 10 | 0 |
205620 | 205620 | 2020-06-03 | Leon | Texas | 48289 | 10 | 0 |
208702 | 208702 | 2020-06-04 | Leon | Texas | 48289 | 10 | 0 |
211786 | 211786 | 2020-06-05 | Leon | Texas | 48289 | 11 | 0 |
214873 | 214873 | 2020-06-06 | Leon | Texas | 48289 | 11 | 0 |
217963 | 217963 | 2020-06-07 | Leon | Texas | 48289 | 11 | 0 |
221055 | 221055 | 2020-06-08 | Leon | Texas | 48289 | 11 | 0 |
224150 | 224150 | 2020-06-09 | Leon | Texas | 48289 | 11 | 0 |
227250 | 227250 | 2020-06-10 | Leon | Texas | 48289 | 11 | 0 |
230354 | 230354 | 2020-06-11 | Leon | Texas | 48289 | 11 | 0 |
233458 | 233458 | 2020-06-12 | Leon | Texas | 48289 | 11 | 0 |
236564 | 236564 | 2020-06-13 | Leon | Texas | 48289 | 11 | 0 |
239672 | 239672 | 2020-06-14 | Leon | Texas | 48289 | 11 | 0 |
242782 | 242782 | 2020-06-15 | Leon | Texas | 48289 | 11 | 0 |
12598 | 12598 | 2020-03-26 | Leon | Florida | 12073 | 12 | 0 |
245894 | 245894 | 2020-06-16 | Leon | Texas | 48289 | 12 | 0 |
249007 | 249007 | 2020-06-17 | Leon | Texas | 48289 | 13 | 0 |
252122 | 252122 | 2020-06-18 | Leon | Texas | 48289 | 13 | 0 |
255237 | 255237 | 2020-06-19 | Leon | Texas | 48289 | 13 | 0 |
258364 | 258364 | 2020-06-20 | Leon | Texas | 48289 | 14 | 0 |
14267 | 14267 | 2020-03-27 | Leon | Florida | 12073 | 15 | 0 |
261491 | 261491 | 2020-06-21 | Leon | Texas | 48289 | 15 | 0 |
17945 | 17945 | 2020-03-29 | Leon | Florida | 12073 | 16 | 0 |
264619 | 264619 | 2020-06-22 | Leon | Texas | 48289 | 16 | 0 |
16052 | 16052 | 2020-03-28 | Leon | Florida | 12073 | 17 | 0 |
267747 | 267747 | 2020-06-23 | Leon | Texas | 48289 | 19 | 0 |
270881 | 270881 | 2020-06-24 | Leon | Texas | 48289 | 19 | 0 |
274021 | 274021 | 2020-06-25 | Leon | Texas | 48289 | 19 | 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);