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

3,437 rows where station_code = "AU003G" 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
8766115 8766115 20251212161027_YJYog AU003G 2025-12-14T14:52:09.516Z 2025-12-14T15:16:08.747Z
8766107 8766107 20251212160840_U5nu8 AU003G 2025-12-14T14:52:09.149Z 2025-12-14T15:16:08.745Z
8766076 8766076 20251212160427_93HAo AU003G 2025-12-14T14:52:05.414Z 2025-12-14T15:16:08.737Z
8765991 8765991 20251212155320_tibSk AU003G 2025-12-14T14:51:54.177Z 2025-12-14T15:16:08.711Z
8765941 8765941 20251212154529_hkL4T AU003G 2025-12-14T14:51:49.601Z 2025-12-14T15:16:08.695Z
8765903 8765903 20251212153950_dCV32 AU003G 2025-12-14T14:51:40.053Z 2025-12-14T15:16:08.684Z
8765901 8765901 20251212153945_qkZvf AU003G 2025-12-14T14:51:37.784Z 2025-12-14T15:16:08.683Z
8765879 8765879 20251212153823_hv3U4 AU003G 2025-12-14T14:51:25.039Z 2025-12-14T15:16:08.677Z
8765877 8765877 20251212153732_hIL9l AU003G 2025-12-14T14:51:24.661Z 2025-12-14T15:16:08.676Z
8765687 8765687 20251212152334_vRcGx AU003G 2025-12-14T14:50:47.727Z 2025-12-14T15:16:08.630Z
8765582 8765582 20251212151845_3JZwd AU003G 2025-12-14T14:50:35.970Z 2025-12-14T15:16:08.598Z
8765379 8765379 20251212151143_AAIGQ AU003G 2025-12-14T14:49:57.425Z 2025-12-14T15:16:08.566Z
8764559 8764559 20251212143430_TmBWG AU003G 2025-12-14T14:48:00.589Z 2025-12-14T15:16:08.378Z
8762740 8762740 20251212130423_4HAhY AU003G 2025-12-14T14:43:40.402Z 2025-12-14T15:16:07.882Z
8760882 8760882 20251212112441_9RO7t AU003G 2025-12-14T14:34:51.948Z 2025-12-14T15:16:06.091Z
8760561 8760561 20251212110732_DQvqq AU003G 2025-12-14T14:33:25.230Z 2025-12-14T15:16:05.728Z
8760223 8760223 20251212104832_def2m AU003G 2025-12-14T14:31:47.566Z 2025-12-14T15:16:05.553Z
8760113 8760113 20251212104203_HKsGf AU003G 2025-12-14T14:31:29.556Z 2025-12-14T15:16:05.501Z
8749273 8749273 20251209142947_LbSgM AU003G 2025-12-13T15:36:11.398Z 2025-12-14T15:42:04.734Z
8749246 8749246 20251209142657_wm4DS AU003G 2025-12-13T15:36:09.610Z 2025-12-14T15:41:57.395Z
8749158 8749158 20251209141522_1GxpT AU003G 2025-12-13T15:36:04.643Z 2025-12-14T15:41:45.013Z
8748942 8748942 20251209134249_Xx8dV AU003G 2025-12-13T15:35:31.012Z 2025-12-14T15:41:34.481Z
8748868 8748868 20251209133143_jNxcJ AU003G 2025-12-13T15:35:27.563Z 2025-12-14T15:41:31.546Z
8748845 8748845 20251209132612_kK3Sb AU003G 2025-12-13T15:35:26.570Z 2025-12-14T15:41:30.547Z
8748843 8748843 20251209132608_EPCQY AU003G 2025-12-13T15:35:26.535Z 2025-12-14T15:41:30.543Z
8748499 8748499 20251209123858_m92Rm AU003G 2025-12-13T15:34:30.219Z 2025-12-14T15:40:55.312Z
8748361 8748361 20251209122204_nqoyr AU003G 2025-12-13T15:34:20.559Z 2025-12-14T15:40:49.232Z
8748314 8748314 20251209121533_2m25i AU003G 2025-12-13T15:34:16.748Z 2025-12-14T15:40:46.719Z
8748292 8748292 20251209121251_OdKm4 AU003G 2025-12-13T15:34:15.490Z 2025-12-14T15:40:45.831Z
8748215 8748215 20251209120240_Glr17 AU003G 2025-12-13T15:33:49.589Z 2025-12-14T15:40:32.542Z
8747931 8747931 20251209112051_WlldV AU003G 2025-12-13T15:33:27.683Z 2025-12-14T15:39:59.519Z
8704101 8704101 20251208145148_XJCmP AU003G 2025-12-09T14:13:47.964Z 2025-12-14T15:52:01.535Z
8704079 8704079 20251208144801_J4JAJ AU003G 2025-12-09T14:13:40.040Z 2025-12-14T15:52:00.879Z
8704030 8704030 20251208144253_3cEei AU003G 2025-12-09T14:13:22.645Z 2025-12-14T15:51:59.056Z
8703921 8703921 20251208143027_CV3fp AU003G 2025-12-09T14:13:09.916Z 2025-12-14T15:51:48.674Z
8703771 8703771 20251208141441_aD0Rd AU003G 2025-12-09T14:12:44.460Z 2025-12-14T15:51:27.293Z
8703727 8703727 20251208140406_qoGTK AU003G 2025-12-09T14:12:36.589Z 2025-12-14T15:51:25.344Z
8703664 8703664 20251208135923_ksLec AU003G 2025-12-09T14:12:31.842Z 2025-12-14T15:51:24.022Z
8703633 8703633 20251208135611_A9l7B AU003G 2025-12-09T14:12:27.369Z 2025-12-14T15:51:23.126Z
8703624 8703624 20251208135455_05eY1 AU003G 2025-12-09T14:12:25.990Z 2025-12-14T15:51:22.854Z
8703604 8703604 20251208135243_OGq0b AU003G 2025-12-09T14:12:23.839Z 2025-12-14T15:51:22.416Z
8703432 8703432 20251208133140_ZoRDL AU003G 2025-12-09T14:11:47.765Z 2025-12-14T15:51:17.500Z
8703385 8703385 20251208132618_V7m8w AU003G 2025-12-09T14:11:42.808Z 2025-12-14T15:51:16.648Z
8703343 8703343 20251208131712_HadZF AU003G 2025-12-09T14:11:37.913Z 2025-12-14T15:51:15.282Z
8703333 8703333 20251208131342_sbB2p AU003G 2025-12-09T14:11:36.472Z 2025-12-14T15:51:14.956Z
8703041 8703041 20251208122544_FLFPf AU003G 2025-12-09T14:10:29.851Z 2025-12-14T15:50:50.891Z
8702868 8702868 20251208121005_Bs1DR AU003G 2025-12-09T14:09:54.212Z 2025-12-14T15:50:46.685Z
8702807 8702807 20251208120110_VuffQ AU003G 2025-12-09T14:09:46.086Z 2025-12-14T15:50:40.082Z
8702805 8702805 20251208120024_2so3C AU003G 2025-12-09T14:09:45.813Z 2025-12-14T15:50:39.095Z
8702537 8702537 20251208113209_hO4Kv AU003G 2025-12-09T14:08:45.211Z 2025-12-14T15:50:20.000Z
8701962 8701962 20251208103930_axd1t AU003G 2025-12-09T14:06:54.159Z 2025-12-14T15:49:40.804Z
8683598 8683598 20251130174110_GLJZF AU003G 2025-12-04T14:30:47.010Z 2025-12-09T14:56:26.089Z
8678307 8678307 20251203172350_MH6kg AU003G 2025-12-04T14:04:16.280Z 2025-12-11T14:40:49.055Z
8678299 8678299 20251203171707_GEVdt AU003G 2025-12-04T14:04:14.858Z 2025-12-11T14:40:47.727Z
8678293 8678293 20251203170159_td3vf AU003G 2025-12-04T14:04:13.778Z 2025-12-11T14:40:46.622Z
8678288 8678288 20251203165243_SpnfD AU003G 2025-12-04T14:04:13.188Z 2025-12-11T14:40:45.560Z
8678282 8678282 20251203164739_ug33c AU003G 2025-12-04T14:04:11.594Z 2025-12-11T14:40:42.982Z
8678280 8678280 20251203164724_l3hW2 AU003G 2025-12-04T14:04:11.075Z 2025-12-11T14:40:42.874Z
8678274 8678274 20251203164541_XhW3u AU003G 2025-12-04T14:04:09.528Z 2025-12-11T14:40:42.557Z
8678272 8678272 20251203164232_9fw2n AU003G 2025-12-04T14:04:09.011Z 2025-12-11T14:40:42.350Z
8678270 8678270 20251203164045_MitkH AU003G 2025-12-04T14:04:08.464Z 2025-12-11T14:40:41.987Z
8678260 8678260 20251203162739_nZD8Z AU003G 2025-12-04T14:04:05.660Z 2025-12-11T14:40:41.164Z
8678258 8678258 20251203161906_6BUsN AU003G 2025-12-04T14:04:05.176Z 2025-12-11T14:40:40.436Z
8678239 8678239 20251203154919_X166j AU003G 2025-12-04T14:04:01.050Z 2025-12-11T14:40:38.391Z
8678152 8678152 20251203150440_iuF71 AU003G 2025-12-04T14:03:39.398Z 2025-12-11T14:40:32.633Z
8678031 8678031 20251203141042_se9dl AU003G 2025-12-04T14:03:16.149Z 2025-12-11T14:40:23.344Z
8673185 8673185 20251201172328_Qk2BQ AU003G 2025-12-03T14:17:48.438Z 2025-12-10T14:38:14.504Z
8673164 8673164 20251201171711_sAqpY AU003G 2025-12-03T14:17:42.732Z 2025-12-10T14:38:13.865Z
8673076 8673076 20251201164754_A46zZ AU003G 2025-12-03T14:17:28.504Z 2025-12-10T14:38:12.048Z
8673053 8673053 20251201163538_CaQ3N AU003G 2025-12-03T14:17:15.251Z 2025-12-10T14:38:11.563Z
8673012 8673012 20251201162020_G2GnS AU003G 2025-12-03T14:17:07.001Z 2025-12-10T14:38:10.770Z
8672997 8672997 20251201161335_2BCWh AU003G 2025-12-03T14:17:05.696Z 2025-12-10T14:38:10.549Z
8672959 8672959 20251201155052_go2Qt AU003G 2025-12-03T14:17:00.616Z 2025-12-10T14:38:09.704Z
8672954 8672954 20251201154747_QLRTh AU003G 2025-12-03T14:17:00.152Z 2025-12-10T14:38:09.648Z
8672898 8672898 20251201153615_QY3ZA AU003G 2025-12-03T14:16:52.745Z 2025-12-10T14:38:08.559Z
8672766 8672766 20251201151614_3tLkx AU003G 2025-12-03T14:16:23.954Z 2025-12-10T14:38:06.561Z
8672399 8672399 20251201142431_b3NW1 AU003G 2025-12-03T14:15:31.413Z 2025-12-10T14:37:53.479Z
8670351 8670351 20251202173431_3tdyh AU003G 2025-12-03T14:08:08.500Z 2025-12-11T14:44:13.092Z
8670342 8670342 20251202171425_9AcrA AU003G 2025-12-03T14:08:06.150Z 2025-12-11T14:43:58.396Z
8670338 8670338 20251202171109_1yN34 AU003G 2025-12-03T14:08:02.207Z 2025-12-11T14:43:58.040Z
8670330 8670330 20251202170540_RHWPJ AU003G 2025-12-03T14:08:00.497Z 2025-12-11T14:43:56.814Z
8670322 8670322 20251202165008_UBF20 AU003G 2025-12-03T14:07:58.814Z 2025-12-11T14:43:55.748Z
8670320 8670320 20251202164849_TRBFm AU003G 2025-12-03T14:07:58.394Z 2025-12-11T14:43:55.579Z
8670316 8670316 20251202164251_T8HLn AU003G 2025-12-03T14:07:57.502Z 2025-12-11T14:43:54.953Z
8670314 8670314 20251202163705_hWdDi AU003G 2025-12-03T14:07:57.059Z 2025-12-11T14:43:54.794Z
8670288 8670288 20251202160708_E4FEG AU003G 2025-12-03T14:07:51.064Z 2025-12-11T14:43:52.055Z
8670281 8670281 20251202160150_Gd9kK AU003G 2025-12-03T14:07:49.431Z 2025-12-11T14:43:51.589Z
8670279 8670279 20251202160009_RWIm8 AU003G 2025-12-03T14:07:48.978Z 2025-12-11T14:43:51.494Z
8670264 8670264 20251202155108_RCFBr AU003G 2025-12-03T14:07:46.032Z 2025-12-11T14:43:50.760Z
8670260 8670260 20251202154717_Ceuoj AU003G 2025-12-03T14:07:45.184Z 2025-12-11T14:43:50.449Z
8670252 8670252 20251202154603_MroQh AU003G 2025-12-03T14:07:44.101Z 2025-12-11T14:43:50.304Z
8670244 8670244 20251202154045_JLaNr AU003G 2025-12-03T14:07:41.539Z 2025-12-11T14:43:49.948Z
8670193 8670193 20251202151514_jG7Yd AU003G 2025-12-03T14:07:21.996Z 2025-12-11T14:43:47.993Z
8670166 8670166 20251202140701_Tw1tP AU003G 2025-12-03T14:07:15.973Z 2025-12-11T14:43:45.686Z
8670142 8670142 20251202133049_ehhNB AU003G 2025-12-03T14:07:02.478Z 2025-12-11T14:43:44.325Z
8661957 8661957 20251130173554_lhzPq AU003G 2025-12-02T14:13:42.041Z 2025-12-09T14:56:25.005Z
8661831 8661831 20251130172038_CKblu AU003G 2025-12-02T14:13:10.679Z 2025-12-09T14:56:21.196Z
8661778 8661778 20251130171115_jIEoL AU003G 2025-12-02T14:13:01.177Z 2025-12-09T14:56:20.184Z
8661739 8661739 20251130170320_0v5uQ AU003G 2025-12-02T14:12:52.512Z 2025-12-09T14:56:18.906Z
8661730 8661730 20251130170131_FwzyF AU003G 2025-12-02T14:12:51.788Z 2025-12-09T14:56:18.798Z

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