Active Satellites In Orbit Around Earth

Which country has the most satellites in orbit? What are they used for?

@kaggle.ucsusa_active_satellites

Table List

1 table(115.58 KB)

Database

@kaggle.ucsusa_active_satellites.database

115.58 KB
1420 rows
26 columns

official_name_of_satellite Official Name Of Satellite	country_organization_of_un_registry Country/Organization Of UN Registry	operator_owner Operator/Owner	country_of_operator_owner Country Of Operator/Owner	users Users	purpose Purpose	detailed_purpose Detailed Purpose	class_of_orbit Class Of Orbit	type_of_orbit Type Of Orbit	longitude_of_geosynchronous_orbit_degrees Longitude Of Geosynchronous Orbit (Degrees)	perigee_kilometers Perigee (Kilometers)	apogee_kilometers Apogee (Kilometers)	eccentricity Eccentricity	inclination_degrees Inclination (Degrees)	period_minutes Period (Minutes)	launch_mass_kilograms Launch Mass (Kilograms)	dry_mass_kilograms Dry Mass (Kilograms)	power_watts Power (Watts)	date_of_launch Date Of Launch	expected_lifetime_years Expected Lifetime (Years)	contractor Contractor	country_of_contractor Country Of Contractor	launch_site Launch Site	launch_vehicle Launch Vehicle	cospar_number COSPAR Number	norad_number NORAD Number
AAUSat-4	NR	University of Aalborg	Denmark	Civil	Earth Observation	Automatic Identification System (AIS)	LEO	Sun-Synchronous		442	687	0.0177	98.2	95.9	1	nan	nan	Mon Apr 25 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	University of Aalborg	Denmark	Guiana Space Center	Soyuz 2.1a	2016-025E	41460
ABS-2	NR	Asia Broadcast Satellite Ltd.	Multinational	Commercial	Communications	nan	GEO	nan	75	35778	35793	0.000178	0.08	1436.03	6330	nan	16000	Thu Feb 06 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	15	Space Systems/Loral	USA	Guiana Space Center	Ariane 5 ECA	2014-006A	39508
ABS-2A	NR	Asia Broadcast Satellite Ltd.	Multinational	Commercial	Communications	nan	GEO	nan	-75	35700	35700			1436.1	1800	nan	nan	Wed Jun 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	15	Boeing Satellite Systems	USA	Cape Canaveral	Falcon 9	2016-038A	41588
ABS-3	Philippines	Asia Broadcast Satellite Ltd.	Multinational	Commercial	Communications	nan	GEO	nan	146.06	35769	35802	0.000391	0.05	1436.07	3775	1800	9000	Tue Aug 19 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	15	Space Systems/Loral	USA	Xichang Satellite Launch Center	Long March CZ3B	1997-042A	24901
ABS-3A	NR	Asia Broadcast Satellite Ltd.	Multinational	Commercial	Communications	nan	GEO	nan	-3	35788	35803	0.000178	0.1	1436	2000	nan	nan	Mon Mar 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	15	Boeing Satellite Systems	USA	Cape Canaveral	Falcon 9	2015-010A	40424
ABS-4	NR	Asia Broadcast Satellite Ltd.	Multinational	Commercial	Communications	nan	GEO	nan	75	35780	35793	0.000154	0.01	1436.1	4143	1700	7400	Sat Mar 13 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	12	Space Systems/Loral	USA	Cape Canaveral	Atlas 3	2004-007A	28184
ABS-6	NR	Asia Broadcast Satellite Ltd.	Multinational	Commercial	Communications	nan	GEO	nan	159	35777	35794	0.000202	0.01	1436.08	2894	1730	6,800 (EOL)	Sun Sep 26 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	15	Lockheed Martin	USA	Baikonur Cosmodrome	Proton	1999-053A	25924
ABS-7	South Korea	Asia Broadcast Satellite Ltd.	Multinational	Commercial	Communications	nan	GEO	nan	116.18	35780	35791	0.00013	0.01	1436.06	3500	1800	4800	Sat Sep 04 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	15	Lockheed Martin Astro Space	USA	Guiana Space Center	Ariane	1999-046A	25894
USA 139	USA	National Reconnaissance Office (NRO)	USA	Military	Earth Observation	Electronic Intelligence	GEO	nan	-14.5	35560	36013	0.00537	7.72	1436.14	4500	nan	nan	Sat May 09 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	TRW Space and Electronics	USA	Cape Canaveral	Titan IVA	1998-029A	25336
USA 171	USA	National Reconnaissance Office (NRO)	USA	Military	Earth Observation	Electronic Intelligence	GEO	nan	95.4	35589	35984	0.00468	3.2	1436.1	4500	nan	nan	Tue Sep 09 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	TRW Space and Electronics	USA	Cape Canaveral	Titan IV	2003-041A	27937


CREATE TABLE database (
  "official_name_of_satellite" VARCHAR,
  "country_organization_of_un_registry" VARCHAR,
  "operator_owner" VARCHAR,
  "country_of_operator_owner" VARCHAR,
  "users" VARCHAR,
  "purpose" VARCHAR,
  "detailed_purpose" VARCHAR,
  "class_of_orbit" VARCHAR,
  "type_of_orbit" VARCHAR,
  "longitude_of_geosynchronous_orbit_degrees" DOUBLE,
  "perigee_kilometers" DOUBLE,
  "apogee_kilometers" DOUBLE,
  "eccentricity" DOUBLE,
  "inclination_degrees" DOUBLE,
  "period_minutes" VARCHAR,
  "launch_mass_kilograms" VARCHAR,
  "dry_mass_kilograms" VARCHAR,
  "power_watts" VARCHAR,
  "date_of_launch" TIMESTAMP,
  "expected_lifetime_years" VARCHAR,
  "contractor" VARCHAR,
  "country_of_contractor" VARCHAR,
  "launch_site" VARCHAR,
  "launch_vehicle" VARCHAR,
  "cospar_number" VARCHAR,
  "norad_number" DOUBLE
);