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,540 rows where station_code = "AU0006" 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
9804636 9804636 20260425131231_6XZLr AU0006 2026-04-27T12:52:10.284Z 2026-05-02T13:04:32.246Z
9803855 9803855 20260425115203_waLQ6 AU0006 2026-04-27T12:50:42.941Z 2026-05-02T13:04:07.873Z
9803846 9803846 20260425115115_2rvJw AU0006 2026-04-27T12:50:42.537Z 2026-05-02T13:04:07.672Z
9797553 9797553 20260425210433_FfQow AU0006 2026-04-27T12:19:58.988Z 2026-05-04T12:43:36.388Z
9797480 9797480 20260425205246_3UJbS AU0006 2026-04-27T12:19:40.486Z 2026-05-04T12:43:34.525Z
9796629 9796629 20260425182720_M1j0D AU0006 2026-04-27T12:16:01.020Z 2026-05-04T12:42:53.521Z
9796617 9796617 20260425182629_ze9KK AU0006 2026-04-27T12:15:59.719Z 2026-05-04T12:42:53.308Z
9796604 9796604 20260425182428_s3Knc AU0006 2026-04-27T12:15:50.583Z 2026-05-04T12:42:52.923Z
9796519 9796519 20260425180851_DHgHz AU0006 2026-04-27T12:15:36.851Z 2026-05-04T12:42:51.122Z
9796445 9796445 20260425175754_heMCc AU0006 2026-04-27T12:15:17.599Z 2026-05-04T12:42:49.464Z
9796254 9796254 20260425174811_qXiUg AU0006 2026-04-27T12:14:54.661Z 2026-05-04T12:42:46.965Z
9795413 9795413 20260425170010_U2Ut0 AU0006 2026-04-27T12:12:30.322Z 2026-05-04T12:42:14.609Z
9795037 9795037 20260425163719_zfuqB AU0006 2026-04-27T12:11:22.244Z 2026-05-04T12:42:08.135Z
9794564 9794564 20260425155857_3U3b2 AU0006 2026-04-27T12:09:54.252Z 2026-05-04T12:41:49.870Z
9794046 9794046 20260425151910_3Icka AU0006 2026-04-27T12:08:27.572Z 2026-05-04T12:41:32.716Z
9794019 9794019 20260425151621_eRJna AU0006 2026-04-27T12:08:23.594Z 2026-05-04T12:41:32.414Z
9793082 9793082 20260425141439_ylnRY AU0006 2026-04-27T12:05:33.568Z 2026-05-04T12:41:03.709Z
9783348 9783348 20260424211202_u8iRy AU0006 2026-04-26T12:14:33.811Z 2026-05-02T12:59:16.799Z
9783133 9783133 20260424204508_eZRSi AU0006 2026-04-26T12:13:56.819Z 2026-05-02T12:58:56.819Z
9782728 9782728 20260424194449_3ftjq AU0006 2026-04-26T12:12:42.220Z 2026-05-02T12:58:39.375Z
9780858 9780858 20260424165642_FM82m AU0006 2026-04-26T12:08:31.028Z 2026-05-02T12:57:11.922Z
9779799 9779799 20260424155741_UdCpx AU0006 2026-04-26T12:06:29.891Z 2026-05-02T12:56:34.587Z
9779504 9779504 20260424153508_G23RY AU0006 2026-04-26T12:05:51.848Z 2026-05-02T12:56:14.241Z
9775793 9775793 20260423104938_Jf0G4 AU0006 2026-04-25T12:57:14.506Z 2026-04-30T13:14:37.518Z
9763434 9763434 20260423180549_JXFAP AU0006 2026-04-25T12:12:37.807Z 2026-05-02T13:07:33.509Z
9763403 9763403 20260423175953_wKP8V AU0006 2026-04-25T12:12:34.683Z 2026-05-02T13:07:32.573Z
9763348 9763348 20260423175315_FuKrW AU0006 2026-04-25T12:12:21.020Z 2026-05-02T13:07:22.924Z
9762869 9762869 20260423171543_6t2Qe AU0006 2026-04-25T12:10:55.896Z 2026-05-02T13:07:01.328Z
9762344 9762344 20260423163735_IxpjI AU0006 2026-04-25T12:09:28.211Z 2026-05-02T13:06:49.968Z
9762324 9762324 20260423163331_9GSlR AU0006 2026-04-25T12:09:19.904Z 2026-05-02T13:06:49.314Z
9762105 9762105 20260423161542_JA3BE AU0006 2026-04-25T12:08:36.858Z 2026-05-02T13:06:18.738Z
9761890 9761890 20260423155652_SRTuc AU0006 2026-04-25T12:08:03.374Z 2026-05-02T13:06:14.077Z
9761714 9761714 20260423154711_xVN5O AU0006 2026-04-25T12:07:28.297Z 2026-05-02T13:06:10.323Z
9761504 9761504 20260423153347_fnsXb AU0006 2026-04-25T12:06:45.248Z 2026-05-02T13:06:06.813Z
9732473 9732473 20260421211750_gdh6X AU0006 2026-04-23T12:09:40.194Z 2026-04-30T13:17:00.159Z
9732381 9732381 20260421211204_FXcaI AU0006 2026-04-23T12:09:31.637Z 2026-04-30T13:16:59.194Z
9732339 9732339 20260421210619_0hV4U AU0006 2026-04-23T12:09:15.474Z 2026-04-30T13:16:58.684Z
9732202 9732202 20260421205422_6orl3 AU0006 2026-04-23T12:08:57.169Z 2026-04-30T13:16:57.459Z
9731986 9731986 20260421202756_8zcGP AU0006 2026-04-23T12:08:07.186Z 2026-04-30T13:16:54.838Z
9731969 9731969 20260421202604_Nk92K AU0006 2026-04-23T12:08:04.794Z 2026-04-30T13:16:54.585Z
9731879 9731879 20260421201123_j6W6A AU0006 2026-04-23T12:07:48.950Z 2026-04-30T13:16:53.627Z
9731747 9731747 20260421194038_kVsPZ AU0006 2026-04-23T12:07:17.549Z 2026-04-30T13:16:51.924Z
9731704 9731704 20260421191925_T0TNo AU0006 2026-04-23T12:07:10.379Z 2026-04-30T13:16:51.366Z
9731640 9731640 20260421185932_29skx AU0006 2026-04-23T12:06:53.337Z 2026-04-30T13:16:50.554Z
9731438 9731438 20260421173825_4zPwV AU0006 2026-04-23T12:05:48.979Z 2026-04-30T13:16:46.754Z
9731411 9731411 20260421172746_yaKR3 AU0006 2026-04-23T12:05:38.787Z 2026-04-30T13:16:45.979Z
9731128 9731128 20260421155022_NV17l AU0006 2026-04-23T12:04:06.447Z 2026-04-30T13:15:58.882Z
9731058 9731058 20260421153339_R853P AU0006 2026-04-23T12:03:43.105Z 2026-04-30T13:15:57.560Z
9730992 9730992 20260421150822_SkbxA AU0006 2026-04-23T12:03:21.866Z 2026-04-30T13:15:56.269Z
9730959 9730959 20260421145050_mGt2b AU0006 2026-04-23T12:03:14.462Z 2026-04-30T13:15:53.637Z
9730904 9730904 20260421142944_Mb9JE AU0006 2026-04-23T12:02:51.228Z 2026-04-30T13:15:52.832Z
9730842 9730842 20260421135811_QqU42 AU0006 2026-04-23T12:02:29.366Z 2026-04-30T13:15:51.135Z
9730760 9730760 20260421132416_OWEws AU0006 2026-04-23T12:01:59.201Z 2026-04-30T13:15:49.228Z
9730754 9730754 20260421132318_7jBzA AU0006 2026-04-23T12:01:53.150Z 2026-04-30T13:15:49.052Z
9730716 9730716 20260421130408_2dJyW AU0006 2026-04-23T12:01:41.551Z 2026-04-30T13:15:48.175Z
9730688 9730688 20260421125246_gGI3Z AU0006 2026-04-23T12:01:34.756Z 2026-04-30T13:15:47.649Z
9730640 9730640 20260421122340_2wDQT AU0006 2026-04-23T12:01:14.340Z 2026-04-30T13:15:46.487Z
9730545 9730545 20260421112238_jjOFL AU0006 2026-04-23T12:00:40.825Z 2026-04-30T13:15:42.957Z
9730519 9730519 20260421111739_zUR2Z AU0006 2026-04-23T12:00:33.849Z 2026-04-30T13:15:23.747Z
9723561 9723561 20260420192833_I2bQg AU0006 2026-04-22T12:11:13.655Z 2026-04-29T13:19:05.357Z
9716745 9716745 20260419194552_SCiEe AU0006 2026-04-21T12:17:09.849Z 2026-04-28T13:36:13.596Z
9707244 9707244 20260418211930_0xmzc AU0006 2026-04-20T12:13:15.823Z 2026-04-27T13:46:12.579Z
9706983 9706983 20260418203001_lafTL AU0006 2026-04-20T12:12:27.737Z 2026-04-27T13:46:05.020Z
9706978 9706978 20260418202923_tP53d AU0006 2026-04-20T12:12:26.771Z 2026-04-27T13:46:04.793Z
9706962 9706962 20260418202702_367qa AU0006 2026-04-20T12:12:24.635Z 2026-04-27T13:45:59.677Z
9706937 9706937 20260418201802_k3YbZ AU0006 2026-04-20T12:12:11.882Z 2026-04-27T13:45:44.531Z
9706903 9706903 20260418201201_QquT6 AU0006 2026-04-20T12:12:07.901Z 2026-04-27T13:45:43.711Z
9706863 9706863 20260418200349_U4im5 AU0006 2026-04-20T12:11:58.510Z 2026-04-27T13:45:42.337Z
9706774 9706774 20260418192356_zpZti AU0006 2026-04-20T12:11:30.887Z 2026-04-27T13:45:35.791Z
9706648 9706648 20260418183947_6rkNj AU0006 2026-04-20T12:10:54.250Z 2026-04-27T13:45:29.643Z
9706600 9706600 20260418182302_orF0U AU0006 2026-04-20T12:10:45.219Z 2026-04-27T13:45:27.713Z
9706470 9706470 20260418173140_bFeK9 AU0006 2026-04-20T12:10:05.864Z 2026-04-27T13:45:22.283Z
9706427 9706427 20260418171802_gU4ES AU0006 2026-04-20T12:09:47.155Z 2026-04-27T13:45:01.463Z
9706382 9706382 20260418170701_OU6v4 AU0006 2026-04-20T12:09:38.238Z 2026-04-27T13:44:59.943Z
9706371 9706371 20260418170456_2pOUC AU0006 2026-04-20T12:09:35.673Z 2026-04-27T13:44:59.580Z
9706366 9706366 20260418170315_obvGP AU0006 2026-04-20T12:09:34.756Z 2026-04-27T13:44:59.431Z
9706308 9706308 20260418163947_mt4xq AU0006 2026-04-20T12:09:13.526Z 2026-04-27T13:44:54.838Z
9706257 9706257 20260418162158_LoG80 AU0006 2026-04-20T12:09:01.901Z 2026-04-27T13:44:52.405Z
9706238 9706238 20260418161328_Lxuqr AU0006 2026-04-20T12:08:57.315Z 2026-04-27T13:44:51.426Z
9706233 9706233 20260418161055_Gy1jI AU0006 2026-04-20T12:08:56.662Z 2026-04-27T13:44:51.312Z
9706191 9706191 20260418155934_3vwHO AU0006 2026-04-20T12:08:41.642Z 2026-04-27T13:44:49.789Z
9706138 9706138 20260418152920_r52YO AU0006 2026-04-20T12:08:27.924Z 2026-04-27T13:44:47.072Z
9706107 9706107 20260418151636_ztCle AU0006 2026-04-20T12:08:21.542Z 2026-04-27T13:44:45.931Z
9706050 9706050 20260418144928_V7Kgb AU0006 2026-04-20T12:07:58.091Z 2026-04-27T13:44:43.645Z
9705969 9705969 20260418140132_7ftA6 AU0006 2026-04-20T12:07:32.115Z 2026-04-27T13:44:25.365Z
9699977 9699977 20260417210121_622Ix AU0006 2026-04-19T12:14:10.266Z 2026-04-26T13:10:30.606Z
9699938 9699938 20260417205129_CIM3q AU0006 2026-04-19T12:14:01.393Z 2026-04-26T13:10:30.292Z
9699604 9699604 20260417192926_yFhDA AU0006 2026-04-19T12:12:37.317Z 2026-04-26T13:10:25.048Z
9699576 9699576 20260417192519_VUIm1 AU0006 2026-04-19T12:12:29.793Z 2026-04-26T13:10:22.355Z
9699567 9699567 20260417192217_92etJ AU0006 2026-04-19T12:12:25.164Z 2026-04-26T13:10:20.878Z
9699528 9699528 20260417191449_c6UVz AU0006 2026-04-19T12:12:18.857Z 2026-04-26T13:10:17.005Z
9699516 9699516 20260417191051_e1Ar6 AU0006 2026-04-19T12:12:15.813Z 2026-04-26T13:10:13.896Z
9698244 9698244 20260417121543_22683 AU0006 2026-04-19T12:06:00.714Z 2026-04-26T13:07:59.512Z
9698117 9698117 20260417110834_KJRc7 AU0006 2026-04-19T12:04:54.982Z 2026-04-26T13:07:29.708Z
9693512 9693512 20260416151916_XyCEP AU0006 2026-04-18T12:14:48.087Z 2026-04-25T13:55:50.384Z
9693054 9693054 20260416115428_GxxBg AU0006 2026-04-18T12:08:55.256Z 2026-04-25T13:53:34.517Z
9688584 9688584 20260415202508_9OcfD AU0006 2026-04-17T12:25:34.880Z 2026-04-24T12:24:39.479Z
9688379 9688379 20260415193254_ws2Xt AU0006 2026-04-17T12:24:51.681Z 2026-04-24T12:24:37.011Z
9688335 9688335 20260415192300_gUCh2 AU0006 2026-04-17T12:24:45.544Z 2026-04-24T12:24:36.376Z
9688299 9688299 20260415191610_oRYKA AU0006 2026-04-17T12:24:30.051Z 2026-04-24T12:24:35.738Z

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