ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Bryan" 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 |
---|---|---|---|---|---|---|---|
11908 | 11908 | 2020-03-25 | Bryan | Oklahoma | 40013 | 1 | 0 |
13518 | 13518 | 2020-03-26 | Bryan | Oklahoma | 40013 | 1 | 0 |
15257 | 15257 | 2020-03-27 | Bryan | Oklahoma | 40013 | 1 | 0 |
17102 | 17102 | 2020-03-28 | Bryan | Oklahoma | 40013 | 1 | 0 |
19036 | 19036 | 2020-03-29 | Bryan | Oklahoma | 40013 | 1 | 0 |
21084 | 21084 | 2020-03-30 | Bryan | Oklahoma | 40013 | 1 | 0 |
23217 | 23217 | 2020-03-31 | Bryan | Oklahoma | 40013 | 1 | 0 |
25413 | 25413 | 2020-04-01 | Bryan | Oklahoma | 40013 | 1 | 0 |
27683 | 27683 | 2020-04-02 | Bryan | Oklahoma | 40013 | 2 | 0 |
30012 | 30012 | 2020-04-03 | Bryan | Oklahoma | 40013 | 3 | 0 |
32401 | 32401 | 2020-04-04 | Bryan | Oklahoma | 40013 | 3 | 0 |
34835 | 34835 | 2020-04-05 | Bryan | Oklahoma | 40013 | 3 | 0 |
37308 | 37308 | 2020-04-06 | Bryan | Oklahoma | 40013 | 3 | 0 |
39827 | 39827 | 2020-04-07 | Bryan | Oklahoma | 40013 | 3 | 0 |
42387 | 42387 | 2020-04-08 | Bryan | Oklahoma | 40013 | 3 | 0 |
44973 | 44973 | 2020-04-09 | Bryan | Oklahoma | 40013 | 3 | 0 |
47588 | 47588 | 2020-04-10 | Bryan | Oklahoma | 40013 | 3 | 0 |
50244 | 50244 | 2020-04-11 | Bryan | Oklahoma | 40013 | 3 | 0 |
52917 | 52917 | 2020-04-12 | Bryan | Oklahoma | 40013 | 3 | 0 |
55602 | 55602 | 2020-04-13 | Bryan | Oklahoma | 40013 | 4 | 0 |
58303 | 58303 | 2020-04-14 | Bryan | Oklahoma | 40013 | 4 | 0 |
61018 | 61018 | 2020-04-15 | Bryan | Oklahoma | 40013 | 5 | 0 |
63744 | 63744 | 2020-04-16 | Bryan | Oklahoma | 40013 | 5 | 0 |
66487 | 66487 | 2020-04-17 | Bryan | Oklahoma | 40013 | 5 | 0 |
69244 | 69244 | 2020-04-18 | Bryan | Oklahoma | 40013 | 5 | 0 |
72011 | 72011 | 2020-04-19 | Bryan | Oklahoma | 40013 | 5 | 0 |
74786 | 74786 | 2020-04-20 | Bryan | Oklahoma | 40013 | 5 | 0 |
77567 | 77567 | 2020-04-21 | Bryan | Oklahoma | 40013 | 6 | 1 |
80357 | 80357 | 2020-04-22 | Bryan | Oklahoma | 40013 | 6 | 1 |
83156 | 83156 | 2020-04-23 | Bryan | Oklahoma | 40013 | 6 | 1 |
85960 | 85960 | 2020-04-24 | Bryan | Oklahoma | 40013 | 6 | 1 |
88774 | 88774 | 2020-04-25 | Bryan | Oklahoma | 40013 | 6 | 1 |
91590 | 91590 | 2020-04-26 | Bryan | Oklahoma | 40013 | 6 | 1 |
94416 | 94416 | 2020-04-27 | Bryan | Oklahoma | 40013 | 6 | 1 |
97254 | 97254 | 2020-04-28 | Bryan | Oklahoma | 40013 | 8 | 1 |
100103 | 100103 | 2020-04-29 | Bryan | Oklahoma | 40013 | 8 | 1 |
102956 | 102956 | 2020-04-30 | Bryan | Oklahoma | 40013 | 8 | 1 |
105819 | 105819 | 2020-05-01 | Bryan | Oklahoma | 40013 | 8 | 1 |
108686 | 108686 | 2020-05-02 | Bryan | Oklahoma | 40013 | 9 | 1 |
111560 | 111560 | 2020-05-03 | Bryan | Oklahoma | 40013 | 9 | 1 |
114442 | 114442 | 2020-05-04 | Bryan | Oklahoma | 40013 | 9 | 1 |
117323 | 117323 | 2020-05-05 | Bryan | Oklahoma | 40013 | 9 | 1 |
120284 | 120284 | 2020-05-06 | Bryan | Oklahoma | 40013 | 12 | 1 |
123261 | 123261 | 2020-05-07 | Bryan | Oklahoma | 40013 | 12 | 1 |
126244 | 126244 | 2020-05-08 | Bryan | Oklahoma | 40013 | 12 | 1 |
129233 | 129233 | 2020-05-09 | Bryan | Oklahoma | 40013 | 12 | 1 |
132222 | 132222 | 2020-05-10 | Bryan | Oklahoma | 40013 | 12 | 1 |
135213 | 135213 | 2020-05-11 | Bryan | Oklahoma | 40013 | 12 | 1 |
138203 | 138203 | 2020-05-12 | Bryan | Oklahoma | 40013 | 12 | 1 |
141199 | 141199 | 2020-05-13 | Bryan | Oklahoma | 40013 | 12 | 1 |
144194 | 144194 | 2020-05-14 | Bryan | Oklahoma | 40013 | 12 | 1 |
147195 | 147195 | 2020-05-15 | Bryan | Oklahoma | 40013 | 12 | 1 |
150202 | 150202 | 2020-05-16 | Bryan | Oklahoma | 40013 | 13 | 1 |
153213 | 153213 | 2020-05-17 | Bryan | Oklahoma | 40013 | 14 | 1 |
156230 | 156230 | 2020-05-18 | Bryan | Oklahoma | 40013 | 17 | 1 |
159250 | 159250 | 2020-05-19 | Bryan | Oklahoma | 40013 | 19 | 1 |
162277 | 162277 | 2020-05-20 | Bryan | Oklahoma | 40013 | 19 | 1 |
165306 | 165306 | 2020-05-21 | Bryan | Oklahoma | 40013 | 19 | 1 |
168342 | 168342 | 2020-05-22 | Bryan | Oklahoma | 40013 | 19 | 1 |
171381 | 171381 | 2020-05-23 | Bryan | Oklahoma | 40013 | 21 | 1 |
174423 | 174423 | 2020-05-24 | Bryan | Oklahoma | 40013 | 22 | 1 |
177467 | 177467 | 2020-05-25 | Bryan | Oklahoma | 40013 | 22 | 1 |
180510 | 180510 | 2020-05-26 | Bryan | Oklahoma | 40013 | 22 | 1 |
183559 | 183559 | 2020-05-27 | Bryan | Oklahoma | 40013 | 23 | 1 |
186616 | 186616 | 2020-05-28 | Bryan | Oklahoma | 40013 | 23 | 1 |
189676 | 189676 | 2020-05-29 | Bryan | Oklahoma | 40013 | 24 | 1 |
192741 | 192741 | 2020-05-30 | Bryan | Oklahoma | 40013 | 26 | 1 |
195810 | 195810 | 2020-05-31 | Bryan | Oklahoma | 40013 | 26 | 1 |
198883 | 198883 | 2020-06-01 | Bryan | Oklahoma | 40013 | 29 | 1 |
201958 | 201958 | 2020-06-02 | Bryan | Oklahoma | 40013 | 31 | 1 |
205035 | 205035 | 2020-06-03 | Bryan | Oklahoma | 40013 | 32 | 1 |
208116 | 208116 | 2020-06-04 | Bryan | Oklahoma | 40013 | 33 | 1 |
211198 | 211198 | 2020-06-05 | Bryan | Oklahoma | 40013 | 35 | 1 |
214284 | 214284 | 2020-06-06 | Bryan | Oklahoma | 40013 | 35 | 1 |
217374 | 217374 | 2020-06-07 | Bryan | Oklahoma | 40013 | 36 | 1 |
220466 | 220466 | 2020-06-08 | Bryan | Oklahoma | 40013 | 36 | 1 |
223561 | 223561 | 2020-06-09 | Bryan | Oklahoma | 40013 | 40 | 1 |
226661 | 226661 | 2020-06-10 | Bryan | Oklahoma | 40013 | 46 | 1 |
229765 | 229765 | 2020-06-11 | Bryan | Oklahoma | 40013 | 47 | 1 |
232870 | 232870 | 2020-06-12 | Bryan | Oklahoma | 40013 | 49 | 1 |
235975 | 235975 | 2020-06-13 | Bryan | Oklahoma | 40013 | 48 | 1 |
239083 | 239083 | 2020-06-14 | Bryan | Oklahoma | 40013 | 48 | 1 |
242192 | 242192 | 2020-06-15 | Bryan | Oklahoma | 40013 | 48 | 1 |
245304 | 245304 | 2020-06-16 | Bryan | Oklahoma | 40013 | 51 | 1 |
248417 | 248417 | 2020-06-17 | Bryan | Oklahoma | 40013 | 57 | 1 |
251532 | 251532 | 2020-06-18 | Bryan | Oklahoma | 40013 | 64 | 1 |
254647 | 254647 | 2020-06-19 | Bryan | Oklahoma | 40013 | 68 | 1 |
257773 | 257773 | 2020-06-20 | Bryan | Oklahoma | 40013 | 69 | 1 |
260899 | 260899 | 2020-06-21 | Bryan | Oklahoma | 40013 | 71 | 1 |
264027 | 264027 | 2020-06-22 | Bryan | Oklahoma | 40013 | 72 | 1 |
267155 | 267155 | 2020-06-23 | Bryan | Oklahoma | 40013 | 72 | 1 |
270289 | 270289 | 2020-06-24 | Bryan | Oklahoma | 40013 | 75 | 1 |
273428 | 273428 | 2020-06-25 | Bryan | Oklahoma | 40013 | 78 | 1 |
276575 | 276575 | 2020-06-26 | Bryan | Oklahoma | 40013 | 83 | 1 |
279723 | 279723 | 2020-06-27 | Bryan | Oklahoma | 40013 | 85 | 1 |
282869 | 282869 | 2020-06-28 | Bryan | Oklahoma | 40013 | 85 | 1 |
286014 | 286014 | 2020-06-29 | Bryan | Oklahoma | 40013 | 86 | 1 |
289164 | 289164 | 2020-06-30 | Bryan | Oklahoma | 40013 | 94 | 1 |
292316 | 292316 | 2020-07-01 | Bryan | Oklahoma | 40013 | 100 | 1 |
295472 | 295472 | 2020-07-02 | Bryan | Oklahoma | 40013 | 108 | 1 |
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);