ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 40051 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4953 | 4953 | 2020-03-19 | Grady | Oklahoma | 40051 | 1 | 0 |
5820 | 5820 | 2020-03-20 | Grady | Oklahoma | 40051 | 1 | 0 |
6821 | 6821 | 2020-03-21 | Grady | Oklahoma | 40051 | 1 | 0 |
7934 | 7934 | 2020-03-22 | Grady | Oklahoma | 40051 | 1 | 0 |
9142 | 9142 | 2020-03-23 | Grady | Oklahoma | 40051 | 1 | 0 |
10458 | 10458 | 2020-03-24 | Grady | Oklahoma | 40051 | 1 | 0 |
11916 | 11916 | 2020-03-25 | Grady | Oklahoma | 40051 | 1 | 0 |
13528 | 13528 | 2020-03-26 | Grady | Oklahoma | 40051 | 2 | 0 |
15270 | 15270 | 2020-03-27 | Grady | Oklahoma | 40051 | 2 | 0 |
17115 | 17115 | 2020-03-28 | Grady | Oklahoma | 40051 | 2 | 0 |
19050 | 19050 | 2020-03-29 | Grady | Oklahoma | 40051 | 2 | 0 |
21099 | 21099 | 2020-03-30 | Grady | Oklahoma | 40051 | 3 | 0 |
23232 | 23232 | 2020-03-31 | Grady | Oklahoma | 40051 | 2 | 0 |
25428 | 25428 | 2020-04-01 | Grady | Oklahoma | 40051 | 3 | 0 |
27698 | 27698 | 2020-04-02 | Grady | Oklahoma | 40051 | 3 | 0 |
30027 | 30027 | 2020-04-03 | Grady | Oklahoma | 40051 | 5 | 0 |
32416 | 32416 | 2020-04-04 | Grady | Oklahoma | 40051 | 6 | 0 |
34850 | 34850 | 2020-04-05 | Grady | Oklahoma | 40051 | 7 | 0 |
37323 | 37323 | 2020-04-06 | Grady | Oklahoma | 40051 | 8 | 0 |
39843 | 39843 | 2020-04-07 | Grady | Oklahoma | 40051 | 9 | 0 |
42403 | 42403 | 2020-04-08 | Grady | Oklahoma | 40051 | 9 | 0 |
44989 | 44989 | 2020-04-09 | Grady | Oklahoma | 40051 | 9 | 0 |
47604 | 47604 | 2020-04-10 | Grady | Oklahoma | 40051 | 11 | 0 |
50260 | 50260 | 2020-04-11 | Grady | Oklahoma | 40051 | 11 | 0 |
52933 | 52933 | 2020-04-12 | Grady | Oklahoma | 40051 | 11 | 0 |
55618 | 55618 | 2020-04-13 | Grady | Oklahoma | 40051 | 11 | 0 |
58319 | 58319 | 2020-04-14 | Grady | Oklahoma | 40051 | 12 | 0 |
61034 | 61034 | 2020-04-15 | Grady | Oklahoma | 40051 | 14 | 1 |
63760 | 63760 | 2020-04-16 | Grady | Oklahoma | 40051 | 16 | 1 |
66503 | 66503 | 2020-04-17 | Grady | Oklahoma | 40051 | 19 | 1 |
69260 | 69260 | 2020-04-18 | Grady | Oklahoma | 40051 | 20 | 1 |
72027 | 72027 | 2020-04-19 | Grady | Oklahoma | 40051 | 20 | 1 |
74802 | 74802 | 2020-04-20 | Grady | Oklahoma | 40051 | 23 | 1 |
77584 | 77584 | 2020-04-21 | Grady | Oklahoma | 40051 | 23 | 1 |
80374 | 80374 | 2020-04-22 | Grady | Oklahoma | 40051 | 25 | 1 |
83173 | 83173 | 2020-04-23 | Grady | Oklahoma | 40051 | 31 | 1 |
85977 | 85977 | 2020-04-24 | Grady | Oklahoma | 40051 | 31 | 1 |
88791 | 88791 | 2020-04-25 | Grady | Oklahoma | 40051 | 34 | 1 |
91607 | 91607 | 2020-04-26 | Grady | Oklahoma | 40051 | 34 | 1 |
94433 | 94433 | 2020-04-27 | Grady | Oklahoma | 40051 | 34 | 1 |
97271 | 97271 | 2020-04-28 | Grady | Oklahoma | 40051 | 35 | 1 |
100120 | 100120 | 2020-04-29 | Grady | Oklahoma | 40051 | 35 | 1 |
102973 | 102973 | 2020-04-30 | Grady | Oklahoma | 40051 | 36 | 2 |
105836 | 105836 | 2020-05-01 | Grady | Oklahoma | 40051 | 36 | 2 |
108703 | 108703 | 2020-05-02 | Grady | Oklahoma | 40051 | 38 | 2 |
111577 | 111577 | 2020-05-03 | Grady | Oklahoma | 40051 | 39 | 2 |
114459 | 114459 | 2020-05-04 | Grady | Oklahoma | 40051 | 40 | 2 |
117340 | 117340 | 2020-05-05 | Grady | Oklahoma | 40051 | 40 | 2 |
120301 | 120301 | 2020-05-06 | Grady | Oklahoma | 40051 | 41 | 2 |
123278 | 123278 | 2020-05-07 | Grady | Oklahoma | 40051 | 41 | 2 |
126261 | 126261 | 2020-05-08 | Grady | Oklahoma | 40051 | 42 | 2 |
129250 | 129250 | 2020-05-09 | Grady | Oklahoma | 40051 | 45 | 2 |
132239 | 132239 | 2020-05-10 | Grady | Oklahoma | 40051 | 45 | 2 |
135230 | 135230 | 2020-05-11 | Grady | Oklahoma | 40051 | 46 | 2 |
138220 | 138220 | 2020-05-12 | Grady | Oklahoma | 40051 | 52 | 2 |
141216 | 141216 | 2020-05-13 | Grady | Oklahoma | 40051 | 54 | 2 |
144211 | 144211 | 2020-05-14 | Grady | Oklahoma | 40051 | 58 | 2 |
147212 | 147212 | 2020-05-15 | Grady | Oklahoma | 40051 | 60 | 2 |
150219 | 150219 | 2020-05-16 | Grady | Oklahoma | 40051 | 64 | 2 |
153230 | 153230 | 2020-05-17 | Grady | Oklahoma | 40051 | 64 | 2 |
156247 | 156247 | 2020-05-18 | Grady | Oklahoma | 40051 | 64 | 2 |
159268 | 159268 | 2020-05-19 | Grady | Oklahoma | 40051 | 65 | 2 |
162295 | 162295 | 2020-05-20 | Grady | Oklahoma | 40051 | 68 | 2 |
165324 | 165324 | 2020-05-21 | Grady | Oklahoma | 40051 | 71 | 2 |
168360 | 168360 | 2020-05-22 | Grady | Oklahoma | 40051 | 72 | 2 |
171399 | 171399 | 2020-05-23 | Grady | Oklahoma | 40051 | 73 | 2 |
174441 | 174441 | 2020-05-24 | Grady | Oklahoma | 40051 | 76 | 2 |
177485 | 177485 | 2020-05-25 | Grady | Oklahoma | 40051 | 79 | 3 |
180528 | 180528 | 2020-05-26 | Grady | Oklahoma | 40051 | 80 | 3 |
183577 | 183577 | 2020-05-27 | Grady | Oklahoma | 40051 | 83 | 3 |
186634 | 186634 | 2020-05-28 | Grady | Oklahoma | 40051 | 83 | 3 |
189694 | 189694 | 2020-05-29 | Grady | Oklahoma | 40051 | 85 | 3 |
192759 | 192759 | 2020-05-30 | Grady | Oklahoma | 40051 | 92 | 3 |
195828 | 195828 | 2020-05-31 | Grady | Oklahoma | 40051 | 97 | 3 |
198901 | 198901 | 2020-06-01 | Grady | Oklahoma | 40051 | 97 | 3 |
201976 | 201976 | 2020-06-02 | Grady | Oklahoma | 40051 | 99 | 3 |
205053 | 205053 | 2020-06-03 | Grady | Oklahoma | 40051 | 100 | 3 |
208134 | 208134 | 2020-06-04 | Grady | Oklahoma | 40051 | 104 | 3 |
211216 | 211216 | 2020-06-05 | Grady | Oklahoma | 40051 | 107 | 3 |
214302 | 214302 | 2020-06-06 | Grady | Oklahoma | 40051 | 107 | 3 |
217392 | 217392 | 2020-06-07 | Grady | Oklahoma | 40051 | 115 | 3 |
220484 | 220484 | 2020-06-08 | Grady | Oklahoma | 40051 | 115 | 3 |
223579 | 223579 | 2020-06-09 | Grady | Oklahoma | 40051 | 115 | 3 |
226679 | 226679 | 2020-06-10 | Grady | Oklahoma | 40051 | 115 | 3 |
229783 | 229783 | 2020-06-11 | Grady | Oklahoma | 40051 | 115 | 3 |
232888 | 232888 | 2020-06-12 | Grady | Oklahoma | 40051 | 116 | 3 |
235993 | 235993 | 2020-06-13 | Grady | Oklahoma | 40051 | 116 | 3 |
239101 | 239101 | 2020-06-14 | Grady | Oklahoma | 40051 | 117 | 3 |
242210 | 242210 | 2020-06-15 | Grady | Oklahoma | 40051 | 118 | 3 |
245322 | 245322 | 2020-06-16 | Grady | Oklahoma | 40051 | 118 | 4 |
248435 | 248435 | 2020-06-17 | Grady | Oklahoma | 40051 | 120 | 4 |
251550 | 251550 | 2020-06-18 | Grady | Oklahoma | 40051 | 122 | 4 |
254665 | 254665 | 2020-06-19 | Grady | Oklahoma | 40051 | 123 | 4 |
257791 | 257791 | 2020-06-20 | Grady | Oklahoma | 40051 | 123 | 4 |
260918 | 260918 | 2020-06-21 | Grady | Oklahoma | 40051 | 125 | 5 |
264046 | 264046 | 2020-06-22 | Grady | Oklahoma | 40051 | 125 | 5 |
267174 | 267174 | 2020-06-23 | Grady | Oklahoma | 40051 | 125 | 5 |
270308 | 270308 | 2020-06-24 | Grady | Oklahoma | 40051 | 124 | 5 |
273447 | 273447 | 2020-06-25 | Grady | Oklahoma | 40051 | 126 | 5 |
276594 | 276594 | 2020-06-26 | Grady | Oklahoma | 40051 | 128 | 5 |
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);