ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,253 rows where county = "Beaver" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 3
- Pennsylvania 788
- Oklahoma 767
- Utah 698
county 1
- Beaver · 2,253 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
39825 | 39825 | 2020-04-07 | Beaver | Oklahoma | 40007 | 1 | 0 |
42385 | 42385 | 2020-04-08 | Beaver | Oklahoma | 40007 | 1 | 0 |
44971 | 44971 | 2020-04-09 | Beaver | Oklahoma | 40007 | 1 | 0 |
47586 | 47586 | 2020-04-10 | Beaver | Oklahoma | 40007 | 1 | 0 |
50242 | 50242 | 2020-04-11 | Beaver | Oklahoma | 40007 | 1 | 0 |
52915 | 52915 | 2020-04-12 | Beaver | Oklahoma | 40007 | 1 | 0 |
55600 | 55600 | 2020-04-13 | Beaver | Oklahoma | 40007 | 1 | 0 |
58301 | 58301 | 2020-04-14 | Beaver | Oklahoma | 40007 | 1 | 0 |
61016 | 61016 | 2020-04-15 | Beaver | Oklahoma | 40007 | 1 | 0 |
63742 | 63742 | 2020-04-16 | Beaver | Oklahoma | 40007 | 1 | 0 |
66485 | 66485 | 2020-04-17 | Beaver | Oklahoma | 40007 | 1 | 0 |
69242 | 69242 | 2020-04-18 | Beaver | Oklahoma | 40007 | 2 | 0 |
72009 | 72009 | 2020-04-19 | Beaver | Oklahoma | 40007 | 1 | 0 |
74784 | 74784 | 2020-04-20 | Beaver | Oklahoma | 40007 | 1 | 0 |
77565 | 77565 | 2020-04-21 | Beaver | Oklahoma | 40007 | 1 | 0 |
80355 | 80355 | 2020-04-22 | Beaver | Oklahoma | 40007 | 1 | 0 |
83154 | 83154 | 2020-04-23 | Beaver | Oklahoma | 40007 | 1 | 0 |
85958 | 85958 | 2020-04-24 | Beaver | Oklahoma | 40007 | 2 | 0 |
88772 | 88772 | 2020-04-25 | Beaver | Oklahoma | 40007 | 2 | 0 |
91588 | 91588 | 2020-04-26 | Beaver | Oklahoma | 40007 | 3 | 0 |
94414 | 94414 | 2020-04-27 | Beaver | Oklahoma | 40007 | 3 | 0 |
97252 | 97252 | 2020-04-28 | Beaver | Oklahoma | 40007 | 5 | 0 |
100101 | 100101 | 2020-04-29 | Beaver | Oklahoma | 40007 | 5 | 0 |
102954 | 102954 | 2020-04-30 | Beaver | Oklahoma | 40007 | 8 | 0 |
105817 | 105817 | 2020-05-01 | Beaver | Oklahoma | 40007 | 9 | 0 |
108684 | 108684 | 2020-05-02 | Beaver | Oklahoma | 40007 | 13 | 0 |
111558 | 111558 | 2020-05-03 | Beaver | Oklahoma | 40007 | 14 | 0 |
114439 | 114439 | 2020-05-04 | Beaver | Oklahoma | 40007 | 14 | 0 |
117320 | 117320 | 2020-05-05 | Beaver | Oklahoma | 40007 | 15 | 0 |
120281 | 120281 | 2020-05-06 | Beaver | Oklahoma | 40007 | 15 | 0 |
123258 | 123258 | 2020-05-07 | Beaver | Oklahoma | 40007 | 17 | 0 |
126241 | 126241 | 2020-05-08 | Beaver | Oklahoma | 40007 | 19 | 0 |
129230 | 129230 | 2020-05-09 | Beaver | Oklahoma | 40007 | 20 | 0 |
132219 | 132219 | 2020-05-10 | Beaver | Oklahoma | 40007 | 20 | 0 |
135210 | 135210 | 2020-05-11 | Beaver | Oklahoma | 40007 | 20 | 0 |
138200 | 138200 | 2020-05-12 | Beaver | Oklahoma | 40007 | 19 | 0 |
141196 | 141196 | 2020-05-13 | Beaver | Oklahoma | 40007 | 20 | 0 |
144191 | 144191 | 2020-05-14 | Beaver | Oklahoma | 40007 | 20 | 0 |
147192 | 147192 | 2020-05-15 | Beaver | Oklahoma | 40007 | 22 | 0 |
150199 | 150199 | 2020-05-16 | Beaver | Oklahoma | 40007 | 23 | 0 |
153210 | 153210 | 2020-05-17 | Beaver | Oklahoma | 40007 | 23 | 0 |
156227 | 156227 | 2020-05-18 | Beaver | Oklahoma | 40007 | 23 | 0 |
159247 | 159247 | 2020-05-19 | Beaver | Oklahoma | 40007 | 23 | 0 |
162274 | 162274 | 2020-05-20 | Beaver | Oklahoma | 40007 | 23 | 0 |
165303 | 165303 | 2020-05-21 | Beaver | Oklahoma | 40007 | 24 | 0 |
168339 | 168339 | 2020-05-22 | Beaver | Oklahoma | 40007 | 24 | 0 |
171378 | 171378 | 2020-05-23 | Beaver | Oklahoma | 40007 | 24 | 0 |
174420 | 174420 | 2020-05-24 | Beaver | Oklahoma | 40007 | 24 | 0 |
177464 | 177464 | 2020-05-25 | Beaver | Oklahoma | 40007 | 24 | 0 |
180507 | 180507 | 2020-05-26 | Beaver | Oklahoma | 40007 | 24 | 0 |
183556 | 183556 | 2020-05-27 | Beaver | Oklahoma | 40007 | 24 | 0 |
186613 | 186613 | 2020-05-28 | Beaver | Oklahoma | 40007 | 24 | 0 |
189673 | 189673 | 2020-05-29 | Beaver | Oklahoma | 40007 | 24 | 0 |
192738 | 192738 | 2020-05-30 | Beaver | Oklahoma | 40007 | 24 | 0 |
195807 | 195807 | 2020-05-31 | Beaver | Oklahoma | 40007 | 24 | 0 |
198880 | 198880 | 2020-06-01 | Beaver | Oklahoma | 40007 | 24 | 0 |
201955 | 201955 | 2020-06-02 | Beaver | Oklahoma | 40007 | 24 | 0 |
205032 | 205032 | 2020-06-03 | Beaver | Oklahoma | 40007 | 24 | 0 |
208113 | 208113 | 2020-06-04 | Beaver | Oklahoma | 40007 | 24 | 0 |
211195 | 211195 | 2020-06-05 | Beaver | Oklahoma | 40007 | 24 | 0 |
214281 | 214281 | 2020-06-06 | Beaver | Oklahoma | 40007 | 24 | 0 |
217371 | 217371 | 2020-06-07 | Beaver | Oklahoma | 40007 | 27 | 0 |
220463 | 220463 | 2020-06-08 | Beaver | Oklahoma | 40007 | 27 | 0 |
223558 | 223558 | 2020-06-09 | Beaver | Oklahoma | 40007 | 27 | 0 |
226658 | 226658 | 2020-06-10 | Beaver | Oklahoma | 40007 | 27 | 0 |
229762 | 229762 | 2020-06-11 | Beaver | Oklahoma | 40007 | 29 | 0 |
232867 | 232867 | 2020-06-12 | Beaver | Oklahoma | 40007 | 30 | 0 |
235972 | 235972 | 2020-06-13 | Beaver | Oklahoma | 40007 | 30 | 0 |
239080 | 239080 | 2020-06-14 | Beaver | Oklahoma | 40007 | 30 | 0 |
242189 | 242189 | 2020-06-15 | Beaver | Oklahoma | 40007 | 30 | 0 |
245301 | 245301 | 2020-06-16 | Beaver | Oklahoma | 40007 | 30 | 0 |
248414 | 248414 | 2020-06-17 | Beaver | Oklahoma | 40007 | 30 | 0 |
251529 | 251529 | 2020-06-18 | Beaver | Oklahoma | 40007 | 30 | 0 |
254644 | 254644 | 2020-06-19 | Beaver | Oklahoma | 40007 | 30 | 0 |
257770 | 257770 | 2020-06-20 | Beaver | Oklahoma | 40007 | 30 | 0 |
260896 | 260896 | 2020-06-21 | Beaver | Oklahoma | 40007 | 30 | 0 |
264024 | 264024 | 2020-06-22 | Beaver | Oklahoma | 40007 | 30 | 0 |
267152 | 267152 | 2020-06-23 | Beaver | Oklahoma | 40007 | 30 | 0 |
270286 | 270286 | 2020-06-24 | Beaver | Oklahoma | 40007 | 30 | 0 |
273425 | 273425 | 2020-06-25 | Beaver | Oklahoma | 40007 | 30 | 0 |
276572 | 276572 | 2020-06-26 | Beaver | Oklahoma | 40007 | 30 | 0 |
279720 | 279720 | 2020-06-27 | Beaver | Oklahoma | 40007 | 30 | 0 |
282866 | 282866 | 2020-06-28 | Beaver | Oklahoma | 40007 | 30 | 0 |
286011 | 286011 | 2020-06-29 | Beaver | Oklahoma | 40007 | 30 | 0 |
289161 | 289161 | 2020-06-30 | Beaver | Oklahoma | 40007 | 30 | 0 |
292313 | 292313 | 2020-07-01 | Beaver | Oklahoma | 40007 | 30 | 0 |
295469 | 295469 | 2020-07-02 | Beaver | Oklahoma | 40007 | 30 | 0 |
298628 | 298628 | 2020-07-03 | Beaver | Oklahoma | 40007 | 30 | 0 |
301791 | 301791 | 2020-07-04 | Beaver | Oklahoma | 40007 | 32 | 0 |
304954 | 304954 | 2020-07-05 | Beaver | Oklahoma | 40007 | 32 | 0 |
308121 | 308121 | 2020-07-06 | Beaver | Oklahoma | 40007 | 32 | 0 |
311290 | 311290 | 2020-07-07 | Beaver | Oklahoma | 40007 | 32 | 0 |
314462 | 314462 | 2020-07-08 | Beaver | Oklahoma | 40007 | 32 | 0 |
317635 | 317635 | 2020-07-09 | Beaver | Oklahoma | 40007 | 32 | 0 |
320812 | 320812 | 2020-07-10 | Beaver | Oklahoma | 40007 | 32 | 0 |
323992 | 323992 | 2020-07-11 | Beaver | Oklahoma | 40007 | 32 | 0 |
327177 | 327177 | 2020-07-12 | Beaver | Oklahoma | 40007 | 32 | 0 |
330364 | 330364 | 2020-07-13 | Beaver | Oklahoma | 40007 | 32 | 0 |
333556 | 333556 | 2020-07-14 | Beaver | Oklahoma | 40007 | 32 | 0 |
336750 | 336750 | 2020-07-15 | Beaver | Oklahoma | 40007 | 32 | 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);