The Bureau of the Census has released Census 2000 Summary File 1 (SF1) 100-Percent data. The file includes the following population items: sex, age, race, Hispanic or Latino origin, household relationship, and household and family characteristics. Housing items include occupancy status and tenure (whether the unit is owner or renter occupied). SF1 does not include information on incomes, poverty status, overcrowded housing or age of housing. These topics will be covered in Summary File 3. Data are available for states, counties, county subdivisions, places, census tracts, block groups, and, where applicable, American Indian and Alaskan Native Areas and Hawaiian Home Lands. The SF1 data are available on the Bureau's web site and may be retrieved from American FactFinder as tables, lists, or maps. Users may also download a set of compressed ASCII files for each state via the Bureau's FTP server. There are over 8000 data items available for each geographic area. The full listing of these data items is available here as a downloadable compressed data base file named TABLES.ZIP. The uncompressed is in FoxPro data base file (dbf) format and may be imported to ACCESS, EXCEL, and other software formats. While all of this information is useful, the Office of Community Planning and Development has downloaded selected information for all states and areas and is making this information available on the CPD web pages. The tables and data items selected are those items used in the CDBG and HOME allocation formulas plus topics most pertinent to the Comprehensive Housing Affordability Strategy (CHAS), the Consolidated Plan, and similar overall economic and community development plans. The information is contained in five compressed (zipped) dbf tables for each state. When uncompressed the tables are ready for use with FoxPro and they can be imported into ACCESS, EXCEL, and other spreadsheet, GIS and database software. The data are at the block group summary level. The first two characters of the file name are the state abbreviation. The next two letters are BG for block group. Each record is labeled with the code and name of the city and county in which it is located so that the data can be summarized to higher-level geography. The last part of the file name describes the contents . The GEO file contains standard Census Bureau geographic identifiers for each block group, such as the metropolitan area code and congressional district code. The only data included in this table is total population and total housing units. POP1 and POP2 contain selected population variables and selected housing items are in the HU file. The MA05 table data is only for use by State CDBG grantees for the reporting of the racial composition of beneficiaries of Area Benefit activities. The complete package for a state consists of the dictionary file named TABLES, and the five data files for the state. The logical record number (LOGRECNO) links the records across tables.

US Census Bureau conducts American Census Survey 1 and 5 Yr surveys that record various demographics and provide public access through APIs. I have attempted to call the APIs through the python environment using the requests library, Clean, and organize the data in a usable format.

Data Ingestion and Cleaning:

ACS Subject data [2011-2019] was accessed using Python by following the below API Link: https://api.census.gov/data/2011/acs/acs1?get=group(B08301)&for=county:* The data was obtained in JSON format by calling the above API, then imported as Python Pandas Dataframe. The 84 variables returned have 21 Estimate values for various metrics, 21 pairs of respective Margin of Error, and respective Annotation values for Estimate and Margin of Error Values. This data was then undergone through various cleaning processes using Python, where excess variables were removed, and the column names were renamed. Web-Scraping was carried out to extract the variables' names and replace the codes in the column names in raw data.

The above step was carried out for multiple ACS/ACS-1 datasets spanning 2011-2019 and then merged into a single Python Pandas Dataframe. The columns were rearranged, and the "NAME" column was split into two columns, namely 'StateName' and 'CountyName.' The counties for which no data was available were also removed from the Dataframe. Once the Dataframe was ready, it was separated into two new dataframes for separating State and County Data and exported into '.csv' format

Data Source:

More information about the source of Data can be found at the URL below: US Census Bureau. (n.d.). About: Census Bureau API. Retrieved from Census.gov https://www.census.gov/data/developers/about.html

Final Word:

I hope this data helps you to create something beautiful, and awesome. I will be posting a lot more databases shortly, if I get more time from assignments, submissions, and Semester Projects 🧙🏼‍♂️. Good Luck.

Census Designated Places (CDPs) are the statistical counterparts of incorporated places and are delineated to provide data for settled concentrations of population that are identifiable by name but are not legally incorporated under the laws of the state in which they are located. The boundaries usually are defined in cooperation with local or tribal officials and generally updated prior to each decennial census. These boundaries, which usually coincide with visible features or the boundary of an adjacent incorporated place or another legal entity boundary, have no legal status, nor do these places have officials elected to serve traditional municipal functions. CDP boundaries may change from one decennial census to the next with changes in the settlement pattern; a CDP with the same name as in an earlier census does not necessarily have the same boundary. CDPs must be contained within a single state and may not extend into an incorporated place. There are no population size requirements for CDPs.Hawaii is the only state that has no incorporated places recognized by the Census Bureau. All places shown in decennial census data products for Hawaii are CDPs. By agreement with the State of Hawaii, the Census Bureau does not show data separately for the city of Honolulu, which is coextensive with Honolulu County. In Puerto Rico, which also does not have incorporated places, the Census Bureau recognizes only CDPs and refers to them as comunidades or zonas urbanas. Guam also has only CDPs.Download: https://www2.census.gov/geo/tiger/TGRGDB24/tlgdb_2024_a_us_substategeo.gdb.zip Layer: Census_Designated_PlaceMetadata: https://meta.geo.census.gov/data/existing/decennial/GEO/GPMB/TIGERline/Current_19115/series_tl_2023_place.shp.iso.xml

The layer was derived and compiled from the U.S. Census Bureau’s 2013 – 2017 American Community Survey (ACS) 5-Year Estimates in order to assist 2020 Census planning purposes.

Source: U.S. Census Bureau, Table B04006 PEOPLE REPORTING ANCESTRY, 2013 – 2017 ACS 5-Year Estimates

Effective Date: December 2018

Last Update: December 2019

Update Cycle: ACS 5-Year Estimates update annually each December. Vintage used for 2020 Census planning purposes by Broward County.

The layer was derived and compiled from the U.S. Census Bureau’s 2013 – 2017 American Community Survey (ACS) 5-Year Estimates in order to assist 2020 Census planning purposes.

Source: U.S. Census Bureau, Table B04006 PEOPLE REPORTING ANCESTRY, 2013 – 2017 ACS 5-Year Estimates

Effective Date: December 2018

Last Update: December 2019

Update Cycle: ACS 5-Year Estimates update annually each December. Vintage used for 2020 Census planning purposes by Broward County.

The layer was derived and compiled from the U.S. Census Bureau’s 2013 – 2017 American Community Survey (ACS) 5-Year Estimates in order to assist 2020 Census planning purposes.

Source: U.S. Census Bureau, Table B04006 PEOPLE REPORTING ANCESTRY, 2013 – 2017 ACS 5-Year Estimates

Effective Date: December 2018

Last Update: December 2019

Update Cycle: ACS 5-Year Estimates update annually each December. Vintage used for 2020 Census planning purposes by Broward County.

The TIGER/Line Files are shapefiles and related database files (.dbf) that are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line File is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. The Census Bureau includes landmarks in the MTDB for locating special features and to help enumerators during field operations. Some of the more common landmark types include area landmarks such as airports, cemeteries, parks, schools, and churches and other religious institutions. The Census Bureau added landmark features to MTDB on an as-needed basis and made no attempt to ensure that all instances of a particular feature were included. The presence or absence of a landmark such as a hospital or prison does not mean that the living quarters associated with that landmark were geocoded to that census tabulation block or excluded from the census enumeration. The Area Landmark Shapefile does not include military installations or water bodies because they each appear in their own separate shapefiles, MIL.shp and AREAWATER.shp respectively.

The TIGER/Line Files are shapefiles and related database files (.dbf) that are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line File is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. The Census Bureau includes landmarks in the MTDB for locating special features and to help enumerators during field operations. Some of the more common landmark types include area landmarks such as airports, cemeteries, parks, schools, and churches and other religious institutions. The Census Bureau added landmark features to MTDB on an as-needed basis and made no attempt to ensure that all instances of a particular feature were included. The presence or absence of a landmark such as a hospital or prison does not mean that the living quarters associated with that landmark were geocoded to that census tabulation block or excluded from the census enumeration. The Area Landmark Shapefile does not include military installations or water bodies because they each appear in their own separate shapefiles, MIL.shp and AREAWATER.shp respectively.

The TIGER/Line Files are shapefiles and related database files (.dbf) that are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line File is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. The Census Bureau includes landmarks in the MTDB for locating special features and to help enumerators during field operations. Some of the more common landmark types include area landmarks such as airports, cemeteries, parks, schools, and churches and other religious institutions. The Census Bureau added landmark features to MTDB on an as-needed basis and made no attempt to ensure that all instances of a particular feature were included. The presence or absence of a landmark such as a hospital or prison does not mean that the living quarters associated with that landmark were geocoded to that census tabulation block or excluded from the census enumeration. The Area Landmark Shapefile does not include military installations or water bodies because they each appear in their own separate shapefiles, MIL.shp and AREAWATER.shp respectively.

The TIGER/Line Files are shapefiles and related database files (.dbf) that are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line File is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. The Census Bureau includes landmarks in the MTDB for locating special features and to help enumerators during field operations. Some of the more common landmark types include area landmarks such as airports, cemeteries, parks, schools, and churches and other religious institutions. The Census Bureau added landmark features to MTDB on an as-needed basis and made no attempt to ensure that all instances of a particular feature were included. The presence or absence of a landmark such as a hospital or prison does not mean that the living quarters associated with that landmark were geocoded to that census tabulation block or excluded from the census enumeration. The Area Landmark Shapefile does not include military installations or water bodies because they each appear in their own separate shapefiles, MIL.shp and AREAWATER.shp respectively.

The Census collected information on the resident population of Northern Ireland on Census Day (27 March 2011). Questionnaires were delivered to every household and communal establishment and residents asked to complete and return with information as correct on Census Day. Special arrangements were made to enumerate special groups such as the Armed Forces. The Census Coverage Survey (an independent doorstep survey) followed between 9 May and 3 June 2011 and was used to adjust the Census counts for under-enumeration.

The TIGER/Line Files are shapefiles and related database files (.dbf) that are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line File is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. The Census Bureau includes landmarks in the MTDB for locating special features and to help enumerators during field operations. Some of the more common landmark types include area landmarks such as airports, cemeteries, parks, schools, and churches and other religious institutions. The Census Bureau added landmark features to MTDB on an as-needed basis and made no attempt to ensure that all instances of a particular feature were included. The presence or absence of a landmark such as a hospital or prison does not mean that the living quarters associated with that landmark were geocoded to that census tabulation block or excluded from the census enumeration. The Area Landmark Shapefile does not include military installations or water bodies because they each appear in their own separate shapefiles, MIL.shp and AREAWATER.shp respectively.

The layer was derived and compiled from the U.S. Census Bureau’s 2013 – 2017 American Community Survey (ACS) 5-Year Estimates in order to assist 2020 Census planning purposes.

Source: U.S. Census Bureau, Table B26001 GROUP QUARTERS POPULATION, 2013 – 2017 ACS 5-Year Estimates

Effective Date: December 2018

Last Update: December 2019

Update Cycle: ACS 5-Year Estimates update annually each December. Vintage used for 2020 Census planning purposes by Broward County.

The TIGER/Line Files are shapefiles and related database files (.dbf) that are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line File is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. The Census Bureau includes landmarks in the MTDB for locating special features and to help enumerators during field operations. Some of the more common landmark types include area landmarks such as airports, cemeteries, parks, schools, and churches and other religious institutions. The Census Bureau added landmark features to MTDB on an as-needed basis and made no attempt to ensure that all instances of a particular feature were included. The presence or absence of a landmark such as a hospital or prison does not mean that the living quarters associated with that landmark were geocoded to that census tabulation block or excluded from the census enumeration. The Area Landmark Shapefile does not include military installations or water bodies because they each appear in their own separate shapefiles, MIL.shp and AREAWATER.shp respectively.

70 selected reefs throughout the Great Barrier Reef (GBR) are sampled in the AIMS Long-term Monitoring Project (LTMP). Underwater visual census is used to survey reef fishes on fixed transects (3 sites per reef, 5 x 50 m transects per site). The abundance and length of all diurnally active, non-cryptic fishes are recorded. A full list of species observed each year can be obtained on request. The overarching goal of LTMP fish surveys are to detect changes in reef fish communities over time at a regional scale, but also to examine the effectiveness of Marine Protected Areas. All fish species counted are largely non-cryptic, easily identified underwater and include both commercial and non-commercial taxa. Because surveys span the annual recruitment season, 0+ individuals are excluded from counts: these are distinguished from adults by their small size and often distinctive colouration. Abundance data for each fish species is subsequently summed over the five transects at each site on each reef to provide reasonable sample sizes for analysis and interpretation. Updated results of surveys can be found at: https://apps.aims.gov.au/reef-monitoring/reefs A subset of the data has been provided to the Ocean Biogeographic Information System (OBIS, http://www.iobis.org/explore/#/dataset/3936). Data have been used for the e-Atlas: http://eatlas.org.au/data/uuid/05bde62a-70ec-407b-b999-30cf369498af

The layer was derived and compiled from the U.S. Census Bureau’s 2013 – 2017 American Community Survey (ACS) 5-Year Estimates in order to assist 2020 Census planning purposes.

Source: U.S. Census Bureau, Table B04006 PEOPLE REPORTING ANCESTRY, 2013 – 2017 ACS 5-Year Estimates

Effective Date: December 2018

Last Update: December 2019

Update Cycle: ACS 5-Year Estimates update annually each December. Vintage used for 2020 Census planning purposes by Broward County.

The layer was derived and compiled from the U.S. Census Bureau’s 2013 – 2017 American Community Survey (ACS) 5-Year Estimates in order to assist 2020 Census planning purposes.

Source: U.S. Census Bureau, Table B05002 PLACE OF BIRTH BY NATIVITY AND CITIZENSHIP STATUS, 2013 – 2017 ACS 5-Year Estimates

Effective Date: December 2018

Last Update: December 2019

Update Cycle: ACS 5-Year Estimates update annually each December. Vintage used for 2020 Census planning purposes by Broward County.

The layer was derived and compiled from the U.S. Census Bureau’s 2013 – 2017 American Community Survey (ACS) 5-Year Estimates in order to assist 2020 Census planning purposes.

Source: U.S. Census Bureau, Table B02015 ASIAN ALONE BY SELECTED GROUPS, 2013 – 2017 ACS 5-Year Estimates

Effective Date: December 2018

Last Update: December 2019

Update Cycle: ACS 5-Year Estimates update annually each December. Vintage used for 2020 Census planning purposes by Broward County.

The 50 ha plot at Barro Colorado Island, Panama (utm: easting 625754, northing 1011569, zone 17), has 6 completed censuses: 1981-83, 1985, 1990, 1995, 2000, and 2005. All trees >=10 mm dbh were tagged, measured, mapped and identified to species. The tab-delimited text files consist of the following datasets: 6 census files with the location and diameter measurements, 6 multiple-stem files with the multiple stem measurements excluding the largest measurement which is in the census files, the species list, elevation data, and an MS Word file briefly explaining the fields in the census files.

The layer was derived and compiled from the U.S. Census Bureau’s 2013 – 2017 American Community Survey (ACS) 5-Year Estimates in order to assist 2020 Census planning purposes.

Source: U.S. Census Bureau, Table B26001 GROUP QUARTERS POPULATION, 2013 – 2017 ACS 5-Year Estimates

Effective Date: December 2018

Last Update: December 2019

Update Cycle: ACS 5-Year Estimates update annually each December. Vintage used for 2020 Census planning purposes by Broward County.