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

742 rows where station_code = "AU004H" 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
9270103 9270103 20260128145625_aZUkM AU004H 2026-01-29T14:10:51.023Z 2026-01-29T14:10:51.023Z
9268951 9268951 20260128114702_O5ncv AU004H 2026-01-29T14:05:41.198Z 2026-01-29T14:05:41.198Z
9266094 9266094 20260127171904_HlyWc AU004H 2026-01-28T14:12:24.812Z 2026-01-29T14:30:24.868Z
9266065 9266065 20260127170041_UXJJY AU004H 2026-01-28T14:12:18.261Z 2026-01-29T14:30:24.839Z
9266063 9266063 20260127165941_5LVii AU004H 2026-01-28T14:12:17.696Z 2026-01-29T14:30:24.838Z
9266035 9266035 20260127164648_894ci AU004H 2026-01-28T14:12:13.625Z 2026-01-29T14:30:24.826Z
9265973 9265973 20260127162627_0Vxeb AU004H 2026-01-28T14:11:55.651Z 2026-01-29T14:30:24.804Z
9265848 9265848 20260127160357_KROUs AU004H 2026-01-28T14:11:35.461Z 2026-01-29T14:30:24.691Z
9265722 9265722 20260127155319_kiXII AU004H 2026-01-28T14:11:08.828Z 2026-01-29T14:30:24.662Z
9265395 9265395 20260127151124_yKLW2 AU004H 2026-01-28T14:10:02.070Z 2026-01-29T14:30:24.540Z
9265272 9265272 20260127145309_XJOAR AU004H 2026-01-28T14:09:42.829Z 2026-01-29T14:30:24.518Z
9265240 9265240 20260127144630_HHKpj AU004H 2026-01-28T14:09:37.831Z 2026-01-29T14:30:24.512Z
9264994 9264994 20260127134909_gqbYi AU004H 2026-01-28T14:08:32.939Z 2026-01-29T14:30:24.409Z
9264835 9264835 20260127132014_PkskI AU004H 2026-01-28T14:07:55.051Z 2026-01-29T14:30:24.309Z
9264471 9264471 20260127122847_goKq2 AU004H 2026-01-28T14:06:16.317Z 2026-01-29T14:30:24.179Z
9264308 9264308 20260127120020_LwLYX AU004H 2026-01-28T14:05:26.095Z 2026-01-29T14:30:20.851Z
9263834 9263834 20260127102003_2Il3k AU004H 2026-01-28T14:03:03.906Z 2026-01-29T14:30:18.960Z
9262115 9262115 20260126161211_nIQu6 AU004H 2026-01-27T14:07:40.399Z 2026-01-29T14:33:41.818Z
9261657 9261657 20260126124301_5qYE6 AU004H 2026-01-27T14:04:52.904Z 2026-01-29T14:32:46.245Z
9261189 9261189 20260126102204_nTT7v AU004H 2026-01-27T14:02:25.975Z 2026-01-29T14:32:03.002Z
9257960 9257960 20260125173012_ZjutY AU004H 2026-01-26T14:08:48.577Z 2026-01-29T14:37:55.382Z
9257952 9257952 20260125172216_4dg3u AU004H 2026-01-26T14:08:46.042Z 2026-01-29T14:37:54.888Z
9257864 9257864 20260125163027_vitQ5 AU004H 2026-01-26T14:08:13.512Z 2026-01-29T14:37:45.597Z
9257527 9257527 20260125142002_yf8v2 AU004H 2026-01-26T14:06:06.956Z 2026-01-29T14:37:25.731Z
9256886 9256886 20260125105741_Lgln2 AU004H 2026-01-26T14:02:32.683Z 2026-01-29T14:36:34.138Z
9253971 9253971 20260124171621_780Jc AU004H 2026-01-25T14:05:15.970Z 2026-01-29T14:42:12.093Z
9253969 9253969 20260124165744_O0kdf AU004H 2026-01-25T14:05:15.259Z 2026-01-29T14:42:08.704Z
9253856 9253856 20260124152016_n6YlJ AU004H 2026-01-25T14:04:43.212Z 2026-01-29T14:41:43.292Z
9253848 9253848 20260124151439_DytpR AU004H 2026-01-25T14:04:39.395Z 2026-01-29T14:41:41.968Z
9253825 9253825 20260124150423_BgGv3 AU004H 2026-01-25T14:04:33.903Z 2026-01-29T14:41:39.754Z
9253787 9253787 20260124143630_MuIfr AU004H 2026-01-25T14:04:24.763Z 2026-01-29T14:41:30.009Z
9253728 9253728 20260124140338_g3Swv AU004H 2026-01-25T14:04:07.921Z 2026-01-29T14:41:20.129Z
9253715 9253715 20260124140058_aPQh2 AU004H 2026-01-25T14:04:04.750Z 2026-01-29T14:41:19.350Z
9253675 9253675 20260124133508_LT4ye AU004H 2026-01-25T14:03:54.319Z 2026-01-29T14:41:15.516Z
9253653 9253653 20260124132411_ZDO51 AU004H 2026-01-25T14:03:46.330Z 2026-01-29T14:41:12.891Z
9253647 9253647 20260124132150_2Gwgq AU004H 2026-01-25T14:03:44.642Z 2026-01-29T14:41:12.598Z
9253515 9253515 20260124122442_OLKn9 AU004H 2026-01-25T14:03:05.386Z 2026-01-29T14:40:54.523Z
9253377 9253377 20260124112100_r7GTO AU004H 2026-01-25T14:02:21.276Z 2026-01-29T14:40:45.432Z
9253375 9253375 20260124112049_5IktF AU004H 2026-01-25T14:02:20.427Z 2026-01-29T14:40:45.282Z
9253366 9253366 20260124111343_2z86i AU004H 2026-01-25T14:02:16.910Z 2026-01-29T14:40:44.324Z
9253197 9253197 20260124100719_C8mk5 AU004H 2026-01-25T14:01:15.721Z 2026-01-29T14:40:25.982Z
9250538 9250538 20260123164048_drfnz AU004H 2026-01-24T14:03:26.413Z 2026-01-29T14:45:56.121Z
9250122 9250122 20260123103305_w1Yww AU004H 2026-01-24T14:01:16.623Z 2026-01-29T14:45:00.539Z
9246636 9246636 20260121130809_a22hw AU004H 2026-01-23T14:07:27.161Z 2026-01-29T14:55:01.653Z
9246613 9246613 20260121125039_V8r88 AU004H 2026-01-23T14:07:20.363Z 2026-01-29T14:54:49.251Z
9246537 9246537 20260121114742_54sGE AU004H 2026-01-23T14:06:55.683Z 2026-01-29T14:54:35.964Z
9246501 9246501 20260121103648_73gM4 AU004H 2026-01-23T14:06:28.510Z 2026-01-29T14:54:12.376Z
9246491 9246491 20260121101549_H2cjZ AU004H 2026-01-23T14:06:18.886Z 2026-01-29T14:54:03.911Z
9233497 9233497 20260120160622_GXXyx AU004H 2026-01-21T14:05:58.900Z 2026-01-29T15:01:24.193Z
9233485 9233485 20260120155958_w9Ifh AU004H 2026-01-21T14:05:57.047Z 2026-01-29T15:01:23.580Z
9233430 9233430 20260120151246_jmwPw AU004H 2026-01-21T14:05:45.233Z 2026-01-29T15:01:16.667Z
9233357 9233357 20260120145432_63qWT AU004H 2026-01-21T14:05:27.223Z 2026-01-29T15:01:02.261Z
9233222 9233222 20260120134406_8qMH6 AU004H 2026-01-21T14:04:53.406Z 2026-01-29T15:00:50.196Z
9227181 9227181 20260119145941_et1ch AU004H 2026-01-20T14:07:01.473Z 2026-01-28T14:55:55.845Z
9221316 9221316 20260118151917_VKCdB AU004H 2026-01-19T14:07:26.736Z 2026-01-19T14:07:26.736Z
9219904 9219904 20260118113914_Gs6Ne AU004H 2026-01-19T14:01:36.998Z 2026-01-27T14:58:41.592Z
9210110 9210110 20260115120823_viybI AU004H 2026-01-16T14:18:44.091Z 2026-01-22T15:05:48.215Z
9178699 9178699 20260110134755_Lk7i6 AU004H 2026-01-11T14:15:34.192Z 2026-01-18T15:11:12.208Z
9178103 9178103 20260110121636_1xzfd AU004H 2026-01-11T14:14:02.676Z 2026-01-18T15:10:34.622Z
9173887 9173887 20260110145554_ZrgZM AU004H 2026-01-11T14:00:35.800Z 2026-01-19T15:14:15.199Z
9173465 9173465 20260109142127_Qf8qZ AU004H 2026-01-10T14:17:43.963Z 2026-01-17T15:26:44.800Z
9173157 9173157 20260109130953_ZdVjO AU004H 2026-01-10T14:16:26.881Z 2026-01-17T15:26:21.331Z
9173140 9173140 20260109130523_2j5Wo AU004H 2026-01-10T14:16:20.441Z 2026-01-17T15:26:18.728Z
9170640 9170640 20260109174425_pz8KM AU004H 2026-01-10T14:02:01.339Z 2026-01-18T15:06:43.464Z
9170638 9170638 20260109173709_B19u1 AU004H 2026-01-10T14:02:00.326Z 2026-01-18T15:06:43.141Z
9170637 9170637 20260109172911_bEb8Z AU004H 2026-01-10T14:01:59.260Z 2026-01-18T15:06:43.028Z
9170629 9170629 20260109172203_pNWMh AU004H 2026-01-10T14:01:52.594Z 2026-01-18T15:06:42.339Z
9170622 9170622 20260109171448_MCHDI AU004H 2026-01-10T14:01:48.935Z 2026-01-18T15:06:41.288Z
9170620 9170620 20260109161608_CIJRO AU004H 2026-01-10T14:01:47.590Z 2026-01-18T15:06:40.467Z
9170617 9170617 20260109160756_B36kQ AU004H 2026-01-10T14:01:45.595Z 2026-01-18T15:06:40.121Z
9170553 9170553 20260109154505_AozW2 AU004H 2026-01-10T14:01:17.504Z 2026-01-18T15:06:28.163Z
9170401 9170401 20260109150910_vReah AU004H 2026-01-10T14:00:18.993Z 2026-01-18T15:06:19.643Z
9169674 9169674 20260108152125_ZLJgz AU004H 2026-01-09T14:14:19.818Z 2026-01-16T15:14:24.429Z
9169571 9169571 20260108150033_l6Gm2 AU004H 2026-01-09T14:13:59.954Z 2026-01-16T15:14:08.394Z
9169504 9169504 20260108144709_U2Sed AU004H 2026-01-09T14:13:43.477Z 2026-01-16T15:14:04.259Z
9169492 9169492 20260108144602_C2z76 AU004H 2026-01-09T14:13:41.286Z 2026-01-16T15:14:02.776Z
9169472 9169472 20260108144052_GxTfr AU004H 2026-01-09T14:13:38.892Z 2026-01-16T15:14:01.157Z
9169437 9169437 20260108142847_cc2L8 AU004H 2026-01-09T14:13:34.330Z 2026-01-16T15:13:58.659Z
9168558 9168558 20260108112427_rnA3u AU004H 2026-01-09T14:11:24.451Z 2026-01-16T15:12:51.088Z
9166045 9166045 20260108175302_jQ9sr AU004H 2026-01-09T14:01:07.903Z 2026-01-17T15:23:12.851Z
9166031 9166031 20260108162349_ACzAR AU004H 2026-01-09T14:01:01.732Z 2026-01-17T15:22:55.078Z
9166021 9166021 20260108161048_54cPR AU004H 2026-01-09T14:00:56.054Z 2026-01-17T15:22:54.056Z
9165157 9165157 20260107151214_TSAO2 AU004H 2026-01-08T14:15:33.756Z 2026-01-13T15:05:31.500Z
9165050 9165050 20260107145706_Z2mNO AU004H 2026-01-08T14:15:15.121Z 2026-01-13T15:05:26.017Z
9164393 9164393 20260107130628_SkvVi AU004H 2026-01-08T14:13:01.145Z 2026-01-13T15:04:32.533Z
9163769 9163769 20260107102507_acaqL AU004H 2026-01-08T14:10:28.907Z 2026-01-13T15:03:37.103Z
9163758 9163758 20260107102150_Cft7x AU004H 2026-01-08T14:10:24.618Z 2026-01-13T15:03:36.352Z
9161921 9161921 20260107175439_wWEg0 AU004H 2026-01-08T14:00:39.672Z 2026-01-16T15:09:40.997Z
9161914 9161914 20260107172354_tEO3P AU004H 2026-01-08T14:00:34.750Z 2026-01-16T15:09:32.557Z
9161912 9161912 20260107171918_sZ47B AU004H 2026-01-08T14:00:33.460Z 2026-01-16T15:09:31.862Z
9161905 9161905 20260107171122_SCqqx AU004H 2026-01-08T14:00:28.806Z 2026-01-16T15:09:30.506Z
9161900 9161900 20260107170203_gjSbz AU004H 2026-01-08T14:00:25.168Z 2026-01-16T15:09:29.019Z
9161897 9161897 20260107165522_fsOkU AU004H 2026-01-08T14:00:23.948Z 2026-01-16T15:09:28.259Z
9161892 9161892 20260107162652_nQ4yO AU004H 2026-01-08T14:00:19.751Z 2026-01-16T15:09:23.844Z
9161568 9161568 20260106142959_4Tcck AU004H 2026-01-07T14:17:08.919Z 2026-01-13T15:10:57.076Z
9161348 9161348 20260106123705_3Obsp AU004H 2026-01-07T14:16:09.054Z 2026-01-13T15:10:40.667Z
9161319 9161319 20260106121828_g7le5 AU004H 2026-01-07T14:16:01.600Z 2026-01-13T15:10:32.113Z
9161252 9161252 20260106115605_zqfwK AU004H 2026-01-07T14:15:44.734Z 2026-01-13T15:10:28.258Z
9161250 9161250 20260106115603_jK3Gg AU004H 2026-01-07T14:15:44.242Z 2026-01-13T15:10:28.170Z
9161158 9161158 20260106110901_z2HZA AU004H 2026-01-07T14:15:23.072Z 2026-01-13T15:10:21.188Z

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