ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,572 rows where county = "Caddo" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1247 | 1247 | 2020-03-11 | Caddo | Louisiana | 22017 | 1 | 0 |
1464 | 1464 | 2020-03-12 | Caddo | Louisiana | 22017 | 1 | 0 |
1737 | 1737 | 2020-03-13 | Caddo | Louisiana | 22017 | 1 | 0 |
15258 | 15258 | 2020-03-27 | Caddo | Oklahoma | 40015 | 1 | 0 |
17103 | 17103 | 2020-03-28 | Caddo | Oklahoma | 40015 | 1 | 0 |
19037 | 19037 | 2020-03-29 | Caddo | Oklahoma | 40015 | 1 | 0 |
21085 | 21085 | 2020-03-30 | Caddo | Oklahoma | 40015 | 1 | 0 |
23218 | 23218 | 2020-03-31 | Caddo | Oklahoma | 40015 | 1 | 0 |
25414 | 25414 | 2020-04-01 | Caddo | Oklahoma | 40015 | 1 | 0 |
2075 | 2075 | 2020-03-14 | Caddo | Louisiana | 22017 | 2 | 0 |
2472 | 2472 | 2020-03-15 | Caddo | Louisiana | 22017 | 2 | 0 |
27684 | 27684 | 2020-04-02 | Caddo | Oklahoma | 40015 | 2 | 0 |
30013 | 30013 | 2020-04-03 | Caddo | Oklahoma | 40015 | 2 | 0 |
2918 | 2918 | 2020-03-16 | Caddo | Louisiana | 22017 | 3 | 0 |
3414 | 3414 | 2020-03-17 | Caddo | Louisiana | 22017 | 4 | 0 |
32402 | 32402 | 2020-04-04 | Caddo | Oklahoma | 40015 | 4 | 0 |
34836 | 34836 | 2020-04-05 | Caddo | Oklahoma | 40015 | 4 | 0 |
37309 | 37309 | 2020-04-06 | Caddo | Oklahoma | 40015 | 5 | 0 |
3994 | 3994 | 2020-03-18 | Caddo | Louisiana | 22017 | 6 | 0 |
39828 | 39828 | 2020-04-07 | Caddo | Oklahoma | 40015 | 6 | 0 |
42388 | 42388 | 2020-04-08 | Caddo | Oklahoma | 40015 | 6 | 0 |
44974 | 44974 | 2020-04-09 | Caddo | Oklahoma | 40015 | 6 | 0 |
47589 | 47589 | 2020-04-10 | Caddo | Oklahoma | 40015 | 8 | 0 |
50245 | 50245 | 2020-04-11 | Caddo | Oklahoma | 40015 | 9 | 0 |
52918 | 52918 | 2020-04-12 | Caddo | Oklahoma | 40015 | 9 | 0 |
55603 | 55603 | 2020-04-13 | Caddo | Oklahoma | 40015 | 9 | 0 |
4686 | 4686 | 2020-03-19 | Caddo | Louisiana | 22017 | 10 | 0 |
58304 | 58304 | 2020-04-14 | Caddo | Oklahoma | 40015 | 10 | 0 |
5500 | 5500 | 2020-03-20 | Caddo | Louisiana | 22017 | 12 | 0 |
6451 | 6451 | 2020-03-21 | Caddo | Louisiana | 22017 | 15 | 0 |
7526 | 7526 | 2020-03-22 | Caddo | Louisiana | 22017 | 16 | 0 |
8690 | 8690 | 2020-03-23 | Caddo | Louisiana | 22017 | 34 | 0 |
61019 | 61019 | 2020-04-15 | Caddo | Oklahoma | 40015 | 35 | 1 |
9978 | 9978 | 2020-03-24 | Caddo | Louisiana | 22017 | 40 | 0 |
63745 | 63745 | 2020-04-16 | Caddo | Oklahoma | 40015 | 48 | 2 |
66488 | 66488 | 2020-04-17 | Caddo | Oklahoma | 40015 | 51 | 2 |
69245 | 69245 | 2020-04-18 | Caddo | Oklahoma | 40015 | 51 | 2 |
72012 | 72012 | 2020-04-19 | Caddo | Oklahoma | 40015 | 51 | 2 |
74787 | 74787 | 2020-04-20 | Caddo | Oklahoma | 40015 | 52 | 3 |
77568 | 77568 | 2020-04-21 | Caddo | Oklahoma | 40015 | 52 | 3 |
80358 | 80358 | 2020-04-22 | Caddo | Oklahoma | 40015 | 53 | 4 |
83157 | 83157 | 2020-04-23 | Caddo | Oklahoma | 40015 | 53 | 5 |
85961 | 85961 | 2020-04-24 | Caddo | Oklahoma | 40015 | 53 | 6 |
88775 | 88775 | 2020-04-25 | Caddo | Oklahoma | 40015 | 53 | 6 |
91591 | 91591 | 2020-04-26 | Caddo | Oklahoma | 40015 | 58 | 6 |
94417 | 94417 | 2020-04-27 | Caddo | Oklahoma | 40015 | 58 | 6 |
97255 | 97255 | 2020-04-28 | Caddo | Oklahoma | 40015 | 61 | 7 |
100104 | 100104 | 2020-04-29 | Caddo | Oklahoma | 40015 | 61 | 7 |
102957 | 102957 | 2020-04-30 | Caddo | Oklahoma | 40015 | 62 | 7 |
105820 | 105820 | 2020-05-01 | Caddo | Oklahoma | 40015 | 64 | 7 |
108687 | 108687 | 2020-05-02 | Caddo | Oklahoma | 40015 | 64 | 8 |
111561 | 111561 | 2020-05-03 | Caddo | Oklahoma | 40015 | 69 | 8 |
114443 | 114443 | 2020-05-04 | Caddo | Oklahoma | 40015 | 72 | 8 |
117324 | 117324 | 2020-05-05 | Caddo | Oklahoma | 40015 | 77 | 8 |
120285 | 120285 | 2020-05-06 | Caddo | Oklahoma | 40015 | 77 | 8 |
123262 | 123262 | 2020-05-07 | Caddo | Oklahoma | 40015 | 89 | 8 |
11382 | 11382 | 2020-03-25 | Caddo | Louisiana | 22017 | 93 | 0 |
126245 | 126245 | 2020-05-08 | Caddo | Oklahoma | 40015 | 97 | 9 |
129234 | 129234 | 2020-05-09 | Caddo | Oklahoma | 40015 | 100 | 9 |
132223 | 132223 | 2020-05-10 | Caddo | Oklahoma | 40015 | 108 | 9 |
135214 | 135214 | 2020-05-11 | Caddo | Oklahoma | 40015 | 108 | 9 |
138204 | 138204 | 2020-05-12 | Caddo | Oklahoma | 40015 | 109 | 9 |
141200 | 141200 | 2020-05-13 | Caddo | Oklahoma | 40015 | 110 | 9 |
144195 | 144195 | 2020-05-14 | Caddo | Oklahoma | 40015 | 110 | 9 |
147196 | 147196 | 2020-05-15 | Caddo | Oklahoma | 40015 | 111 | 9 |
150203 | 150203 | 2020-05-16 | Caddo | Oklahoma | 40015 | 112 | 10 |
153214 | 153214 | 2020-05-17 | Caddo | Oklahoma | 40015 | 114 | 10 |
12957 | 12957 | 2020-03-26 | Caddo | Louisiana | 22017 | 115 | 1 |
156231 | 156231 | 2020-05-18 | Caddo | Oklahoma | 40015 | 120 | 10 |
159251 | 159251 | 2020-05-19 | Caddo | Oklahoma | 40015 | 122 | 10 |
162278 | 162278 | 2020-05-20 | Caddo | Oklahoma | 40015 | 126 | 10 |
165307 | 165307 | 2020-05-21 | Caddo | Oklahoma | 40015 | 132 | 10 |
168343 | 168343 | 2020-05-22 | Caddo | Oklahoma | 40015 | 132 | 10 |
171382 | 171382 | 2020-05-23 | Caddo | Oklahoma | 40015 | 136 | 10 |
174424 | 174424 | 2020-05-24 | Caddo | Oklahoma | 40015 | 136 | 10 |
14664 | 14664 | 2020-03-27 | Caddo | Louisiana | 22017 | 140 | 2 |
177468 | 177468 | 2020-05-25 | Caddo | Oklahoma | 40015 | 146 | 10 |
180511 | 180511 | 2020-05-26 | Caddo | Oklahoma | 40015 | 150 | 10 |
183560 | 183560 | 2020-05-27 | Caddo | Oklahoma | 40015 | 153 | 10 |
186617 | 186617 | 2020-05-28 | Caddo | Oklahoma | 40015 | 154 | 10 |
189677 | 189677 | 2020-05-29 | Caddo | Oklahoma | 40015 | 155 | 10 |
192742 | 192742 | 2020-05-30 | Caddo | Oklahoma | 40015 | 158 | 10 |
195811 | 195811 | 2020-05-31 | Caddo | Oklahoma | 40015 | 160 | 10 |
198884 | 198884 | 2020-06-01 | Caddo | Oklahoma | 40015 | 162 | 10 |
201959 | 201959 | 2020-06-02 | Caddo | Oklahoma | 40015 | 164 | 10 |
205036 | 205036 | 2020-06-03 | Caddo | Oklahoma | 40015 | 167 | 10 |
208117 | 208117 | 2020-06-04 | Caddo | Oklahoma | 40015 | 168 | 10 |
211199 | 211199 | 2020-06-05 | Caddo | Oklahoma | 40015 | 168 | 10 |
214285 | 214285 | 2020-06-06 | Caddo | Oklahoma | 40015 | 168 | 10 |
217375 | 217375 | 2020-06-07 | Caddo | Oklahoma | 40015 | 170 | 10 |
220467 | 220467 | 2020-06-08 | Caddo | Oklahoma | 40015 | 170 | 10 |
226662 | 226662 | 2020-06-10 | Caddo | Oklahoma | 40015 | 173 | 10 |
229766 | 229766 | 2020-06-11 | Caddo | Oklahoma | 40015 | 173 | 10 |
232871 | 232871 | 2020-06-12 | Caddo | Oklahoma | 40015 | 173 | 10 |
223562 | 223562 | 2020-06-09 | Caddo | Oklahoma | 40015 | 174 | 10 |
235976 | 235976 | 2020-06-13 | Caddo | Oklahoma | 40015 | 175 | 10 |
239084 | 239084 | 2020-06-14 | Caddo | Oklahoma | 40015 | 175 | 10 |
242193 | 242193 | 2020-06-15 | Caddo | Oklahoma | 40015 | 176 | 10 |
245305 | 245305 | 2020-06-16 | Caddo | Oklahoma | 40015 | 176 | 10 |
248418 | 248418 | 2020-06-17 | Caddo | Oklahoma | 40015 | 178 | 10 |
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);