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

612 rows where station_code = "AU004M" 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
9270717 9270717 20260128165049_BjGQt AU004M 2026-01-29T14:13:31.080Z 2026-01-29T14:13:31.080Z
9261841 9261841 20260126135219_qPXjY AU004M 2026-01-27T14:05:58.165Z 2026-01-29T14:33:09.659Z
9247073 9247073 20260121164855_1ca08 AU004M 2026-01-23T14:08:58.474Z 2026-01-29T14:55:41.405Z
9246232 9246232 20260122181119_sGsmU AU004M 2026-01-23T14:05:19.620Z 2026-01-29T14:50:59.798Z
9246185 9246185 20260122174509_z0LKU AU004M 2026-01-23T14:05:10.274Z 2026-01-29T14:50:52.298Z
9245273 9245273 20260122113307_A3Rny AU004M 2026-01-23T14:01:17.112Z 2026-01-29T14:49:19.761Z
9233520 9233520 20260120174712_E027K AU004M 2026-01-21T14:06:07.836Z 2026-01-29T15:01:54.611Z
9233512 9233512 20260120172414_7x4RR AU004M 2026-01-21T14:06:05.939Z 2026-01-29T15:01:38.403Z
9233368 9233368 20260120150045_ZAHa4 AU004M 2026-01-21T14:05:32.130Z 2026-01-29T15:01:03.172Z
9233334 9233334 20260120144800_VyUG1 AU004M 2026-01-21T14:05:24.347Z 2026-01-29T15:01:01.032Z
9233198 9233198 20260120133532_NC3gt AU004M 2026-01-21T14:04:49.907Z 2026-01-29T15:00:48.831Z
9232871 9232871 20260120124334_hSIjn AU004M 2026-01-21T14:03:37.135Z 2026-01-29T15:00:21.533Z
9227422 9227422 20260119172217_bKKW0 AU004M 2026-01-20T14:08:13.317Z 2026-01-28T14:56:25.911Z
9227394 9227394 20260119164805_Hhd4j AU004M 2026-01-20T14:08:04.593Z 2026-01-28T14:56:21.671Z
9227151 9227151 20260119145041_aMzOS AU004M 2026-01-20T14:06:49.273Z 2026-01-20T14:06:49.273Z
9227143 9227143 20260119144624_FfQaF AU004M 2026-01-20T14:06:45.931Z 2026-01-28T14:55:53.632Z
9226867 9226867 20260119132106_VOChr AU004M 2026-01-20T14:05:27.275Z 2026-01-20T14:05:27.275Z
9226856 9226856 20260119132011_aQtzp AU004M 2026-01-20T14:05:23.940Z 2026-01-28T14:55:32.280Z
9226632 9226632 20260119123648_Eu2KE AU004M 2026-01-20T14:04:18.409Z 2026-01-28T14:55:19.517Z
9216809 9216809 20260117125959_JBHe9 AU004M 2026-01-18T14:02:44.162Z 2026-01-26T14:59:27.948Z
9174144 9174144 20260110154025_q45jK AU004M 2026-01-11T14:01:34.239Z 2026-01-19T15:14:37.791Z
9173559 9173559 20260109144711_VCG31 AU004M 2026-01-10T14:18:02.888Z 2026-01-17T15:26:49.927Z
9173553 9173553 20260109144249_iUDoz AU004M 2026-01-10T14:17:59.263Z 2026-01-17T15:26:49.372Z
9170879 9170879 20260108172753_ez4UA AU004M 2026-01-10T14:03:52.537Z 2026-01-17T15:23:09.011Z
9169679 9169679 20260108152308_akwi2 AU004M 2026-01-09T14:14:20.658Z 2026-01-16T15:14:24.631Z
9168771 9168771 20260108121015_xOj35 AU004M 2026-01-09T14:11:58.637Z 2026-01-16T15:13:02.808Z
9168411 9168411 20260108105546_QU3Pm AU004M 2026-01-09T14:11:02.600Z 2026-01-16T15:12:34.206Z
9165998 9165998 20260108155537_C2916 AU004M 2026-01-09T14:00:48.019Z 2026-01-17T15:22:50.983Z
9165978 9165978 20260108155126_e22l3 AU004M 2026-01-09T14:00:41.649Z 2026-01-17T15:22:49.935Z
9161876 9161876 20260107160048_2oTpK AU004M 2026-01-08T14:00:09.278Z 2026-01-16T15:09:12.032Z
9161356 9161356 20260106123753_U1gU2 AU004M 2026-01-07T14:16:10.211Z 2026-01-13T15:10:40.973Z
9161269 9161269 20260106120234_MIOtd AU004M 2026-01-07T14:15:48.712Z 2026-01-13T15:10:29.244Z
9161139 9161139 20260106110458_Sfcfp AU004M 2026-01-07T14:15:15.277Z 2026-01-13T15:10:20.048Z
9107794 9107794 20251229171527_i2O07 AU004M 2025-12-31T14:41:58.573Z 2025-12-31T14:41:58.573Z
9107411 9107411 20251229154818_SbmlQ AU004M 2025-12-31T14:40:49.093Z 2026-01-06T15:20:45.410Z
9107400 9107400 20251229154430_853xZ AU004M 2025-12-31T14:40:47.790Z 2026-01-06T15:20:45.048Z
9106342 9106342 20251230171123_JPKH0 AU004M 2025-12-31T14:28:34.019Z 2026-01-07T15:12:17.199Z
9106304 9106304 20251230170416_TlecI AU004M 2025-12-31T14:28:27.874Z 2026-01-07T15:12:15.218Z
9106202 9106202 20251230162040_iNBJv AU004M 2025-12-31T14:28:05.579Z 2026-01-07T15:11:56.701Z
9106115 9106115 20251230154202_juQzx AU004M 2025-12-31T14:27:45.493Z 2026-01-07T15:11:46.683Z
9106085 9106085 20251230152519_d1jor AU004M 2025-12-31T14:27:39.213Z 2026-01-01T14:58:01.400Z
9105333 9105333 20251230104148_331QB AU004M 2025-12-31T14:24:47.957Z 2026-01-07T15:10:42.747Z
9097360 9097360 20251227161058_yK3lK AU004M 2025-12-30T15:08:35.177Z 2026-01-04T15:33:51.181Z
9096872 9096872 20251227151300_KNVoc AU004M 2025-12-30T15:08:00.763Z 2026-01-04T15:33:26.818Z
9094881 9094881 20251227131016_Z1naq AU004M 2025-12-30T15:05:55.494Z 2026-01-04T15:32:07.592Z
8991871 8991871 20251218174927_g0KEQ AU004M 2025-12-26T14:49:53.114Z 2025-12-27T15:25:25.952Z
8991490 8991490 20251218165113_cIXoH AU004M 2025-12-26T14:48:56.582Z 2025-12-27T15:24:58.833Z
8991190 8991190 20251218160709_XOLHP AU004M 2025-12-26T14:48:11.451Z 2025-12-26T14:48:11.451Z
8991131 8991131 20251218155915_q28Q0 AU004M 2025-12-26T14:48:04.570Z 2025-12-27T15:24:38.164Z
8990765 8990765 20251218145817_FtGoi AU004M 2025-12-26T14:47:04.164Z 2025-12-27T15:24:20.135Z
8990590 8990590 20251218142337_fYOnj AU004M 2025-12-26T14:46:46.618Z 2025-12-27T15:24:10.430Z
8990513 8990513 20251218140520_6Qks1 AU004M 2025-12-26T14:46:28.524Z 2025-12-27T15:24:05.778Z
8981145 8981145 20251219164638_QXU29 AU004M 2025-12-26T14:23:58.945Z 2025-12-28T15:20:55.174Z
8981130 8981130 20251219164244_s8VPN AU004M 2025-12-26T14:23:51.035Z 2025-12-28T15:20:53.481Z
8938439 8938439 20251214172734_ZaXAT AU004M 2025-12-24T14:54:07.097Z 2025-12-24T14:54:07.097Z
8938412 8938412 20251214172623_1IycT AU004M 2025-12-24T14:54:06.763Z 2025-12-24T14:54:06.763Z
8938210 8938210 20251214172036_cF8Z9 AU004M 2025-12-24T14:53:56.757Z 2025-12-24T14:53:56.757Z
8938058 8938058 20251214171653_vbPBG AU004M 2025-12-24T14:53:51.539Z 2025-12-24T14:53:51.539Z
8937730 8937730 20251214170824_JXSi3 AU004M 2025-12-24T14:53:42.553Z 2025-12-24T14:53:42.553Z
8937380 8937380 20251214165707_yDPP7 AU004M 2025-12-24T14:52:56.092Z 2025-12-24T14:52:56.092Z
8936608 8936608 20251214163508_gIuK4 AU004M 2025-12-24T14:51:47.719Z 2025-12-24T14:51:47.719Z
8936556 8936556 20251214163345_3qAPE AU004M 2025-12-24T14:51:31.074Z 2025-12-24T14:51:31.074Z
8936291 8936291 20251214162709_7dUCy AU004M 2025-12-24T14:51:06.461Z 2025-12-24T14:51:06.461Z
8936022 8936022 20251214162019_stliv AU004M 2025-12-24T14:50:53.918Z 2025-12-24T14:50:53.918Z
8935042 8935042 20251214154946_oA8Kd AU004M 2025-12-24T14:50:29.873Z 2025-12-24T14:50:29.873Z
8933885 8933885 20251214151624_qRvpX AU004M 2025-12-24T14:49:17.737Z 2025-12-24T14:49:17.737Z
8932365 8932365 20251214143623_ztEJ5 AU004M 2025-12-24T14:47:44.620Z 2025-12-24T14:47:44.620Z
8931310 8931310 20251214140724_LoT59 AU004M 2025-12-24T14:46:33.540Z 2025-12-24T14:46:33.540Z
8931011 8931011 20251214135850_jNucY AU004M 2025-12-24T14:46:23.722Z 2025-12-24T14:46:23.722Z
8929579 8929579 20251214131441_IhlSs AU004M 2025-12-24T14:44:56.526Z 2025-12-24T14:44:56.526Z
8924144 8924144 20251214122049_TrFP3 AU004M 2025-12-23T14:15:19.774Z 2025-12-24T14:41:35.700Z
8924112 8924112 20251214122014_vDEwG AU004M 2025-12-23T14:15:16.807Z 2025-12-24T14:41:34.280Z
8923592 8923592 20251214121152_KrvQQ AU004M 2025-12-23T14:14:53.369Z 2025-12-24T14:40:26.485Z
8766072 8766072 20251212160411_gL2G7 AU004M 2025-12-14T14:52:02.112Z 2025-12-21T14:17:25.906Z
8766053 8766053 20251212160252_f3gf0 AU004M 2025-12-14T14:52:00.193Z 2025-12-21T14:17:25.897Z
8763879 8763879 20251212140445_b3Q2c AU004M 2025-12-14T14:46:49.538Z 2025-12-21T14:17:25.291Z
8763563 8763563 20251212134625_3Y3AU AU004M 2025-12-14T14:46:07.731Z 2025-12-21T14:17:25.213Z
8763376 8763376 20251212133711_Bb5Yv AU004M 2025-12-14T14:45:33.308Z 2025-12-21T14:17:25.165Z
8763255 8763255 20251212132937_g4rPc AU004M 2025-12-14T14:45:25.124Z 2025-12-21T14:17:25.128Z
8762004 8762004 20251212122609_a2VFM AU004M 2025-12-14T14:40:24.768Z 2025-12-21T14:17:24.648Z
8747960 8747960 20251209112614_dh4sk AU004M 2025-12-13T15:33:30.085Z 2025-12-17T15:24:45.098Z
8704997 8704997 20251208173636_Ve16c AU004M 2025-12-09T14:15:53.026Z 2025-12-17T15:32:02.938Z
8704773 8704773 20251208165645_r39Lh AU004M 2025-12-09T14:15:23.658Z 2025-12-17T15:32:01.012Z
8704677 8704677 20251208163443_S34uJ AU004M 2025-12-09T14:15:12.014Z 2025-12-17T15:31:59.715Z
8704673 8704673 20251208163226_3Pcn2 AU004M 2025-12-09T14:15:11.374Z 2025-12-17T15:31:59.509Z
8704571 8704571 20251208160425_B9qx2 AU004M 2025-12-09T14:15:01.107Z 2025-12-17T15:31:55.422Z
8704418 8704418 20251208153434_hgPW1 AU004M 2025-12-09T14:14:28.665Z 2025-12-17T15:31:54.299Z
8703326 8703326 20251208131224_dd4l5 AU004M 2025-12-09T14:11:35.379Z 2025-12-17T15:31:42.905Z
8702870 8702870 20251208121007_CTxDE AU004M 2025-12-09T14:09:54.585Z 2025-12-17T15:31:37.350Z
8702161 8702161 20251208105554_69B5u AU004M 2025-12-09T14:07:39.466Z 2025-12-17T15:31:06.010Z
8683533 8683533 20251130150750_mjJsf AU004M 2025-12-04T14:29:45.099Z 2025-12-09T14:55:28.043Z
8683529 8683529 20251130150627_kq3hy AU004M 2025-12-04T14:29:44.113Z 2025-12-09T14:55:27.463Z
8683518 8683518 20251130143712_KpcXx AU004M 2025-12-04T14:29:33.678Z 2025-12-09T14:55:19.873Z
8683516 8683516 20251130143239_6BjYu AU004M 2025-12-04T14:29:25.480Z 2025-12-09T14:55:19.337Z
8670360 8670360 20251202174114_vqs5h AU004M 2025-12-03T14:08:10.231Z 2025-12-11T14:44:25.130Z
8670328 8670328 20251202165337_jLmj5 AU004M 2025-12-03T14:08:00.167Z 2025-12-11T14:43:55.984Z
8670268 8670268 20251202155448_yuZHO AU004M 2025-12-03T14:07:47.089Z 2025-12-11T14:43:51.126Z
8669237 8669237 20251202103600_pw8ds AU004M 2025-12-03T14:02:57.864Z 2025-12-11T14:42:51.518Z
8532935 8532935 20251119172014_D2E1J AU004M 2025-11-21T14:09:20.885Z 2025-11-28T14:54:03.399Z
8532617 8532617 20251119163017_LFc38 AU004M 2025-11-21T14:08:23.565Z 2025-11-28T14:53:59.569Z

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