ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,561 rows where county = "Bryan" 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 |
---|---|---|---|---|---|---|---|
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 |
9705 | 9705 | 2020-03-24 | Bryan | Georgia | 13029 | 2 | 0 |
27683 | 27683 | 2020-04-02 | Bryan | Oklahoma | 40013 | 2 | 0 |
11080 | 11080 | 2020-03-25 | Bryan | Georgia | 13029 | 3 | 0 |
12628 | 12628 | 2020-03-26 | Bryan | Georgia | 13029 | 3 | 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 |
14299 | 14299 | 2020-03-27 | Bryan | Georgia | 13029 | 5 | 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 |
16084 | 16084 | 2020-03-28 | Bryan | Georgia | 13029 | 7 | 0 |
17980 | 17980 | 2020-03-29 | Bryan | Georgia | 13029 | 7 | 0 |
19965 | 19965 | 2020-03-30 | Bryan | Georgia | 13029 | 7 | 0 |
22044 | 22044 | 2020-03-31 | Bryan | Georgia | 13029 | 7 | 0 |
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 |
24207 | 24207 | 2020-04-01 | Bryan | Georgia | 13029 | 9 | 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 |
26438 | 26438 | 2020-04-02 | Bryan | Georgia | 13029 | 11 | 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 |
28741 | 28741 | 2020-04-03 | Bryan | Georgia | 13029 | 15 | 1 |
31101 | 31101 | 2020-04-04 | Bryan | Georgia | 13029 | 15 | 1 |
33507 | 33507 | 2020-04-05 | Bryan | Georgia | 13029 | 17 | 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 |
35955 | 35955 | 2020-04-06 | Bryan | Georgia | 13029 | 24 | 2 |
189676 | 189676 | 2020-05-29 | Bryan | Oklahoma | 40013 | 24 | 1 |
40991 | 40991 | 2020-04-08 | Bryan | Georgia | 13029 | 25 | 2 |
38447 | 38447 | 2020-04-07 | Bryan | Georgia | 13029 | 26 | 2 |
192741 | 192741 | 2020-05-30 | Bryan | Oklahoma | 40013 | 26 | 1 |
195810 | 195810 | 2020-05-31 | Bryan | Oklahoma | 40013 | 26 | 1 |
43565 | 43565 | 2020-04-09 | Bryan | Georgia | 13029 | 28 | 2 |
48797 | 48797 | 2020-04-11 | Bryan | Georgia | 13029 | 28 | 1 |
46167 | 46167 | 2020-04-10 | Bryan | Georgia | 13029 | 29 | 2 |
51458 | 51458 | 2020-04-12 | Bryan | Georgia | 13029 | 29 | 1 |
198883 | 198883 | 2020-06-01 | Bryan | Oklahoma | 40013 | 29 | 1 |
54138 | 54138 | 2020-04-13 | Bryan | Georgia | 13029 | 30 | 2 |
56830 | 56830 | 2020-04-14 | Bryan | Georgia | 13029 | 30 | 2 |
59537 | 59537 | 2020-04-15 | Bryan | Georgia | 13029 | 30 | 2 |
62257 | 62257 | 2020-04-16 | Bryan | Georgia | 13029 | 30 | 2 |
64990 | 64990 | 2020-04-17 | Bryan | Georgia | 13029 | 31 | 2 |
201958 | 201958 | 2020-06-02 | Bryan | Oklahoma | 40013 | 31 | 1 |
67738 | 67738 | 2020-04-18 | Bryan | Georgia | 13029 | 32 | 2 |
205035 | 205035 | 2020-06-03 | Bryan | Oklahoma | 40013 | 32 | 1 |
70500 | 70500 | 2020-04-19 | Bryan | Georgia | 13029 | 33 | 2 |
208116 | 208116 | 2020-06-04 | Bryan | Oklahoma | 40013 | 33 | 1 |
73269 | 73269 | 2020-04-20 | Bryan | Georgia | 13029 | 34 | 2 |
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);