ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Warren" and fips = 42123 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11993 | 11993 | 2020-03-25 | Warren | Pennsylvania | 42123 | 1 | 0 |
13615 | 13615 | 2020-03-26 | Warren | Pennsylvania | 42123 | 1 | 0 |
15362 | 15362 | 2020-03-27 | Warren | Pennsylvania | 42123 | 1 | 0 |
17216 | 17216 | 2020-03-28 | Warren | Pennsylvania | 42123 | 1 | 0 |
19156 | 19156 | 2020-03-29 | Warren | Pennsylvania | 42123 | 1 | 0 |
21207 | 21207 | 2020-03-30 | Warren | Pennsylvania | 42123 | 1 | 0 |
23344 | 23344 | 2020-03-31 | Warren | Pennsylvania | 42123 | 1 | 0 |
25541 | 25541 | 2020-04-01 | Warren | Pennsylvania | 42123 | 1 | 0 |
27814 | 27814 | 2020-04-02 | Warren | Pennsylvania | 42123 | 1 | 0 |
30149 | 30149 | 2020-04-03 | Warren | Pennsylvania | 42123 | 1 | 0 |
32539 | 32539 | 2020-04-04 | Warren | Pennsylvania | 42123 | 1 | 0 |
34975 | 34975 | 2020-04-05 | Warren | Pennsylvania | 42123 | 1 | 0 |
37450 | 37450 | 2020-04-06 | Warren | Pennsylvania | 42123 | 1 | 0 |
39973 | 39973 | 2020-04-07 | Warren | Pennsylvania | 42123 | 1 | 0 |
42533 | 42533 | 2020-04-08 | Warren | Pennsylvania | 42123 | 1 | 0 |
45119 | 45119 | 2020-04-09 | Warren | Pennsylvania | 42123 | 1 | 0 |
47736 | 47736 | 2020-04-10 | Warren | Pennsylvania | 42123 | 1 | 0 |
50393 | 50393 | 2020-04-11 | Warren | Pennsylvania | 42123 | 1 | 0 |
53066 | 53066 | 2020-04-12 | Warren | Pennsylvania | 42123 | 1 | 0 |
55751 | 55751 | 2020-04-13 | Warren | Pennsylvania | 42123 | 1 | 0 |
58454 | 58454 | 2020-04-14 | Warren | Pennsylvania | 42123 | 1 | 0 |
61169 | 61169 | 2020-04-15 | Warren | Pennsylvania | 42123 | 1 | 0 |
63895 | 63895 | 2020-04-16 | Warren | Pennsylvania | 42123 | 1 | 0 |
66641 | 66641 | 2020-04-17 | Warren | Pennsylvania | 42123 | 1 | 0 |
69399 | 69399 | 2020-04-18 | Warren | Pennsylvania | 42123 | 1 | 0 |
72166 | 72166 | 2020-04-19 | Warren | Pennsylvania | 42123 | 1 | 0 |
74941 | 74941 | 2020-04-20 | Warren | Pennsylvania | 42123 | 1 | 0 |
77723 | 77723 | 2020-04-21 | Warren | Pennsylvania | 42123 | 2 | 1 |
80513 | 80513 | 2020-04-22 | Warren | Pennsylvania | 42123 | 2 | 1 |
83312 | 83312 | 2020-04-23 | Warren | Pennsylvania | 42123 | 1 | 1 |
86116 | 86116 | 2020-04-24 | Warren | Pennsylvania | 42123 | 1 | 1 |
88930 | 88930 | 2020-04-25 | Warren | Pennsylvania | 42123 | 1 | 1 |
91746 | 91746 | 2020-04-26 | Warren | Pennsylvania | 42123 | 1 | 1 |
94573 | 94573 | 2020-04-27 | Warren | Pennsylvania | 42123 | 1 | 1 |
97412 | 97412 | 2020-04-28 | Warren | Pennsylvania | 42123 | 1 | 1 |
100261 | 100261 | 2020-04-29 | Warren | Pennsylvania | 42123 | 1 | 1 |
103114 | 103114 | 2020-04-30 | Warren | Pennsylvania | 42123 | 1 | 1 |
105977 | 105977 | 2020-05-01 | Warren | Pennsylvania | 42123 | 1 | 1 |
108844 | 108844 | 2020-05-02 | Warren | Pennsylvania | 42123 | 1 | 1 |
111718 | 111718 | 2020-05-03 | Warren | Pennsylvania | 42123 | 1 | 1 |
114600 | 114600 | 2020-05-04 | Warren | Pennsylvania | 42123 | 1 | 1 |
117481 | 117481 | 2020-05-05 | Warren | Pennsylvania | 42123 | 1 | 1 |
120443 | 120443 | 2020-05-06 | Warren | Pennsylvania | 42123 | 1 | 1 |
123420 | 123420 | 2020-05-07 | Warren | Pennsylvania | 42123 | 1 | 1 |
126403 | 126403 | 2020-05-08 | Warren | Pennsylvania | 42123 | 1 | 1 |
129392 | 129392 | 2020-05-09 | Warren | Pennsylvania | 42123 | 1 | 1 |
132381 | 132381 | 2020-05-10 | Warren | Pennsylvania | 42123 | 1 | 1 |
135372 | 135372 | 2020-05-11 | Warren | Pennsylvania | 42123 | 1 | 1 |
138362 | 138362 | 2020-05-12 | Warren | Pennsylvania | 42123 | 1 | 1 |
141358 | 141358 | 2020-05-13 | Warren | Pennsylvania | 42123 | 2 | 1 |
144354 | 144354 | 2020-05-14 | Warren | Pennsylvania | 42123 | 2 | 1 |
147355 | 147355 | 2020-05-15 | Warren | Pennsylvania | 42123 | 2 | 1 |
150362 | 150362 | 2020-05-16 | Warren | Pennsylvania | 42123 | 2 | 1 |
153373 | 153373 | 2020-05-17 | Warren | Pennsylvania | 42123 | 2 | 1 |
156390 | 156390 | 2020-05-18 | Warren | Pennsylvania | 42123 | 2 | 1 |
159411 | 159411 | 2020-05-19 | Warren | Pennsylvania | 42123 | 2 | 1 |
162438 | 162438 | 2020-05-20 | Warren | Pennsylvania | 42123 | 2 | 0 |
165467 | 165467 | 2020-05-21 | Warren | Pennsylvania | 42123 | 3 | 0 |
168503 | 168503 | 2020-05-22 | Warren | Pennsylvania | 42123 | 3 | 0 |
171542 | 171542 | 2020-05-23 | Warren | Pennsylvania | 42123 | 3 | 0 |
174584 | 174584 | 2020-05-24 | Warren | Pennsylvania | 42123 | 3 | 0 |
177628 | 177628 | 2020-05-25 | Warren | Pennsylvania | 42123 | 3 | 0 |
180671 | 180671 | 2020-05-26 | Warren | Pennsylvania | 42123 | 3 | 0 |
183721 | 183721 | 2020-05-27 | Warren | Pennsylvania | 42123 | 3 | 0 |
186778 | 186778 | 2020-05-28 | Warren | Pennsylvania | 42123 | 3 | 0 |
189839 | 189839 | 2020-05-29 | Warren | Pennsylvania | 42123 | 3 | 0 |
192904 | 192904 | 2020-05-30 | Warren | Pennsylvania | 42123 | 3 | 0 |
195973 | 195973 | 2020-05-31 | Warren | Pennsylvania | 42123 | 3 | 0 |
199046 | 199046 | 2020-06-01 | Warren | Pennsylvania | 42123 | 3 | 0 |
202121 | 202121 | 2020-06-02 | Warren | Pennsylvania | 42123 | 3 | 0 |
205198 | 205198 | 2020-06-03 | Warren | Pennsylvania | 42123 | 4 | 0 |
208279 | 208279 | 2020-06-04 | Warren | Pennsylvania | 42123 | 5 | 0 |
211361 | 211361 | 2020-06-05 | Warren | Pennsylvania | 42123 | 5 | 0 |
214447 | 214447 | 2020-06-06 | Warren | Pennsylvania | 42123 | 5 | 0 |
217537 | 217537 | 2020-06-07 | Warren | Pennsylvania | 42123 | 5 | 0 |
220629 | 220629 | 2020-06-08 | Warren | Pennsylvania | 42123 | 5 | 0 |
223724 | 223724 | 2020-06-09 | Warren | Pennsylvania | 42123 | 5 | 0 |
226824 | 226824 | 2020-06-10 | Warren | Pennsylvania | 42123 | 5 | 0 |
229928 | 229928 | 2020-06-11 | Warren | Pennsylvania | 42123 | 5 | 0 |
233033 | 233033 | 2020-06-12 | Warren | Pennsylvania | 42123 | 5 | 0 |
236138 | 236138 | 2020-06-13 | Warren | Pennsylvania | 42123 | 5 | 0 |
239246 | 239246 | 2020-06-14 | Warren | Pennsylvania | 42123 | 5 | 0 |
242355 | 242355 | 2020-06-15 | Warren | Pennsylvania | 42123 | 5 | 0 |
245467 | 245467 | 2020-06-16 | Warren | Pennsylvania | 42123 | 5 | 0 |
248580 | 248580 | 2020-06-17 | Warren | Pennsylvania | 42123 | 5 | 0 |
251695 | 251695 | 2020-06-18 | Warren | Pennsylvania | 42123 | 5 | 0 |
254810 | 254810 | 2020-06-19 | Warren | Pennsylvania | 42123 | 5 | 0 |
257936 | 257936 | 2020-06-20 | Warren | Pennsylvania | 42123 | 5 | 0 |
261063 | 261063 | 2020-06-21 | Warren | Pennsylvania | 42123 | 5 | 0 |
264191 | 264191 | 2020-06-22 | Warren | Pennsylvania | 42123 | 5 | 0 |
267319 | 267319 | 2020-06-23 | Warren | Pennsylvania | 42123 | 5 | 0 |
270453 | 270453 | 2020-06-24 | Warren | Pennsylvania | 42123 | 5 | 0 |
273592 | 273592 | 2020-06-25 | Warren | Pennsylvania | 42123 | 5 | 0 |
276739 | 276739 | 2020-06-26 | Warren | Pennsylvania | 42123 | 5 | 0 |
279887 | 279887 | 2020-06-27 | Warren | Pennsylvania | 42123 | 5 | 0 |
283033 | 283033 | 2020-06-28 | Warren | Pennsylvania | 42123 | 5 | 0 |
286178 | 286178 | 2020-06-29 | Warren | Pennsylvania | 42123 | 5 | 0 |
289329 | 289329 | 2020-06-30 | Warren | Pennsylvania | 42123 | 6 | 0 |
292481 | 292481 | 2020-07-01 | Warren | Pennsylvania | 42123 | 7 | 0 |
295637 | 295637 | 2020-07-02 | Warren | Pennsylvania | 42123 | 7 | 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);