ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 40087 and state = "Oklahoma" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4957 | 4957 | 2020-03-19 | McClain | Oklahoma | 40087 | 1 | 0 |
5824 | 5824 | 2020-03-20 | McClain | Oklahoma | 40087 | 1 | 0 |
6825 | 6825 | 2020-03-21 | McClain | Oklahoma | 40087 | 1 | 0 |
7938 | 7938 | 2020-03-22 | McClain | Oklahoma | 40087 | 1 | 0 |
9146 | 9146 | 2020-03-23 | McClain | Oklahoma | 40087 | 1 | 0 |
10463 | 10463 | 2020-03-24 | McClain | Oklahoma | 40087 | 1 | 0 |
11921 | 11921 | 2020-03-25 | McClain | Oklahoma | 40087 | 1 | 0 |
13534 | 13534 | 2020-03-26 | McClain | Oklahoma | 40087 | 2 | 0 |
15277 | 15277 | 2020-03-27 | McClain | Oklahoma | 40087 | 2 | 0 |
17123 | 17123 | 2020-03-28 | McClain | Oklahoma | 40087 | 2 | 0 |
19058 | 19058 | 2020-03-29 | McClain | Oklahoma | 40087 | 2 | 0 |
21108 | 21108 | 2020-03-30 | McClain | Oklahoma | 40087 | 2 | 0 |
23241 | 23241 | 2020-03-31 | McClain | Oklahoma | 40087 | 3 | 0 |
25438 | 25438 | 2020-04-01 | McClain | Oklahoma | 40087 | 9 | 0 |
27710 | 27710 | 2020-04-02 | McClain | Oklahoma | 40087 | 11 | 0 |
30041 | 30041 | 2020-04-03 | McClain | Oklahoma | 40087 | 11 | 0 |
32430 | 32430 | 2020-04-04 | McClain | Oklahoma | 40087 | 11 | 0 |
34864 | 34864 | 2020-04-05 | McClain | Oklahoma | 40087 | 12 | 0 |
37338 | 37338 | 2020-04-06 | McClain | Oklahoma | 40087 | 12 | 0 |
39859 | 39859 | 2020-04-07 | McClain | Oklahoma | 40087 | 16 | 0 |
42419 | 42419 | 2020-04-08 | McClain | Oklahoma | 40087 | 15 | 0 |
45005 | 45005 | 2020-04-09 | McClain | Oklahoma | 40087 | 17 | 0 |
47620 | 47620 | 2020-04-10 | McClain | Oklahoma | 40087 | 18 | 0 |
50276 | 50276 | 2020-04-11 | McClain | Oklahoma | 40087 | 18 | 0 |
52949 | 52949 | 2020-04-12 | McClain | Oklahoma | 40087 | 18 | 0 |
55634 | 55634 | 2020-04-13 | McClain | Oklahoma | 40087 | 19 | 0 |
58336 | 58336 | 2020-04-14 | McClain | Oklahoma | 40087 | 18 | 0 |
61051 | 61051 | 2020-04-15 | McClain | Oklahoma | 40087 | 19 | 0 |
63777 | 63777 | 2020-04-16 | McClain | Oklahoma | 40087 | 20 | 0 |
66521 | 66521 | 2020-04-17 | McClain | Oklahoma | 40087 | 21 | 0 |
69279 | 69279 | 2020-04-18 | McClain | Oklahoma | 40087 | 23 | 0 |
72046 | 72046 | 2020-04-19 | McClain | Oklahoma | 40087 | 23 | 0 |
74821 | 74821 | 2020-04-20 | McClain | Oklahoma | 40087 | 22 | 0 |
77603 | 77603 | 2020-04-21 | McClain | Oklahoma | 40087 | 23 | 0 |
80393 | 80393 | 2020-04-22 | McClain | Oklahoma | 40087 | 25 | 0 |
83192 | 83192 | 2020-04-23 | McClain | Oklahoma | 40087 | 28 | 0 |
85996 | 85996 | 2020-04-24 | McClain | Oklahoma | 40087 | 30 | 0 |
88810 | 88810 | 2020-04-25 | McClain | Oklahoma | 40087 | 30 | 0 |
91626 | 91626 | 2020-04-26 | McClain | Oklahoma | 40087 | 30 | 0 |
94452 | 94452 | 2020-04-27 | McClain | Oklahoma | 40087 | 30 | 0 |
97290 | 97290 | 2020-04-28 | McClain | Oklahoma | 40087 | 35 | 0 |
100139 | 100139 | 2020-04-29 | McClain | Oklahoma | 40087 | 35 | 0 |
102992 | 102992 | 2020-04-30 | McClain | Oklahoma | 40087 | 53 | 2 |
105855 | 105855 | 2020-05-01 | McClain | Oklahoma | 40087 | 74 | 2 |
108722 | 108722 | 2020-05-02 | McClain | Oklahoma | 40087 | 74 | 2 |
111596 | 111596 | 2020-05-03 | McClain | Oklahoma | 40087 | 77 | 2 |
114478 | 114478 | 2020-05-04 | McClain | Oklahoma | 40087 | 77 | 2 |
117359 | 117359 | 2020-05-05 | McClain | Oklahoma | 40087 | 84 | 2 |
120320 | 120320 | 2020-05-06 | McClain | Oklahoma | 40087 | 83 | 2 |
123297 | 123297 | 2020-05-07 | McClain | Oklahoma | 40087 | 84 | 2 |
126280 | 126280 | 2020-05-08 | McClain | Oklahoma | 40087 | 85 | 2 |
129269 | 129269 | 2020-05-09 | McClain | Oklahoma | 40087 | 85 | 2 |
132258 | 132258 | 2020-05-10 | McClain | Oklahoma | 40087 | 85 | 2 |
135249 | 135249 | 2020-05-11 | McClain | Oklahoma | 40087 | 85 | 2 |
138239 | 138239 | 2020-05-12 | McClain | Oklahoma | 40087 | 85 | 2 |
141235 | 141235 | 2020-05-13 | McClain | Oklahoma | 40087 | 86 | 2 |
144230 | 144230 | 2020-05-14 | McClain | Oklahoma | 40087 | 86 | 2 |
147231 | 147231 | 2020-05-15 | McClain | Oklahoma | 40087 | 86 | 2 |
150238 | 150238 | 2020-05-16 | McClain | Oklahoma | 40087 | 86 | 2 |
153249 | 153249 | 2020-05-17 | McClain | Oklahoma | 40087 | 86 | 2 |
156266 | 156266 | 2020-05-18 | McClain | Oklahoma | 40087 | 86 | 2 |
159287 | 159287 | 2020-05-19 | McClain | Oklahoma | 40087 | 95 | 2 |
162314 | 162314 | 2020-05-20 | McClain | Oklahoma | 40087 | 95 | 2 |
165343 | 165343 | 2020-05-21 | McClain | Oklahoma | 40087 | 95 | 2 |
168379 | 168379 | 2020-05-22 | McClain | Oklahoma | 40087 | 95 | 2 |
171418 | 171418 | 2020-05-23 | McClain | Oklahoma | 40087 | 97 | 2 |
174460 | 174460 | 2020-05-24 | McClain | Oklahoma | 40087 | 98 | 2 |
177504 | 177504 | 2020-05-25 | McClain | Oklahoma | 40087 | 98 | 2 |
180547 | 180547 | 2020-05-26 | McClain | Oklahoma | 40087 | 98 | 2 |
183596 | 183596 | 2020-05-27 | McClain | Oklahoma | 40087 | 101 | 2 |
186653 | 186653 | 2020-05-28 | McClain | Oklahoma | 40087 | 103 | 3 |
189714 | 189714 | 2020-05-29 | McClain | Oklahoma | 40087 | 104 | 3 |
192779 | 192779 | 2020-05-30 | McClain | Oklahoma | 40087 | 104 | 3 |
195848 | 195848 | 2020-05-31 | McClain | Oklahoma | 40087 | 105 | 3 |
198921 | 198921 | 2020-06-01 | McClain | Oklahoma | 40087 | 105 | 3 |
201996 | 201996 | 2020-06-02 | McClain | Oklahoma | 40087 | 106 | 3 |
205073 | 205073 | 2020-06-03 | McClain | Oklahoma | 40087 | 106 | 3 |
208154 | 208154 | 2020-06-04 | McClain | Oklahoma | 40087 | 107 | 3 |
211236 | 211236 | 2020-06-05 | McClain | Oklahoma | 40087 | 109 | 3 |
214322 | 214322 | 2020-06-06 | McClain | Oklahoma | 40087 | 109 | 4 |
217412 | 217412 | 2020-06-07 | McClain | Oklahoma | 40087 | 109 | 4 |
220504 | 220504 | 2020-06-08 | McClain | Oklahoma | 40087 | 110 | 4 |
223599 | 223599 | 2020-06-09 | McClain | Oklahoma | 40087 | 110 | 4 |
226699 | 226699 | 2020-06-10 | McClain | Oklahoma | 40087 | 110 | 4 |
229803 | 229803 | 2020-06-11 | McClain | Oklahoma | 40087 | 112 | 4 |
232908 | 232908 | 2020-06-12 | McClain | Oklahoma | 40087 | 114 | 4 |
236013 | 236013 | 2020-06-13 | McClain | Oklahoma | 40087 | 113 | 4 |
239121 | 239121 | 2020-06-14 | McClain | Oklahoma | 40087 | 116 | 4 |
242230 | 242230 | 2020-06-15 | McClain | Oklahoma | 40087 | 116 | 4 |
245342 | 245342 | 2020-06-16 | McClain | Oklahoma | 40087 | 118 | 4 |
248455 | 248455 | 2020-06-17 | McClain | Oklahoma | 40087 | 118 | 4 |
251570 | 251570 | 2020-06-18 | McClain | Oklahoma | 40087 | 120 | 4 |
254685 | 254685 | 2020-06-19 | McClain | Oklahoma | 40087 | 121 | 4 |
257811 | 257811 | 2020-06-20 | McClain | Oklahoma | 40087 | 124 | 4 |
260938 | 260938 | 2020-06-21 | McClain | Oklahoma | 40087 | 130 | 4 |
264066 | 264066 | 2020-06-22 | McClain | Oklahoma | 40087 | 130 | 4 |
267194 | 267194 | 2020-06-23 | McClain | Oklahoma | 40087 | 133 | 4 |
270328 | 270328 | 2020-06-24 | McClain | Oklahoma | 40087 | 133 | 4 |
273467 | 273467 | 2020-06-25 | McClain | Oklahoma | 40087 | 139 | 4 |
276614 | 276614 | 2020-06-26 | McClain | Oklahoma | 40087 | 141 | 4 |
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);