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

7,831 rows where station_code = "AU003J" 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
8369222 8369222 20251103195051_E1EMt AU003J 2025-11-05T14:06:07.076Z 2025-11-12T15:09:02.912Z
8369100 8369100 20251103190204_Co72F AU003J 2025-11-05T14:05:33.383Z 2025-11-12T15:08:54.187Z
8369091 8369091 20251103190007_gKJCz AU003J 2025-11-05T14:05:31.607Z 2025-11-12T15:08:52.416Z
8369080 8369080 20251103185649_KU30l AU003J 2025-11-05T14:05:29.840Z 2025-11-12T15:08:51.518Z
8369065 8369065 20251103184340_0nApl AU003J 2025-11-05T14:05:26.628Z 2025-11-12T15:08:50.638Z
8369062 8369062 20251103184213_b2hJv AU003J 2025-11-05T14:05:26.112Z 2025-11-12T15:08:50.620Z
8369050 8369050 20251103183651_PFn2M AU003J 2025-11-05T14:05:17.908Z 2025-11-12T15:08:49.879Z
8369039 8369039 20251103183052_Z2HHM AU003J 2025-11-05T14:05:15.533Z 2025-11-12T15:08:49.634Z
8369025 8369025 20251103182143_TxT74 AU003J 2025-11-05T14:05:08.837Z 2025-11-12T15:08:47.723Z
8368888 8368888 20251103171903_J2vLC AU003J 2025-11-05T14:04:24.984Z 2025-11-12T15:08:45.099Z
8368881 8368881 20251103171642_XPdLI AU003J 2025-11-05T14:04:23.476Z 2025-11-12T15:08:44.943Z
8368875 8368875 20251103171536_FLkM7 AU003J 2025-11-05T14:04:21.959Z 2025-11-12T15:08:44.787Z
8368853 8368853 20251103170754_fWM1t AU003J 2025-11-05T14:04:17.684Z 2025-11-12T15:08:44.305Z
8368821 8368821 20251103165702_Qyzwz AU003J 2025-11-05T14:04:01.742Z 2025-11-12T15:08:43.507Z
8368794 8368794 20251103163751_avko3 AU003J 2025-11-05T14:03:51.101Z 2025-11-12T15:08:41.167Z
8368792 8368792 20251103163651_9p6Fm AU003J 2025-11-05T14:03:50.341Z 2025-11-12T15:08:40.953Z
8368790 8368790 20251103163439_QImzW AU003J 2025-11-05T14:03:49.983Z 2025-11-12T15:08:40.895Z
8368788 8368788 20251103163226_TYGCS AU003J 2025-11-05T14:03:49.448Z 2025-11-12T15:08:40.840Z
8368728 8368728 20251103155919_lrqD8 AU003J 2025-11-05T14:03:40.006Z 2025-11-12T15:08:39.863Z
8368691 8368691 20251103155359_AlMnq AU003J 2025-11-05T14:03:34.462Z 2025-11-12T15:08:39.284Z
8368673 8368673 20251103154941_iWkkw AU003J 2025-11-05T14:03:23.771Z 2025-11-12T15:08:38.912Z
8368587 8368587 20251103153318_QNSzi AU003J 2025-11-05T14:03:05.038Z 2025-11-12T15:08:37.764Z
8368585 8368585 20251103153215_5lMmn AU003J 2025-11-05T14:03:04.449Z 2025-11-12T15:08:37.708Z
8368545 8368545 20251103152533_1dFic AU003J 2025-11-05T14:02:56.833Z 2025-11-12T15:08:37.066Z
8368468 8368468 20251103151132_vcSKO AU003J 2025-11-05T14:02:38.531Z 2025-11-12T15:08:35.815Z
8368447 8368447 20251103150845_B0Sag AU003J 2025-11-05T14:02:34.096Z 2025-11-12T15:08:35.542Z
8368421 8368421 20251103150503_DyoTU AU003J 2025-11-05T14:02:30.016Z 2025-11-12T15:08:35.328Z
8368258 8368258 20251103142928_3Zu3U AU003J 2025-11-05T14:01:53.692Z 2025-11-12T15:08:33.442Z
8368256 8368256 20251103142914_LafsU AU003J 2025-11-05T14:01:53.245Z 2025-11-12T15:08:33.409Z
8368170 8368170 20251103140823_hkABA AU003J 2025-11-05T14:01:34.579Z 2025-11-12T15:08:32.211Z
8368161 8368161 20251103140543_mO2Aq AU003J 2025-11-05T14:01:31.996Z 2025-11-12T15:08:31.978Z
8231842 8231842 20251025193432_x48kt AU003J 2025-10-27T12:09:03.234Z 2025-11-03T15:15:48.081Z
8157047 8157047 20251018201015_I2JLv AU003J 2025-10-21T12:20:14.898Z 2025-10-27T13:09:46.758Z
8142014 8142014 20251018202105_PFf3Q AU003J 2025-10-20T12:09:29.931Z 2025-10-27T13:09:47.684Z
8141972 8141972 20251018201338_LX3fr AU003J 2025-10-20T12:09:21.787Z 2025-10-27T13:09:47.238Z
8141966 8141966 20251018201227_2MPM6 AU003J 2025-10-20T12:09:20.736Z 2025-10-27T13:09:46.895Z
8141871 8141871 20251018195943_DEE5G AU003J 2025-10-20T12:08:57.185Z 2025-10-27T13:09:45.879Z
8141375 8141375 20251018182447_jMChs AU003J 2025-10-20T12:06:52.924Z 2025-10-27T13:09:39.470Z
8141275 8141275 20251018180035_3C2Zz AU003J 2025-10-20T12:06:23.635Z 2025-10-27T13:09:38.616Z
8140936 8140936 20251018154828_ckVdy AU003J 2025-10-20T12:04:51.031Z 2025-10-27T13:09:33.295Z
7936952 7936952 20250920160740_NnL3x AU003J 2025-09-24T12:58:38.795Z 2025-09-29T13:04:36.293Z
7902562 7902562 20250920180459_S29oe AU003J 2025-09-22T12:28:44.090Z 2025-09-29T13:04:41.863Z
7902408 7902408 20250920171345_YPzJu AU003J 2025-09-22T12:28:08.791Z 2025-09-29T13:04:38.071Z
7902239 7902239 20250920161305_CKp0w AU003J 2025-09-22T12:27:46.639Z 2025-09-29T13:04:36.317Z
7902118 7902118 20250920150254_4LlvO AU003J 2025-09-22T12:27:18.911Z 2025-09-29T13:04:34.590Z
7902024 7902024 20250920143054_SFgCr AU003J 2025-09-22T12:27:07.989Z 2025-09-29T13:04:33.433Z
7890558 7890558 20250919155553_kCBPB AU003J 2025-09-21T12:30:11.779Z 2025-09-28T12:54:05.246Z
7890507 7890507 20250919155201_O4u3P AU003J 2025-09-21T12:30:05.696Z 2025-09-28T12:54:05.049Z
7888787 7888787 20250919133538_csS9n AU003J 2025-09-21T12:27:43.752Z 2025-09-28T12:53:58.685Z
7888773 7888773 20250919133236_ULwC3 AU003J 2025-09-21T12:27:40.864Z 2025-09-28T12:53:58.634Z
7888215 7888215 20250919124420_frdmb AU003J 2025-09-21T12:26:42.042Z 2025-09-28T12:53:54.782Z
7888136 7888136 20250919123742_yuRY2 AU003J 2025-09-21T12:26:38.320Z 2025-09-28T12:53:54.412Z
7888121 7888121 20250919123633_1n330 AU003J 2025-09-21T12:26:36.974Z 2025-09-28T12:53:54.343Z
7888057 7888057 20250919123251_XaTBU AU003J 2025-09-21T12:26:30.400Z 2025-09-28T12:53:53.889Z
7887746 7887746 20250919115749_xI5LE AU003J 2025-09-21T12:25:59.552Z 2025-09-28T12:53:53.166Z
7883598 7883598 20250916204139_haZY9 AU003J 2025-09-20T12:50:55.610Z 2025-09-24T13:17:32.448Z
7883419 7883419 20250917190424_wTwxS AU003J 2025-09-20T12:43:37.609Z 2025-09-25T13:12:35.402Z
7883399 7883399 20250917182428_EMLJv AU003J 2025-09-20T12:43:22.304Z 2025-09-25T13:12:29.718Z
7877204 7877204 20250918114123_et33S AU003J 2025-09-20T12:25:20.236Z 2025-09-27T12:47:02.886Z
7870193 7870193 20250917211825_lMf5J AU003J 2025-09-19T12:28:09.860Z 2025-09-25T13:12:54.023Z
7870129 7870129 20250917210506_d9cvZ AU003J 2025-09-19T12:28:01.928Z 2025-09-25T13:12:52.971Z
7870021 7870021 20250917205233_lWooZ AU003J 2025-09-19T12:27:49.284Z 2025-09-25T13:12:51.915Z
7869291 7869291 20250917191042_H32aR AU003J 2025-09-19T12:25:23.752Z 2025-09-25T13:12:36.115Z
7869280 7869280 20250917190817_y3N3R AU003J 2025-09-19T12:25:22.305Z 2025-09-25T13:12:35.439Z
7869119 7869119 20250917182428_ojivP AU003J 2025-09-19T12:24:53.542Z 2025-09-19T12:32:28.454Z
7869047 7869047 20250917175910_mw4W8 AU003J 2025-09-19T12:24:38.202Z 2025-09-25T13:12:25.157Z
7869045 7869045 20250917175810_l8bWA AU003J 2025-09-19T12:24:37.969Z 2025-09-25T13:12:25.031Z
7868775 7868775 20250917160855_4aZyx AU003J 2025-09-19T12:23:39.826Z 2025-09-25T13:12:18.535Z
7868706 7868706 20250917155223_Z3pGo AU003J 2025-09-19T12:23:20.485Z 2025-09-25T13:12:17.751Z
7868632 7868632 20250917153007_fFqCK AU003J 2025-09-19T12:23:09.262Z 2025-09-25T13:12:17.177Z
7868595 7868595 20250917151526_Tqktd AU003J 2025-09-19T12:23:04.583Z 2025-09-25T13:12:16.765Z
7868588 7868588 20250917151323_Hr3Zz AU003J 2025-09-19T12:23:03.680Z 2025-09-25T13:12:16.653Z
7868316 7868316 20250917132647_Psuiv AU003J 2025-09-19T12:22:12.498Z 2025-09-25T13:12:07.761Z
7862842 7862842 20250916202734_W33sk AU003J 2025-09-18T12:33:52.981Z 2025-09-24T13:17:31.376Z
7861609 7861609 20250916123458_idaZv AU003J 2025-09-18T12:30:21.954Z 2025-09-24T13:17:01.203Z
7856246 7856246 20250914175500_KHWjx AU003J 2025-09-17T12:44:35.998Z 2025-09-22T13:08:57.938Z
7856239 7856239 20250914165618_l1Je3 AU003J 2025-09-17T12:44:16.731Z 2025-09-22T13:08:52.006Z
7854723 7854723 20250915203921_8JOgf AU003J 2025-09-17T12:35:17.518Z 2025-09-22T13:05:42.888Z
7854077 7854077 20250915193048_tky3i AU003J 2025-09-17T12:34:13.457Z 2025-09-22T13:05:27.139Z
7853909 7853909 20250915190732_9GAD9 AU003J 2025-09-17T12:33:37.828Z 2025-09-22T13:05:22.837Z
7853531 7853531 20250915174737_lxEv9 AU003J 2025-09-17T12:32:46.456Z 2025-09-22T13:05:16.736Z
7853399 7853399 20250915172253_6sbfD AU003J 2025-09-17T12:32:35.337Z 2025-09-22T13:05:14.444Z
7853223 7853223 20250915170859_L04JU AU003J 2025-09-17T12:32:27.072Z 2025-09-22T13:05:11.004Z
7853113 7853113 20250915165659_ZuKiy AU003J 2025-09-17T12:32:21.371Z 2025-09-22T13:05:08.536Z
7852697 7852697 20250915161853_FNwmo AU003J 2025-09-17T12:31:30.362Z 2025-09-22T13:04:58.700Z
7843621 7843621 20250909165747_JKpGU AU003J 2025-09-16T12:50:25.866Z 2025-09-17T12:57:17.611Z
7843609 7843609 20250909112810_lX7RS AU003J 2025-09-16T12:50:16.221Z 2025-09-17T12:57:11.492Z
7843597 7843597 20250910170624_3O4Xc AU003J 2025-09-16T12:48:44.315Z 2025-09-18T13:00:23.006Z
7843552 7843552 20250911165631_OSHuR AU003J 2025-09-16T12:46:00.318Z 2025-09-19T12:58:08.918Z
7842658 7842658 20250914211012_uXbe5 AU003J 2025-09-16T12:34:42.071Z 2025-09-22T13:09:21.810Z
7842520 7842520 20250914205224_MaG3l AU003J 2025-09-16T12:34:21.591Z 2025-09-22T13:09:18.769Z
7842404 7842404 20250914203722_c3zRS AU003J 2025-09-16T12:34:00.164Z 2025-09-22T13:09:13.098Z
7842169 7842169 20250914200257_rDDRG AU003J 2025-09-16T12:33:41.549Z 2025-09-22T13:09:09.319Z
7841876 7841876 20250914191304_5GUIl AU003J 2025-09-16T12:33:25.654Z 2025-09-22T13:09:03.331Z
7841853 7841853 20250914190858_xob2U AU003J 2025-09-16T12:33:23.543Z 2025-09-22T13:09:02.776Z
7841799 7841799 20250914185923_WXVqo AU003J 2025-09-16T12:33:21.061Z 2025-09-22T13:09:01.780Z
7841596 7841596 20250914180108_Fyrnf AU003J 2025-09-16T12:32:45.545Z 2025-09-22T13:08:58.129Z
7841533 7841533 20250914172707_ECYRJ AU003J 2025-09-16T12:32:40.735Z 2025-09-22T13:08:57.337Z
7841525 7841525 20250914172547_Vefdn AU003J 2025-09-16T12:32:40.147Z 2025-09-22T13:08:57.186Z
7841507 7841507 20250914172204_IcJjd AU003J 2025-09-16T12:32:39.321Z 2025-09-22T13:08:56.972Z

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