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

4,514 rows where station_code = "ZA0007" 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
8687044 8687044 20251204021705_FD8yu ZA0007 2025-12-05T14:13:43.093Z 2025-12-05T14:14:35.585Z
8687026 8687026 20251204014726_IcHKe ZA0007 2025-12-05T14:13:30.078Z 2025-12-05T14:14:35.572Z
8687016 8687016 20251204012816_RcXyz ZA0007 2025-12-05T14:13:27.579Z 2025-12-05T14:14:35.566Z
8687014 8687014 20251204012442_9CMX3 ZA0007 2025-12-05T14:13:27.236Z 2025-12-05T14:14:35.565Z
8687010 8687010 20251204011541_4lntX ZA0007 2025-12-05T14:13:25.222Z 2025-12-05T14:14:35.562Z
8687003 8687003 20251204005834_xr0eV ZA0007 2025-12-05T14:13:22.176Z 2025-12-05T14:14:35.550Z
8687001 8687001 20251204004629_mgVV3 ZA0007 2025-12-05T14:13:21.828Z 2025-12-05T14:14:35.548Z
8686994 8686994 20251204003244_Bioui ZA0007 2025-12-05T14:13:20.916Z 2025-12-05T14:14:35.545Z
8686986 8686986 20251204001447_XBagU ZA0007 2025-12-05T14:13:19.607Z 2025-12-05T14:14:35.541Z
8686981 8686981 20251203235723_5u6dl ZA0007 2025-12-05T14:13:18.880Z 2025-12-05T14:14:35.539Z
8686967 8686967 20251203225818_ln833 ZA0007 2025-12-05T14:13:16.844Z 2025-12-05T14:14:35.533Z
8686961 8686961 20251203215315_c2jdW ZA0007 2025-12-05T14:13:15.664Z 2025-12-05T14:14:35.530Z
8674153 8674153 20251202013701_puVW2 ZA0007 2025-12-03T14:21:01.242Z 2025-12-05T14:27:30.798Z
8674027 8674027 20251202011210_3xTV6 ZA0007 2025-12-03T14:20:46.410Z 2025-12-05T14:27:26.799Z
8674025 8674025 20251202011205_jCie0 ZA0007 2025-12-03T14:20:46.176Z 2025-12-05T14:27:26.707Z
8673999 8673999 20251202010148_c8yqt ZA0007 2025-12-03T14:20:42.655Z 2025-12-05T14:27:25.536Z
8673882 8673882 20251202001529_Y2Sbi ZA0007 2025-12-03T14:20:14.316Z 2025-12-05T14:27:21.314Z
8664701 8664701 20251201012807_UnV3p ZA0007 2025-12-02T14:21:50.977Z 2025-12-05T14:35:15.069Z
8664573 8664573 20251201005827_gm1Az ZA0007 2025-12-02T14:21:30.408Z 2025-12-05T14:35:08.971Z
8664228 8664228 20251130234821_pp3n7 ZA0007 2025-12-02T14:20:32.347Z 2025-12-05T14:34:57.648Z
8623209 8623209 20251126232115_9u2Mb ZA0007 2025-11-28T14:21:05.489Z 2025-12-05T15:03:38.264Z
8622735 8622735 20251126205549_UUc7l ZA0007 2025-11-28T14:19:46.400Z 2025-12-05T15:03:05.598Z
8611511 8611511 20251126014942_aWhlL ZA0007 2025-11-27T14:22:15.300Z 2025-12-04T15:09:21.804Z
8610983 8610983 20251126011704_ZI5JJ ZA0007 2025-11-27T14:21:01.357Z 2025-12-04T15:08:47.455Z
8610980 8610980 20251126011641_g5yKA ZA0007 2025-11-27T14:21:00.969Z 2025-12-04T15:08:47.293Z
8610570 8610570 20251126005734_HeJIk ZA0007 2025-11-27T14:20:24.141Z 2025-12-04T15:08:14.193Z
8610165 8610165 20251126002726_TTB2D ZA0007 2025-11-27T14:19:32.514Z 2025-12-04T15:08:03.060Z
8610148 8610148 20251126002625_sxTYp ZA0007 2025-11-27T14:19:30.441Z 2025-12-04T15:08:02.803Z
8609659 8609659 20251125235827_ULqYb ZA0007 2025-11-27T14:18:48.126Z 2025-12-04T15:07:56.512Z
8609634 8609634 20251125235659_0vqhz ZA0007 2025-11-27T14:18:45.178Z 2025-12-04T15:07:56.172Z
8609515 8609515 20251125234643_iIqxT ZA0007 2025-11-27T14:18:18.205Z 2025-12-04T15:07:54.924Z
8609485 8609485 20251125234603_5KJ2V ZA0007 2025-11-27T14:18:16.572Z 2025-12-04T15:07:54.752Z
8609426 8609426 20251125233931_3M7mg ZA0007 2025-11-27T14:18:10.873Z 2025-12-04T15:07:54.144Z
8609205 8609205 20251125232110_lupA2 ZA0007 2025-11-27T14:17:46.241Z 2025-12-04T15:07:52.574Z
8609024 8609024 20251125230730_n6JG0 ZA0007 2025-11-27T14:17:27.361Z 2025-12-04T15:07:50.799Z
8608967 8608967 20251125230124_v7gOd ZA0007 2025-11-27T14:17:10.995Z 2025-12-04T15:07:50.279Z
8608962 8608962 20251125230014_5zkQS ZA0007 2025-11-27T14:17:09.006Z 2025-12-04T15:07:50.201Z
8608800 8608800 20251125224644_YTCrz ZA0007 2025-11-27T14:16:52.953Z 2025-12-04T15:07:48.751Z
8608556 8608556 20251125222713_hv3hx ZA0007 2025-11-27T14:16:16.619Z 2025-12-04T15:07:46.326Z
8608239 8608239 20251125220313_3uECm ZA0007 2025-11-27T14:15:35.951Z 2025-12-04T15:07:42.928Z
8608012 8608012 20251125214405_Aco5j ZA0007 2025-11-27T14:15:05.318Z 2025-12-04T15:07:40.217Z
8607697 8607697 20251125211404_pmpfY ZA0007 2025-11-27T14:14:22.290Z 2025-12-04T15:07:17.884Z
8607640 8607640 20251125210838_WbsF4 ZA0007 2025-11-27T14:14:07.850Z 2025-12-04T15:07:10.452Z
8607590 8607590 20251125210458_880l6 ZA0007 2025-11-27T14:14:00.143Z 2025-12-04T15:07:04.104Z
8607008 8607008 20251125200322_nhT3z ZA0007 2025-11-27T14:11:58.555Z 2025-12-04T15:06:53.630Z
8606845 8606845 20251125194813_xCl1C ZA0007 2025-11-27T14:11:38.388Z 2025-12-04T15:06:51.356Z
8606787 8606787 20251125194125_da8ml ZA0007 2025-11-27T14:11:25.489Z 2025-12-04T15:06:50.518Z
8599559 8599559 20251125021030_EaI7S ZA0007 2025-11-26T14:21:15.639Z 2025-12-02T15:08:29.398Z
8599373 8599373 20251125020246_q0DAt ZA0007 2025-11-26T14:20:50.845Z 2025-12-02T15:08:23.674Z
8599082 8599082 20251125014409_QbVDw ZA0007 2025-11-26T14:20:18.457Z 2025-12-02T15:08:19.732Z
8598887 8598887 20251125013326_hxJIu ZA0007 2025-11-26T14:20:02.570Z 2025-12-02T15:08:11.745Z
8598718 8598718 20251125012051_1YVSZ ZA0007 2025-11-26T14:19:31.902Z 2025-12-02T15:08:06.033Z
8598686 8598686 20251125011901_O2WlJ ZA0007 2025-11-26T14:19:28.353Z 2025-12-02T15:08:03.403Z
8598539 8598539 20251125010326_i4nsX ZA0007 2025-11-26T14:19:14.411Z 2025-12-02T15:08:00.794Z
8598495 8598495 20251125010151_SGu99 ZA0007 2025-11-26T14:19:11.842Z 2025-12-02T15:07:55.676Z
8598420 8598420 20251125005617_B06KO ZA0007 2025-11-26T14:18:47.981Z 2025-12-02T15:07:54.001Z
8598348 8598348 20251125005147_m4z5d ZA0007 2025-11-26T14:18:39.809Z 2025-12-02T15:07:52.537Z
8598053 8598053 20251125003124_TvxfQ ZA0007 2025-11-26T14:18:03.395Z 2025-12-02T15:07:44.582Z
8597914 8597914 20251125001857_ZJLh9 ZA0007 2025-11-26T14:17:52.930Z 2025-12-02T15:07:43.463Z
8597701 8597701 20251125000127_cPEsB ZA0007 2025-11-26T14:17:24.104Z 2025-12-02T15:07:39.916Z
8597433 8597433 20251124233529_QIvP9 ZA0007 2025-11-26T14:16:48.970Z 2025-12-02T15:07:32.582Z
8597373 8597373 20251124233028_5szdy ZA0007 2025-11-26T14:16:44.116Z 2025-12-02T15:07:31.003Z
8597199 8597199 20251124231239_l1tvv ZA0007 2025-11-26T14:16:20.326Z 2025-12-02T15:07:24.195Z
8596991 8596991 20251124224319_Dk361 ZA0007 2025-11-26T14:15:52.223Z 2025-12-02T15:07:22.272Z
8596812 8596812 20251124221043_tmSzo ZA0007 2025-11-26T14:15:22.450Z 2025-12-02T15:07:15.059Z
8596779 8596779 20251124220509_KfEGq ZA0007 2025-11-26T14:15:18.012Z 2025-12-02T15:07:12.759Z
8596750 8596750 20251124220205_rjcdB ZA0007 2025-11-26T14:15:14.997Z 2025-12-02T15:07:09.354Z
8596502 8596502 20251124211457_RuCj1 ZA0007 2025-11-26T14:14:38.964Z 2025-12-02T15:06:55.743Z
8595967 8595967 20251124191628_WbLrH ZA0007 2025-11-26T14:13:12.580Z 2025-12-02T15:06:24.289Z
8590107 8590107 20251124022247_w5xJO ZA0007 2025-11-25T14:21:24.230Z 2025-12-02T15:12:42.436Z
8589636 8589636 20251124014502_aX1uY ZA0007 2025-11-25T14:20:17.048Z 2025-12-02T15:12:33.068Z
8589238 8589238 20251124011728_65jcD ZA0007 2025-11-25T14:19:31.533Z 2025-12-02T15:12:14.495Z
8589217 8589217 20251124011506_f1LP5 ZA0007 2025-11-25T14:19:28.741Z 2025-12-02T15:12:11.633Z
8589124 8589124 20251124010428_4VuMi ZA0007 2025-11-25T14:19:06.660Z 2025-12-02T15:12:09.076Z
8589018 8589018 20251124005242_ipjYE ZA0007 2025-11-25T14:18:53.256Z 2025-12-02T15:12:03.716Z
8588750 8588750 20251124002829_qGuvm ZA0007 2025-11-25T14:18:14.191Z 2025-12-02T15:11:51.497Z
8588710 8588710 20251124002713_PrUwj ZA0007 2025-11-25T14:18:11.543Z 2025-12-02T15:11:51.046Z
8588225 8588225 20251123233354_henTF ZA0007 2025-11-25T14:17:06.084Z 2025-12-02T15:11:34.144Z
8588196 8588196 20251123233241_Lm2k2 ZA0007 2025-11-25T14:17:02.851Z 2025-12-02T15:11:33.629Z
8588137 8588137 20251123232720_e9j7M ZA0007 2025-11-25T14:16:56.789Z 2025-12-02T15:11:28.017Z
8588075 8588075 20251123231919_3faQV ZA0007 2025-11-25T14:16:51.230Z 2025-12-02T15:11:25.113Z
8587398 8587398 20251123215903_zC0xT ZA0007 2025-11-25T14:15:15.575Z 2025-12-02T15:11:12.331Z
8587363 8587363 20251123215356_1Hdtl ZA0007 2025-11-25T14:15:04.290Z 2025-12-02T15:11:11.490Z
8587227 8587227 20251123213830_9kIBr ZA0007 2025-11-25T14:14:53.622Z 2025-12-02T15:11:09.628Z
8586907 8586907 20251123210311_NGx7e ZA0007 2025-11-25T14:14:07.729Z 2025-12-02T15:11:04.089Z
8586806 8586806 20251123205334_cm5Nk ZA0007 2025-11-25T14:13:58.698Z 2025-12-02T15:11:03.326Z
8578094 8578094 20251122193941_5Hj6i ZA0007 2025-11-24T14:10:44.101Z 2025-12-01T15:19:08.628Z
8566686 8566686 20251122014813_rhKeS ZA0007 2025-11-23T14:17:03.577Z 2025-11-30T15:06:04.350Z
8566682 8566682 20251122014719_wEYvX ZA0007 2025-11-23T14:17:02.849Z 2025-11-30T15:06:04.295Z
8566628 8566628 20251122013515_pr2KW ZA0007 2025-11-23T14:16:53.245Z 2025-11-30T15:05:57.312Z
8566500 8566500 20251122005218_860sp ZA0007 2025-11-23T14:16:26.099Z 2025-11-30T15:05:50.690Z
8566244 8566244 20251121234542_xcAYx ZA0007 2025-11-23T14:15:34.752Z 2025-11-30T15:05:39.620Z
8566139 8566139 20251121230437_ycA3Z ZA0007 2025-11-23T14:15:09.223Z 2025-11-30T15:05:29.427Z
8566134 8566134 20251121230122_dbJk6 ZA0007 2025-11-23T14:15:08.750Z 2025-11-30T15:05:29.363Z
8566091 8566091 20251121224636_8rgoH ZA0007 2025-11-23T14:15:02.380Z 2025-11-30T15:05:25.366Z
8565978 8565978 20251121221611_Jjjun ZA0007 2025-11-23T14:14:41.205Z 2025-11-30T15:05:19.810Z
8565928 8565928 20251121220349_bXvl4 ZA0007 2025-11-23T14:14:33.044Z 2025-11-30T15:05:18.154Z
8565869 8565869 20251121214657_92I7u ZA0007 2025-11-23T14:14:24.520Z 2025-11-30T15:05:12.048Z
8565820 8565820 20251121213333_W6sxp ZA0007 2025-11-23T14:14:19.180Z 2025-11-30T15:05:11.122Z
8565810 8565810 20251121212442_XQOG5 ZA0007 2025-11-23T14:14:17.646Z 2025-11-30T15:05:10.592Z

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