ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,170 rows where county = "Pawnee" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Pawnee · 2,170 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3606 | 3606 | 2020-03-17 | Pawnee | Oklahoma | 40117 | 1 | 0 |
4221 | 4221 | 2020-03-18 | Pawnee | Oklahoma | 40117 | 1 | 0 |
4959 | 4959 | 2020-03-19 | Pawnee | Oklahoma | 40117 | 1 | 0 |
5826 | 5826 | 2020-03-20 | Pawnee | Oklahoma | 40117 | 1 | 0 |
6827 | 6827 | 2020-03-21 | Pawnee | Oklahoma | 40117 | 2 | 0 |
203931 | 203931 | 2020-06-03 | Pawnee | Kansas | 20145 | 2 | 0 |
207012 | 207012 | 2020-06-04 | Pawnee | Kansas | 20145 | 2 | 0 |
210093 | 210093 | 2020-06-05 | Pawnee | Kansas | 20145 | 2 | 0 |
213178 | 213178 | 2020-06-06 | Pawnee | Kansas | 20145 | 2 | 0 |
216265 | 216265 | 2020-06-07 | Pawnee | Kansas | 20145 | 2 | 0 |
219357 | 219357 | 2020-06-08 | Pawnee | Kansas | 20145 | 4 | 0 |
222452 | 222452 | 2020-06-09 | Pawnee | Kansas | 20145 | 4 | 0 |
225547 | 225547 | 2020-06-10 | Pawnee | Kansas | 20145 | 3 | 0 |
228649 | 228649 | 2020-06-11 | Pawnee | Kansas | 20145 | 3 | 0 |
231752 | 231752 | 2020-06-12 | Pawnee | Kansas | 20145 | 3 | 0 |
234858 | 234858 | 2020-06-13 | Pawnee | Kansas | 20145 | 3 | 0 |
237965 | 237965 | 2020-06-14 | Pawnee | Kansas | 20145 | 3 | 0 |
241074 | 241074 | 2020-06-15 | Pawnee | Kansas | 20145 | 3 | 0 |
244185 | 244185 | 2020-06-16 | Pawnee | Kansas | 20145 | 3 | 0 |
247298 | 247298 | 2020-06-17 | Pawnee | Kansas | 20145 | 3 | 0 |
250410 | 250410 | 2020-06-18 | Pawnee | Kansas | 20145 | 3 | 0 |
253525 | 253525 | 2020-06-19 | Pawnee | Kansas | 20145 | 3 | 0 |
256645 | 256645 | 2020-06-20 | Pawnee | Kansas | 20145 | 3 | 0 |
259771 | 259771 | 2020-06-21 | Pawnee | Kansas | 20145 | 3 | 0 |
262898 | 262898 | 2020-06-22 | Pawnee | Kansas | 20145 | 3 | 0 |
266026 | 266026 | 2020-06-23 | Pawnee | Kansas | 20145 | 3 | 0 |
269158 | 269158 | 2020-06-24 | Pawnee | Kansas | 20145 | 3 | 0 |
272295 | 272295 | 2020-06-25 | Pawnee | Kansas | 20145 | 3 | 0 |
275438 | 275438 | 2020-06-26 | Pawnee | Kansas | 20145 | 3 | 0 |
278586 | 278586 | 2020-06-27 | Pawnee | Kansas | 20145 | 3 | 0 |
281734 | 281734 | 2020-06-28 | Pawnee | Kansas | 20145 | 3 | 0 |
284879 | 284879 | 2020-06-29 | Pawnee | Kansas | 20145 | 3 | 0 |
288028 | 288028 | 2020-06-30 | Pawnee | Kansas | 20145 | 3 | 0 |
291178 | 291178 | 2020-07-01 | Pawnee | Kansas | 20145 | 3 | 0 |
294332 | 294332 | 2020-07-02 | Pawnee | Kansas | 20145 | 3 | 0 |
297490 | 297490 | 2020-07-03 | Pawnee | Kansas | 20145 | 3 | 0 |
300652 | 300652 | 2020-07-04 | Pawnee | Kansas | 20145 | 3 | 0 |
303816 | 303816 | 2020-07-05 | Pawnee | Kansas | 20145 | 3 | 0 |
306983 | 306983 | 2020-07-06 | Pawnee | Kansas | 20145 | 3 | 0 |
310151 | 310151 | 2020-07-07 | Pawnee | Kansas | 20145 | 3 | 0 |
313321 | 313321 | 2020-07-08 | Pawnee | Kansas | 20145 | 4 | 0 |
316495 | 316495 | 2020-07-09 | Pawnee | Kansas | 20145 | 4 | 0 |
319669 | 319669 | 2020-07-10 | Pawnee | Kansas | 20145 | 5 | 0 |
322848 | 322848 | 2020-07-11 | Pawnee | Kansas | 20145 | 5 | 0 |
323585 | 323585 | 2020-07-11 | Pawnee | Nebraska | 31133 | 1 | 0 |
326031 | 326031 | 2020-07-12 | Pawnee | Kansas | 20145 | 5 | 0 |
326769 | 326769 | 2020-07-12 | Pawnee | Nebraska | 31133 | 1 | 0 |
329217 | 329217 | 2020-07-13 | Pawnee | Kansas | 20145 | 5 | 0 |
329956 | 329956 | 2020-07-13 | Pawnee | Nebraska | 31133 | 1 | 0 |
332404 | 332404 | 2020-07-14 | Pawnee | Kansas | 20145 | 5 | 0 |
333146 | 333146 | 2020-07-14 | Pawnee | Nebraska | 31133 | 1 | 0 |
335597 | 335597 | 2020-07-15 | Pawnee | Kansas | 20145 | 8 | 0 |
336340 | 336340 | 2020-07-15 | Pawnee | Nebraska | 31133 | 1 | 0 |
338793 | 338793 | 2020-07-16 | Pawnee | Kansas | 20145 | 8 | 0 |
339537 | 339537 | 2020-07-16 | Pawnee | Nebraska | 31133 | 1 | 0 |
341989 | 341989 | 2020-07-17 | Pawnee | Kansas | 20145 | 8 | 0 |
342734 | 342734 | 2020-07-17 | Pawnee | Nebraska | 31133 | 1 | 0 |
345189 | 345189 | 2020-07-18 | Pawnee | Kansas | 20145 | 8 | 0 |
345934 | 345934 | 2020-07-18 | Pawnee | Nebraska | 31133 | 1 | 0 |
348390 | 348390 | 2020-07-19 | Pawnee | Kansas | 20145 | 8 | 0 |
349135 | 349135 | 2020-07-19 | Pawnee | Nebraska | 31133 | 1 | 0 |
351590 | 351590 | 2020-07-20 | Pawnee | Kansas | 20145 | 7 | 0 |
352336 | 352336 | 2020-07-20 | Pawnee | Nebraska | 31133 | 1 | 0 |
354792 | 354792 | 2020-07-21 | Pawnee | Kansas | 20145 | 7 | 0 |
355539 | 355539 | 2020-07-21 | Pawnee | Nebraska | 31133 | 1 | 0 |
357994 | 357994 | 2020-07-22 | Pawnee | Kansas | 20145 | 7 | 0 |
358743 | 358743 | 2020-07-22 | Pawnee | Nebraska | 31133 | 1 | 0 |
361199 | 361199 | 2020-07-23 | Pawnee | Kansas | 20145 | 7 | 0 |
361949 | 361949 | 2020-07-23 | Pawnee | Nebraska | 31133 | 2 | 0 |
364406 | 364406 | 2020-07-24 | Pawnee | Kansas | 20145 | 8 | 0 |
365155 | 365155 | 2020-07-24 | Pawnee | Nebraska | 31133 | 2 | 0 |
367613 | 367613 | 2020-07-25 | Pawnee | Kansas | 20145 | 8 | 0 |
368364 | 368364 | 2020-07-25 | Pawnee | Nebraska | 31133 | 5 | 0 |
370823 | 370823 | 2020-07-26 | Pawnee | Kansas | 20145 | 8 | 0 |
371575 | 371575 | 2020-07-26 | Pawnee | Nebraska | 31133 | 5 | 0 |
374035 | 374035 | 2020-07-27 | Pawnee | Kansas | 20145 | 7 | 0 |
374787 | 374787 | 2020-07-27 | Pawnee | Nebraska | 31133 | 5 | 0 |
377250 | 377250 | 2020-07-28 | Pawnee | Kansas | 20145 | 7 | 0 |
378003 | 378003 | 2020-07-28 | Pawnee | Nebraska | 31133 | 6 | 0 |
380467 | 380467 | 2020-07-29 | Pawnee | Kansas | 20145 | 7 | 0 |
381221 | 381221 | 2020-07-29 | Pawnee | Nebraska | 31133 | 6 | 0 |
383684 | 383684 | 2020-07-30 | Pawnee | Kansas | 20145 | 7 | 0 |
384437 | 384437 | 2020-07-30 | Pawnee | Nebraska | 31133 | 6 | 0 |
386902 | 386902 | 2020-07-31 | Pawnee | Kansas | 20145 | 7 | 0 |
387655 | 387655 | 2020-07-31 | Pawnee | Nebraska | 31133 | 7 | 0 |
390119 | 390119 | 2020-08-01 | Pawnee | Kansas | 20145 | 7 | 0 |
390872 | 390872 | 2020-08-01 | Pawnee | Nebraska | 31133 | 7 | 0 |
393336 | 393336 | 2020-08-02 | Pawnee | Kansas | 20145 | 7 | 0 |
394089 | 394089 | 2020-08-02 | Pawnee | Nebraska | 31133 | 7 | 0 |
396552 | 396552 | 2020-08-03 | Pawnee | Kansas | 20145 | 8 | 0 |
397305 | 397305 | 2020-08-03 | Pawnee | Nebraska | 31133 | 8 | 0 |
399767 | 399767 | 2020-08-04 | Pawnee | Kansas | 20145 | 8 | 0 |
400520 | 400520 | 2020-08-04 | Pawnee | Nebraska | 31133 | 9 | 0 |
402984 | 402984 | 2020-08-05 | Pawnee | Kansas | 20145 | 8 | 0 |
403738 | 403738 | 2020-08-05 | Pawnee | Nebraska | 31133 | 9 | 0 |
406202 | 406202 | 2020-08-06 | Pawnee | Kansas | 20145 | 8 | 0 |
406957 | 406957 | 2020-08-06 | Pawnee | Nebraska | 31133 | 9 | 0 |
409421 | 409421 | 2020-08-07 | Pawnee | Kansas | 20145 | 8 | 0 |
410177 | 410177 | 2020-08-07 | Pawnee | Nebraska | 31133 | 9 | 0 |
412641 | 412641 | 2020-08-08 | Pawnee | Kansas | 20145 | 8 | 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);