home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

5,994 rows where station_code = "ZA000C" sorted by created_at descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

Link rowid meteor_unique_trajectory_identifier station_code created_at ▲ updated_at
8687045 8687045 20251204021705_FD8yu ZA000C 2025-12-05T14:13:43.093Z 2025-12-05T14:14:35.586Z
8687035 8687035 20251204015518_jItXN ZA000C 2025-12-05T14:13:32.278Z 2025-12-05T14:14:35.577Z
8687027 8687027 20251204014726_IcHKe ZA000C 2025-12-05T14:13:30.078Z 2025-12-05T14:14:35.572Z
8687017 8687017 20251204012816_RcXyz ZA000C 2025-12-05T14:13:27.579Z 2025-12-05T14:14:35.566Z
8687015 8687015 20251204012442_9CMX3 ZA000C 2025-12-05T14:13:27.236Z 2025-12-05T14:14:35.565Z
8687013 8687013 20251204012043_sNJfL ZA000C 2025-12-05T14:13:26.198Z 2025-12-05T14:14:35.564Z
8687011 8687011 20251204011541_4lntX ZA000C 2025-12-05T14:13:25.222Z 2025-12-05T14:14:35.562Z
8687004 8687004 20251204005834_xr0eV ZA000C 2025-12-05T14:13:22.176Z 2025-12-05T14:14:35.550Z
8687002 8687002 20251204004629_mgVV3 ZA000C 2025-12-05T14:13:21.828Z 2025-12-05T14:14:35.548Z
8686995 8686995 20251204003244_Bioui ZA000C 2025-12-05T14:13:20.916Z 2025-12-05T14:14:35.545Z
8686982 8686982 20251203235723_5u6dl ZA000C 2025-12-05T14:13:18.880Z 2025-12-05T14:14:35.539Z
8686978 8686978 20251203234424_4VQPJ ZA000C 2025-12-05T14:13:18.286Z 2025-12-05T14:14:35.537Z
8686968 8686968 20251203225818_ln833 ZA000C 2025-12-05T14:13:16.844Z 2025-12-05T14:14:35.533Z
8686962 8686962 20251203215315_c2jdW ZA000C 2025-12-05T14:13:15.673Z 2025-12-05T14:14:35.530Z
8686466 8686466 20251203195440_B9FZD ZA000C 2025-12-05T14:11:56.846Z 2025-12-05T14:14:35.397Z
8674154 8674154 20251202013701_puVW2 ZA000C 2025-12-03T14:21:01.242Z 2025-12-05T14:27:30.798Z
8674028 8674028 20251202011210_3xTV6 ZA000C 2025-12-03T14:20:46.410Z 2025-12-05T14:27:26.799Z
8674026 8674026 20251202011205_jCie0 ZA000C 2025-12-03T14:20:46.176Z 2025-12-05T14:27:26.707Z
8674000 8674000 20251202010148_c8yqt ZA000C 2025-12-03T14:20:42.655Z 2025-12-05T14:27:25.536Z
8673921 8673921 20251202002822_3F9ux ZA000C 2025-12-03T14:20:22.015Z 2025-12-05T14:27:22.974Z
8673893 8673893 20251202002143_hwYr3 ZA000C 2025-12-03T14:20:15.936Z 2025-12-05T14:27:21.985Z
8673883 8673883 20251202001529_Y2Sbi ZA000C 2025-12-03T14:20:14.336Z 2025-12-05T14:27:21.314Z
8664941 8664941 20251201020636_6gxxH ZA000C 2025-12-02T14:22:29.331Z 2025-12-05T14:35:36.976Z
8664702 8664702 20251201012807_UnV3p ZA000C 2025-12-02T14:21:50.977Z 2025-12-05T14:35:15.069Z
8664574 8664574 20251201005827_gm1Az ZA000C 2025-12-02T14:21:30.408Z 2025-12-05T14:35:08.971Z
8664485 8664485 20251201004055_yGDLh ZA000C 2025-12-02T14:21:11.699Z 2025-12-05T14:35:05.966Z
8664351 8664351 20251201000639_LhOMi ZA000C 2025-12-02T14:20:46.412Z 2025-12-05T14:35:01.596Z
8664327 8664327 20251201000342_3zPkW ZA000C 2025-12-02T14:20:43.158Z 2025-12-05T14:35:00.735Z
8664229 8664229 20251130234821_pp3n7 ZA000C 2025-12-02T14:20:32.368Z 2025-12-05T14:34:57.648Z
8611543 8611543 20251126015116_sztAX ZA000C 2025-11-27T14:22:18.644Z 2025-12-04T15:09:22.462Z
8611321 8611321 20251126013656_8I5AS ZA000C 2025-11-27T14:21:51.113Z 2025-12-04T15:09:09.753Z
8611184 8611184 20251126012955_Z7z7X ZA000C 2025-11-27T14:21:36.351Z 2025-12-04T15:08:56.692Z
8611047 8611047 20251126011839_DEOAF ZA000C 2025-11-27T14:21:08.561Z 2025-12-04T15:08:50.075Z
8610981 8610981 20251126011641_g5yKA ZA000C 2025-11-27T14:21:00.969Z 2025-12-04T15:08:47.293Z
8610543 8610543 20251126005331_Xq336 ZA000C 2025-11-27T14:20:17.931Z 2025-12-04T15:08:13.480Z
8610326 8610326 20251126003838_Qg0Kw ZA000C 2025-11-27T14:19:46.863Z 2025-12-04T15:08:04.194Z
8610234 8610234 20251126003125_GZnzp ZA000C 2025-11-27T14:19:39.040Z 2025-12-04T15:08:03.582Z
8610166 8610166 20251126002726_TTB2D ZA000C 2025-11-27T14:19:32.514Z 2025-12-04T15:08:03.060Z
8609635 8609635 20251125235659_0vqhz ZA000C 2025-11-27T14:18:45.178Z 2025-12-04T15:07:56.172Z
8609516 8609516 20251125234643_iIqxT ZA000C 2025-11-27T14:18:18.205Z 2025-12-04T15:07:54.924Z
8609486 8609486 20251125234603_5KJ2V ZA000C 2025-11-27T14:18:16.572Z 2025-12-04T15:07:54.753Z
8609428 8609428 20251125233953_GaXwQ ZA000C 2025-11-27T14:18:11.309Z 2025-12-04T15:07:54.166Z
8609206 8609206 20251125232110_lupA2 ZA000C 2025-11-27T14:17:46.241Z 2025-12-04T15:07:52.574Z
8609175 8609175 20251125231724_qym0J ZA000C 2025-11-27T14:17:39.416Z 2025-12-04T15:07:52.353Z
8608965 8608965 20251125230123_CY9Xk ZA000C 2025-11-27T14:17:10.497Z 2025-12-04T15:07:50.239Z
8608963 8608963 20251125230014_5zkQS ZA000C 2025-11-27T14:17:09.006Z 2025-12-04T15:07:50.201Z
8608801 8608801 20251125224644_YTCrz ZA000C 2025-11-27T14:16:52.953Z 2025-12-04T15:07:48.751Z
8608557 8608557 20251125222713_hv3hx ZA000C 2025-11-27T14:16:16.619Z 2025-12-04T15:07:46.326Z
8608267 8608267 20251125220340_RIyIM ZA000C 2025-11-27T14:15:38.386Z 2025-12-04T15:07:43.174Z
8608240 8608240 20251125220313_3uECm ZA000C 2025-11-27T14:15:35.951Z 2025-12-04T15:07:42.928Z
8608094 8608094 20251125214930_s40Xd ZA000C 2025-11-27T14:15:18.178Z 2025-12-04T15:07:41.200Z
8608013 8608013 20251125214405_Aco5j ZA000C 2025-11-27T14:15:05.319Z 2025-12-04T15:07:40.217Z
8607848 8607848 20251125212823_dCS79 ZA000C 2025-11-27T14:14:36.828Z 2025-12-04T15:07:35.847Z
8607591 8607591 20251125210458_880l6 ZA000C 2025-11-27T14:14:00.143Z 2025-12-04T15:07:04.104Z
8607393 8607393 20251125205040_Tgq36 ZA000C 2025-11-27T14:13:33.813Z 2025-12-04T15:07:01.756Z
8607242 8607242 20251125202945_lPvTR ZA000C 2025-11-27T14:12:56.521Z 2025-12-04T15:06:56.895Z
8607077 8607077 20251125201039_cT7t9 ZA000C 2025-11-27T14:12:20.473Z 2025-12-04T15:06:54.456Z
8607009 8607009 20251125200322_nhT3z ZA000C 2025-11-27T14:11:58.555Z 2025-12-04T15:06:53.630Z
8606849 8606849 20251125194917_54d14 ZA000C 2025-11-27T14:11:39.506Z 2025-12-04T15:06:51.437Z
8606413 8606413 20251125185324_fevoO ZA000C 2025-11-27T14:10:14.244Z 2025-12-04T15:06:45.306Z
8599560 8599560 20251125021030_EaI7S ZA000C 2025-11-26T14:21:15.639Z 2025-12-02T15:08:29.398Z
8599374 8599374 20251125020246_q0DAt ZA000C 2025-11-26T14:20:50.845Z 2025-12-02T15:08:23.674Z
8599209 8599209 20251125015325_121zq ZA000C 2025-11-26T14:20:39.449Z 2025-12-02T15:08:20.951Z
8599083 8599083 20251125014409_QbVDw ZA000C 2025-11-26T14:20:18.457Z 2025-12-02T15:08:19.732Z
8598953 8598953 20251125013652_KQxVV ZA000C 2025-11-26T14:20:06.377Z 2025-12-02T15:08:15.034Z
8598496 8598496 20251125010151_SGu99 ZA000C 2025-11-26T14:19:11.842Z 2025-12-02T15:07:55.676Z
8598446 8598446 20251125005731_ffObo ZA000C 2025-11-26T14:19:06.938Z 2025-12-02T15:07:54.576Z
8598421 8598421 20251125005617_B06KO ZA000C 2025-11-26T14:18:47.981Z 2025-12-02T15:07:54.001Z
8598148 8598148 20251125003903_0GGCM ZA000C 2025-11-26T14:18:22.408Z 2025-12-02T15:07:47.003Z
8598054 8598054 20251125003124_TvxfQ ZA000C 2025-11-26T14:18:03.395Z 2025-12-02T15:07:44.583Z
8597915 8597915 20251125001857_ZJLh9 ZA000C 2025-11-26T14:17:52.930Z 2025-12-02T15:07:43.463Z
8597790 8597790 20251125001247_zTGfc ZA000C 2025-11-26T14:17:42.761Z 2025-12-02T15:07:40.720Z
8597766 8597766 20251125001010_7FxyU ZA000C 2025-11-26T14:17:39.709Z 2025-12-02T15:07:40.635Z
8597764 8597764 20251125001005_Su0Tk ZA000C 2025-11-26T14:17:39.414Z 2025-12-02T15:07:40.533Z
8597706 8597706 20251125000239_477OL ZA000C 2025-11-26T14:17:24.689Z 2025-12-02T15:07:40.083Z
8597702 8597702 20251125000127_cPEsB ZA000C 2025-11-26T14:17:24.104Z 2025-12-02T15:07:39.916Z
8597434 8597434 20251124233529_QIvP9 ZA000C 2025-11-26T14:16:48.970Z 2025-12-02T15:07:32.582Z
8597374 8597374 20251124233028_5szdy ZA000C 2025-11-26T14:16:44.116Z 2025-12-02T15:07:31.003Z
8597328 8597328 20251124232635_iQkDm ZA000C 2025-11-26T14:16:40.678Z 2025-12-02T15:07:30.031Z
8596992 8596992 20251124224319_Dk361 ZA000C 2025-11-26T14:15:52.223Z 2025-12-02T15:07:22.272Z
8596957 8596957 20251124223806_gAhGq ZA000C 2025-11-26T14:15:49.250Z 2025-12-02T15:07:20.519Z
8596880 8596880 20251124222100_uHwtE ZA000C 2025-11-26T14:15:40.627Z 2025-12-02T15:07:15.522Z
8596813 8596813 20251124221043_tmSzo ZA000C 2025-11-26T14:15:22.450Z 2025-12-02T15:07:15.059Z
8596773 8596773 20251124220350_7kxig ZA000C 2025-11-26T14:15:17.218Z 2025-12-02T15:07:12.285Z
8596751 8596751 20251124220205_rjcdB ZA000C 2025-11-26T14:15:14.997Z 2025-12-02T15:07:09.354Z
8596503 8596503 20251124211457_RuCj1 ZA000C 2025-11-26T14:14:38.964Z 2025-12-02T15:06:55.743Z
8596230 8596230 20251124202809_JMILM ZA000C 2025-11-26T14:14:01.442Z 2025-12-02T15:06:50.166Z
8589637 8589637 20251124014502_aX1uY ZA000C 2025-11-25T14:20:17.048Z 2025-12-02T15:12:33.068Z
8589439 8589439 20251124013459_USl4W ZA000C 2025-11-25T14:20:05.069Z 2025-12-02T15:12:31.001Z
8589218 8589218 20251124011506_f1LP5 ZA000C 2025-11-25T14:19:28.741Z 2025-12-02T15:12:11.633Z
8589019 8589019 20251124005242_ipjYE ZA000C 2025-11-25T14:18:53.256Z 2025-12-02T15:12:03.716Z
8588608 8588608 20251124001623_6SCfA ZA000C 2025-11-25T14:18:03.269Z 2025-12-02T15:11:49.806Z
8588581 8588581 20251124001212_2GnnW ZA000C 2025-11-25T14:17:49.772Z 2025-12-02T15:11:49.333Z
8588545 8588545 20251124000652_uumEl ZA000C 2025-11-25T14:17:44.725Z 2025-12-02T15:11:49.187Z
8588543 8588543 20251124000651_L3EWk ZA000C 2025-11-25T14:17:44.197Z 2025-12-02T15:11:49.179Z
8572056 8572056 20251121232554_6ZlxZ ZA000C 2025-11-23T14:37:56.866Z 2025-11-30T15:05:35.104Z
8566702 8566702 20251122015509_2gLVc ZA000C 2025-11-23T14:17:05.657Z 2025-11-30T15:06:05.579Z
8566691 8566691 20251122015230_N9X1r ZA000C 2025-11-23T14:17:04.229Z 2025-11-30T15:06:04.707Z
8566683 8566683 20251122014719_wEYvX ZA000C 2025-11-23T14:17:02.849Z 2025-11-30T15:06:04.295Z
8566670 8566670 20251122014310_eAYqy ZA000C 2025-11-23T14:17:01.106Z 2025-11-30T15:06:01.079Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE participating_station
(
    meteor_unique_trajectory_identifier text     NOT NULL,
    station_code                        text     NOT NULL,
    created_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    updated_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier),
    FOREIGN KEY (station_code) REFERENCES station (code),
    UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE
);
CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier);
CREATE INDEX participating_station_created_at_index ON participating_station (created_at);
CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network