ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Custer", fips = 40039 and state = "Oklahoma" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
4952 | 4952 | 2020-03-19 | Custer | Oklahoma | 40039 | 1 | 0 |
5818 | 5818 | 2020-03-20 | Custer | Oklahoma | 40039 | 1 | 0 |
6819 | 6819 | 2020-03-21 | Custer | Oklahoma | 40039 | 1 | 0 |
7932 | 7932 | 2020-03-22 | Custer | Oklahoma | 40039 | 1 | 0 |
9140 | 9140 | 2020-03-23 | Custer | Oklahoma | 40039 | 1 | 0 |
10456 | 10456 | 2020-03-24 | Custer | Oklahoma | 40039 | 1 | 0 |
11913 | 11913 | 2020-03-25 | Custer | Oklahoma | 40039 | 3 | 0 |
13525 | 13525 | 2020-03-26 | Custer | Oklahoma | 40039 | 3 | 0 |
15267 | 15267 | 2020-03-27 | Custer | Oklahoma | 40039 | 3 | 0 |
17112 | 17112 | 2020-03-28 | Custer | Oklahoma | 40039 | 3 | 0 |
19046 | 19046 | 2020-03-29 | Custer | Oklahoma | 40039 | 4 | 0 |
21095 | 21095 | 2020-03-30 | Custer | Oklahoma | 40039 | 4 | 0 |
23228 | 23228 | 2020-03-31 | Custer | Oklahoma | 40039 | 4 | 0 |
25424 | 25424 | 2020-04-01 | Custer | Oklahoma | 40039 | 4 | 0 |
27694 | 27694 | 2020-04-02 | Custer | Oklahoma | 40039 | 5 | 0 |
30023 | 30023 | 2020-04-03 | Custer | Oklahoma | 40039 | 5 | 0 |
32412 | 32412 | 2020-04-04 | Custer | Oklahoma | 40039 | 5 | 0 |
34846 | 34846 | 2020-04-05 | Custer | Oklahoma | 40039 | 5 | 0 |
37319 | 37319 | 2020-04-06 | Custer | Oklahoma | 40039 | 5 | 0 |
39838 | 39838 | 2020-04-07 | Custer | Oklahoma | 40039 | 5 | 0 |
42398 | 42398 | 2020-04-08 | Custer | Oklahoma | 40039 | 5 | 0 |
44984 | 44984 | 2020-04-09 | Custer | Oklahoma | 40039 | 5 | 0 |
47599 | 47599 | 2020-04-10 | Custer | Oklahoma | 40039 | 5 | 0 |
50255 | 50255 | 2020-04-11 | Custer | Oklahoma | 40039 | 5 | 0 |
52928 | 52928 | 2020-04-12 | Custer | Oklahoma | 40039 | 5 | 0 |
55613 | 55613 | 2020-04-13 | Custer | Oklahoma | 40039 | 6 | 0 |
58314 | 58314 | 2020-04-14 | Custer | Oklahoma | 40039 | 7 | 0 |
61029 | 61029 | 2020-04-15 | Custer | Oklahoma | 40039 | 7 | 0 |
63755 | 63755 | 2020-04-16 | Custer | Oklahoma | 40039 | 7 | 0 |
66498 | 66498 | 2020-04-17 | Custer | Oklahoma | 40039 | 7 | 0 |
69255 | 69255 | 2020-04-18 | Custer | Oklahoma | 40039 | 9 | 0 |
72022 | 72022 | 2020-04-19 | Custer | Oklahoma | 40039 | 9 | 0 |
74797 | 74797 | 2020-04-20 | Custer | Oklahoma | 40039 | 10 | 0 |
77579 | 77579 | 2020-04-21 | Custer | Oklahoma | 40039 | 10 | 0 |
80369 | 80369 | 2020-04-22 | Custer | Oklahoma | 40039 | 10 | 0 |
83168 | 83168 | 2020-04-23 | Custer | Oklahoma | 40039 | 10 | 0 |
85972 | 85972 | 2020-04-24 | Custer | Oklahoma | 40039 | 10 | 0 |
88786 | 88786 | 2020-04-25 | Custer | Oklahoma | 40039 | 10 | 0 |
91602 | 91602 | 2020-04-26 | Custer | Oklahoma | 40039 | 10 | 0 |
94428 | 94428 | 2020-04-27 | Custer | Oklahoma | 40039 | 10 | 0 |
97266 | 97266 | 2020-04-28 | Custer | Oklahoma | 40039 | 10 | 0 |
100115 | 100115 | 2020-04-29 | Custer | Oklahoma | 40039 | 10 | 0 |
102968 | 102968 | 2020-04-30 | Custer | Oklahoma | 40039 | 10 | 0 |
105831 | 105831 | 2020-05-01 | Custer | Oklahoma | 40039 | 10 | 0 |
108698 | 108698 | 2020-05-02 | Custer | Oklahoma | 40039 | 10 | 0 |
111572 | 111572 | 2020-05-03 | Custer | Oklahoma | 40039 | 11 | 0 |
114454 | 114454 | 2020-05-04 | Custer | Oklahoma | 40039 | 11 | 0 |
117335 | 117335 | 2020-05-05 | Custer | Oklahoma | 40039 | 11 | 0 |
120296 | 120296 | 2020-05-06 | Custer | Oklahoma | 40039 | 11 | 0 |
123273 | 123273 | 2020-05-07 | Custer | Oklahoma | 40039 | 11 | 0 |
126256 | 126256 | 2020-05-08 | Custer | Oklahoma | 40039 | 11 | 0 |
129245 | 129245 | 2020-05-09 | Custer | Oklahoma | 40039 | 11 | 0 |
132234 | 132234 | 2020-05-10 | Custer | Oklahoma | 40039 | 11 | 0 |
135225 | 135225 | 2020-05-11 | Custer | Oklahoma | 40039 | 11 | 0 |
138215 | 138215 | 2020-05-12 | Custer | Oklahoma | 40039 | 12 | 0 |
141211 | 141211 | 2020-05-13 | Custer | Oklahoma | 40039 | 12 | 0 |
144206 | 144206 | 2020-05-14 | Custer | Oklahoma | 40039 | 12 | 0 |
147207 | 147207 | 2020-05-15 | Custer | Oklahoma | 40039 | 12 | 0 |
150214 | 150214 | 2020-05-16 | Custer | Oklahoma | 40039 | 12 | 0 |
153225 | 153225 | 2020-05-17 | Custer | Oklahoma | 40039 | 12 | 0 |
156242 | 156242 | 2020-05-18 | Custer | Oklahoma | 40039 | 12 | 0 |
159263 | 159263 | 2020-05-19 | Custer | Oklahoma | 40039 | 12 | 0 |
162290 | 162290 | 2020-05-20 | Custer | Oklahoma | 40039 | 12 | 0 |
165319 | 165319 | 2020-05-21 | Custer | Oklahoma | 40039 | 12 | 0 |
168355 | 168355 | 2020-05-22 | Custer | Oklahoma | 40039 | 12 | 0 |
171394 | 171394 | 2020-05-23 | Custer | Oklahoma | 40039 | 12 | 0 |
174436 | 174436 | 2020-05-24 | Custer | Oklahoma | 40039 | 12 | 0 |
177480 | 177480 | 2020-05-25 | Custer | Oklahoma | 40039 | 12 | 0 |
180523 | 180523 | 2020-05-26 | Custer | Oklahoma | 40039 | 12 | 0 |
183572 | 183572 | 2020-05-27 | Custer | Oklahoma | 40039 | 13 | 0 |
186629 | 186629 | 2020-05-28 | Custer | Oklahoma | 40039 | 13 | 0 |
189689 | 189689 | 2020-05-29 | Custer | Oklahoma | 40039 | 13 | 0 |
192754 | 192754 | 2020-05-30 | Custer | Oklahoma | 40039 | 16 | 0 |
195823 | 195823 | 2020-05-31 | Custer | Oklahoma | 40039 | 20 | 0 |
198896 | 198896 | 2020-06-01 | Custer | Oklahoma | 40039 | 20 | 0 |
201971 | 201971 | 2020-06-02 | Custer | Oklahoma | 40039 | 26 | 0 |
205048 | 205048 | 2020-06-03 | Custer | Oklahoma | 40039 | 30 | 0 |
208129 | 208129 | 2020-06-04 | Custer | Oklahoma | 40039 | 31 | 0 |
211211 | 211211 | 2020-06-05 | Custer | Oklahoma | 40039 | 32 | 0 |
214297 | 214297 | 2020-06-06 | Custer | Oklahoma | 40039 | 32 | 0 |
217387 | 217387 | 2020-06-07 | Custer | Oklahoma | 40039 | 34 | 0 |
220479 | 220479 | 2020-06-08 | Custer | Oklahoma | 40039 | 34 | 0 |
223574 | 223574 | 2020-06-09 | Custer | Oklahoma | 40039 | 35 | 0 |
226674 | 226674 | 2020-06-10 | Custer | Oklahoma | 40039 | 37 | 0 |
229778 | 229778 | 2020-06-11 | Custer | Oklahoma | 40039 | 38 | 0 |
232883 | 232883 | 2020-06-12 | Custer | Oklahoma | 40039 | 40 | 0 |
235988 | 235988 | 2020-06-13 | Custer | Oklahoma | 40039 | 41 | 0 |
239096 | 239096 | 2020-06-14 | Custer | Oklahoma | 40039 | 41 | 0 |
242205 | 242205 | 2020-06-15 | Custer | Oklahoma | 40039 | 41 | 0 |
245317 | 245317 | 2020-06-16 | Custer | Oklahoma | 40039 | 42 | 0 |
248430 | 248430 | 2020-06-17 | Custer | Oklahoma | 40039 | 42 | 0 |
251545 | 251545 | 2020-06-18 | Custer | Oklahoma | 40039 | 46 | 0 |
254660 | 254660 | 2020-06-19 | Custer | Oklahoma | 40039 | 45 | 0 |
257786 | 257786 | 2020-06-20 | Custer | Oklahoma | 40039 | 49 | 0 |
260912 | 260912 | 2020-06-21 | Custer | Oklahoma | 40039 | 49 | 0 |
264040 | 264040 | 2020-06-22 | Custer | Oklahoma | 40039 | 50 | 0 |
267168 | 267168 | 2020-06-23 | Custer | Oklahoma | 40039 | 51 | 0 |
270302 | 270302 | 2020-06-24 | Custer | Oklahoma | 40039 | 51 | 0 |
273441 | 273441 | 2020-06-25 | Custer | Oklahoma | 40039 | 52 | 0 |
276588 | 276588 | 2020-06-26 | Custer | Oklahoma | 40039 | 54 | 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);