ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

10,908 rows where county = "Greene" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 14

fips 14

county 1

  • Greene · 10,908 ✖
Link rowid date ▲ county state fips cases deaths
2499606 2499606 2022-05-13 Greene Alabama 1063 1877 49
2499713 2499713 2022-05-13 Greene Arkansas 5055 16088 173
2500031 2500031 2022-05-13 Greene Georgia 13133 3974 85
2500207 2500207 2022-05-13 Greene Illinois 17061 3663 58
2500307 2500307 2022-05-13 Greene Indiana 18055 7262 139
2500409 2500409 2022-05-13 Greene Iowa 19073 1745 21
2501013 2501013 2022-05-13 Greene Mississippi 28041 3198 59
2501114 2501114 2022-05-13 Greene Missouri 29077 71775 1040
2501446 2501446 2022-05-13 Greene New York 36039 9055 130
2501525 2501525 2022-05-13 Greene North Carolina 37079 5826 67
2501672 2501672 2022-05-13 Greene Ohio 39057 38049 513
2501876 2501876 2022-05-13 Greene Pennsylvania 42059 8513 104
2502140 2502140 2022-05-13 Greene Tennessee 47059 22140 374
2502562 2502562 2022-05-13 Greene Virginia 51079 4074 62
2496348 2496348 2022-05-12 Greene Alabama 1063 1876 49
2496455 2496455 2022-05-12 Greene Arkansas 5055 16079 173
2496773 2496773 2022-05-12 Greene Georgia 13133 3974 85
2496949 2496949 2022-05-12 Greene Illinois 17061 3659 58
2497049 2497049 2022-05-12 Greene Indiana 18055 7252 139
2497151 2497151 2022-05-12 Greene Iowa 19073 1745 21
2497755 2497755 2022-05-12 Greene Mississippi 28041 3198 59
2497856 2497856 2022-05-12 Greene Missouri 29077 71741 1038
2498188 2498188 2022-05-12 Greene New York 36039 9055 129
2498267 2498267 2022-05-12 Greene North Carolina 37079 5826 67
2498414 2498414 2022-05-12 Greene Ohio 39057 38049 513
2498618 2498618 2022-05-12 Greene Pennsylvania 42059 8513 104
2498882 2498882 2022-05-12 Greene Tennessee 47059 22140 374
2499304 2499304 2022-05-12 Greene Virginia 51079 4063 62
2493090 2493090 2022-05-11 Greene Alabama 1063 1876 49
2493197 2493197 2022-05-11 Greene Arkansas 5055 16079 173
2493515 2493515 2022-05-11 Greene Georgia 13133 3974 85
2493691 2493691 2022-05-11 Greene Illinois 17061 3658 58
2493791 2493791 2022-05-11 Greene Indiana 18055 7252 139
2493893 2493893 2022-05-11 Greene Iowa 19073 1745 21
2494497 2494497 2022-05-11 Greene Mississippi 28041 3198 59
2494598 2494598 2022-05-11 Greene Missouri 29077 71712 1038
2494930 2494930 2022-05-11 Greene New York 36039 9044 129
2495009 2495009 2022-05-11 Greene North Carolina 37079 5826 67
2495156 2495156 2022-05-11 Greene Ohio 39057 37845 512
2495360 2495360 2022-05-11 Greene Pennsylvania 42059 8513 104
2495624 2495624 2022-05-11 Greene Tennessee 47059 22140 374
2496046 2496046 2022-05-11 Greene Virginia 51079 4059 62
2489832 2489832 2022-05-10 Greene Alabama 1063 1875 49
2489939 2489939 2022-05-10 Greene Arkansas 5055 16076 173
2490257 2490257 2022-05-10 Greene Georgia 13133 3954 85
2490433 2490433 2022-05-10 Greene Illinois 17061 3657 58
2490533 2490533 2022-05-10 Greene Indiana 18055 7245 139
2490635 2490635 2022-05-10 Greene Iowa 19073 1743 21
2491239 2491239 2022-05-10 Greene Mississippi 28041 3198 59
2491340 2491340 2022-05-10 Greene Missouri 29077 71672 1038
2491672 2491672 2022-05-10 Greene New York 36039 9025 129
2491751 2491751 2022-05-10 Greene North Carolina 37079 5814 67
2491898 2491898 2022-05-10 Greene Ohio 39057 37845 512
2492102 2492102 2022-05-10 Greene Pennsylvania 42059 8490 104
2492366 2492366 2022-05-10 Greene Tennessee 47059 22102 374
2492788 2492788 2022-05-10 Greene Virginia 51079 4051 62
2486575 2486575 2022-05-09 Greene Alabama 1063 1875 49
2486682 2486682 2022-05-09 Greene Arkansas 5055 16073 173
2487000 2487000 2022-05-09 Greene Georgia 13133 3954 85
2487176 2487176 2022-05-09 Greene Illinois 17061 3651 58
2487276 2487276 2022-05-09 Greene Indiana 18055 7245 139
2487378 2487378 2022-05-09 Greene Iowa 19073 1743 21
2487982 2487982 2022-05-09 Greene Mississippi 28041 3198 59
2488082 2488082 2022-05-09 Greene Missouri 29077 71643 1038
2488414 2488414 2022-05-09 Greene New York 36039 9017 129
2488493 2488493 2022-05-09 Greene North Carolina 37079 5814 67
2488640 2488640 2022-05-09 Greene Ohio 39057 37845 512
2488844 2488844 2022-05-09 Greene Pennsylvania 42059 8490 104
2489108 2489108 2022-05-09 Greene Tennessee 47059 22102 374
2489530 2489530 2022-05-09 Greene Virginia 51079 4041 62
2483317 2483317 2022-05-08 Greene Alabama 1063 1875 49
2483424 2483424 2022-05-08 Greene Arkansas 5055 16071 173
2483742 2483742 2022-05-08 Greene Georgia 13133 3954 85
2483918 2483918 2022-05-08 Greene Illinois 17061 3640 58
2484018 2484018 2022-05-08 Greene Indiana 18055 7236 139
2484120 2484120 2022-05-08 Greene Iowa 19073 1743 21
2484724 2484724 2022-05-08 Greene Mississippi 28041 3193 59
2484825 2484825 2022-05-08 Greene Missouri 29077 71557 1038
2485157 2485157 2022-05-08 Greene New York 36039 9012 129
2485236 2485236 2022-05-08 Greene North Carolina 37079 5814 67
2485383 2485383 2022-05-08 Greene Ohio 39057 37845 512
2485587 2485587 2022-05-08 Greene Pennsylvania 42059 8490 104
2485851 2485851 2022-05-08 Greene Tennessee 47059 22102 374
2486273 2486273 2022-05-08 Greene Virginia 51079 4028 62
2480059 2480059 2022-05-07 Greene Alabama 1063 1875 49
2480166 2480166 2022-05-07 Greene Arkansas 5055 16069 173
2480484 2480484 2022-05-07 Greene Georgia 13133 3954 85
2480660 2480660 2022-05-07 Greene Illinois 17061 3640 58
2480760 2480760 2022-05-07 Greene Indiana 18055 7236 139
2480862 2480862 2022-05-07 Greene Iowa 19073 1743 21
2481466 2481466 2022-05-07 Greene Mississippi 28041 3193 59
2481567 2481567 2022-05-07 Greene Missouri 29077 71557 1038
2481899 2481899 2022-05-07 Greene New York 36039 9002 129
2481978 2481978 2022-05-07 Greene North Carolina 37079 5814 67
2482125 2482125 2022-05-07 Greene Ohio 39057 37845 512
2482329 2482329 2022-05-07 Greene Pennsylvania 42059 8490 104
2482593 2482593 2022-05-07 Greene Tennessee 47059 22102 374
2483015 2483015 2022-05-07 Greene Virginia 51079 4028 62
2476801 2476801 2022-05-06 Greene Alabama 1063 1875 49
2476908 2476908 2022-05-06 Greene Arkansas 5055 16065 173

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);