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,490 rows where station_code = "AU001D" 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
8683390 8683390 20251201181529_cKaeE AU001D 2025-12-04T14:23:58.730Z 2025-12-04T14:23:58.730Z
8683355 8683355 20251201161444_YuyGu AU001D 2025-12-04T14:23:28.658Z 2025-12-04T14:23:28.658Z
8678648 8678648 20251202163246_HLMFm AU001D 2025-12-04T14:07:45.648Z 2025-12-04T14:19:08.161Z
8673426 8673426 20251201190257_ocBw3 AU001D 2025-12-03T14:18:49.396Z 2025-12-04T14:24:16.765Z
8673270 8673270 20251201175921_3HSnP AU001D 2025-12-03T14:18:09.098Z 2025-12-04T14:23:55.702Z
8673061 8673061 20251201164007_zHzq0 AU001D 2025-12-03T14:17:16.199Z 2025-12-04T14:23:31.937Z
8672503 8672503 20251201143906_Acipg AU001D 2025-12-03T14:15:41.972Z 2025-12-04T14:22:54.217Z
8667058 8667058 20251129160029_qqZm3 AU001D 2025-12-02T14:34:30.012Z 2025-12-04T14:37:28.156Z
8666973 8666973 20251129125150_UKswE AU001D 2025-12-02T14:33:23.029Z 2025-12-04T14:36:42.256Z
8662856 8662856 20251130194120_LlVsA AU001D 2025-12-02T14:16:52.470Z 2025-12-04T14:31:39.125Z
8662334 8662334 20251130183422_llitL AU001D 2025-12-02T14:15:10.230Z 2025-12-04T14:31:05.901Z
8662159 8662159 20251130180813_pXR63 AU001D 2025-12-02T14:14:33.449Z 2025-12-04T14:30:56.152Z
8660388 8660388 20251130124519_gymNy AU001D 2025-12-02T14:07:43.860Z 2025-12-04T14:28:43.517Z
8649361 8649361 20251129171500_DUkV8 AU001D 2025-12-01T14:12:12.472Z 2025-12-04T14:37:54.566Z
8649225 8649225 20251129164512_lUwJV AU001D 2025-12-01T14:11:31.033Z 2025-12-04T14:37:49.236Z
8648973 8648973 20251129153658_Lrh9u AU001D 2025-12-01T14:10:15.841Z 2025-12-04T14:37:20.786Z
8648971 8648971 20251129153620_2Vizf AU001D 2025-12-01T14:10:15.503Z 2025-12-04T14:37:20.709Z
8648920 8648920 20251129151001_Zr3Cg AU001D 2025-12-01T14:09:37.656Z 2025-12-04T14:37:15.187Z
8648843 8648843 20251129135042_O1ZEo AU001D 2025-12-01T14:08:07.351Z 2025-12-04T14:37:03.534Z
8648769 8648769 20251129122330_WO71c AU001D 2025-12-01T14:06:05.813Z 2025-12-04T14:36:35.145Z
8644717 8644717 20251128194731_AXhyF AU001D 2025-11-30T14:22:20.334Z 2025-12-04T14:48:34.277Z
8644136 8644136 20251128190115_ykML8 AU001D 2025-11-30T14:21:23.095Z 2025-12-04T14:48:20.758Z
8641046 8641046 20251128132320_a354l AU001D 2025-11-30T14:13:52.020Z 2025-12-04T14:46:04.100Z
8638152 8638152 20251126175008_2i2Mc AU001D 2025-11-29T14:33:23.079Z 2025-12-04T15:01:51.981Z
8631072 8631072 20251127181222_uV5Sa AU001D 2025-11-29T14:14:30.756Z 2025-12-04T14:54:25.549Z
8630187 8630187 20251127151251_ohC2r AU001D 2025-11-29T14:12:02.840Z 2025-12-04T14:53:33.657Z
8630033 8630033 20251127125127_Xg2Ms AU001D 2025-11-29T14:11:06.521Z 2025-12-04T14:53:20.073Z
8622287 8622287 20251126183614_XnB3r AU001D 2025-11-28T14:18:19.411Z 2025-12-04T15:02:10.278Z
8622085 8622085 20251126174803_Jj2O3 AU001D 2025-11-28T14:17:39.260Z 2025-12-04T15:01:51.532Z
8622014 8622014 20251126173053_pKAZe AU001D 2025-11-28T14:17:21.072Z 2025-12-04T15:01:49.886Z
8621943 8621943 20251126171549_OC4JZ AU001D 2025-11-28T14:17:06.379Z 2025-12-04T15:01:48.140Z
8577721 8577721 20251122185032_HccRy AU001D 2025-11-24T14:09:31.334Z 2025-12-01T15:18:56.938Z
8577093 8577093 20251122171901_VVOhe AU001D 2025-11-24T14:07:32.106Z 2025-12-01T15:18:43.291Z
8577005 8577005 20251122170044_TTuWw AU001D 2025-11-24T14:07:19.013Z 2025-12-01T15:18:42.480Z
8576893 8576893 20251122163518_2106r AU001D 2025-11-24T14:06:55.771Z 2025-12-01T15:18:41.079Z
8563034 8563034 20251121151033_g3tp1 AU001D 2025-11-23T14:07:07.373Z 2025-11-30T15:03:34.818Z
8563010 8563010 20251121150716_pW1aH AU001D 2025-11-23T14:07:04.339Z 2025-11-30T15:03:34.699Z
8562192 8562192 20251121134646_Xw4wV AU001D 2025-11-23T14:04:53.810Z 2025-11-30T15:03:24.328Z
8502126 8502126 20251117124708_hPIGR AU001D 2025-11-19T14:01:34.692Z 2025-11-26T15:06:05.353Z
8501672 8501672 20251114194701_KT2cf AU001D 2025-11-18T14:50:33.921Z 2025-11-23T15:17:07.377Z
8501650 8501650 20251114182413_EGk6h AU001D 2025-11-18T14:49:36.812Z 2025-11-23T15:17:02.525Z
8501631 8501631 20251114161401_W1CxQ AU001D 2025-11-18T14:48:46.362Z 2025-11-23T15:16:51.797Z
8501617 8501617 20251114152107_fN9m6 AU001D 2025-11-18T14:48:36.683Z 2025-11-23T15:16:31.676Z
8499980 8499980 20251115161722_sLfpW AU001D 2025-11-18T14:40:24.162Z 2025-11-24T15:03:51.240Z
8489655 8489655 20251116171639_2vPHM AU001D 2025-11-18T14:11:00.761Z 2025-11-25T15:07:34.976Z
8489575 8489575 20251116170224_FKeiB AU001D 2025-11-18T14:10:37.488Z 2025-11-25T15:07:32.351Z
8489360 8489360 20251116161038_UsXOT AU001D 2025-11-18T14:09:49.618Z 2025-11-25T15:07:28.369Z
8487599 8487599 20251116130817_D7mQZ AU001D 2025-11-18T14:03:47.607Z 2025-11-25T15:06:18.030Z
8487280 8487280 20251116123659_VrryL AU001D 2025-11-18T14:02:46.878Z 2025-11-25T15:06:10.647Z
8487235 8487235 20251116123302_nGb7w AU001D 2025-11-18T14:02:35.767Z 2025-11-25T15:06:09.091Z
8486575 8486575 20251112194408_oFxJj AU001D 2025-11-17T14:43:43.612Z 2025-11-21T15:11:18.465Z
8479601 8479601 20251115193530_kJoiO AU001D 2025-11-17T14:16:20.238Z 2025-11-24T15:04:46.184Z
8479424 8479424 20251115191724_a2pXc AU001D 2025-11-17T14:15:49.804Z 2025-11-24T15:04:44.757Z
8479155 8479155 20251115184225_VVyKs AU001D 2025-11-17T14:15:03.966Z 2025-11-24T15:04:33.987Z
8479097 8479097 20251115183631_ZLrvZ AU001D 2025-11-17T14:14:57.233Z 2025-11-24T15:04:32.500Z
8478650 8478650 20251115174111_1JgWX AU001D 2025-11-17T14:13:57.664Z 2025-11-24T15:04:18.747Z
8477953 8477953 20251115162643_QFp9r AU001D 2025-11-17T14:12:17.255Z 2025-11-24T15:03:53.579Z
8476777 8476777 20251115145952_L6BVZ AU001D 2025-11-17T14:09:38.075Z 2025-11-24T15:03:13.598Z
8475266 8475266 20251115134600_DdLjk AU001D 2025-11-17T14:06:23.059Z 2025-11-24T15:03:01.350Z
8475265 8475265 20251115134534_s4FKu AU001D 2025-11-17T14:06:22.726Z 2025-11-24T15:03:01.318Z
8472670 8472670 20251111192353_4pthj AU001D 2025-11-16T14:42:25.615Z 2025-11-20T15:22:10.935Z
8471120 8471120 20251113150236_LHzxE AU001D 2025-11-16T14:25:30.252Z 2025-11-22T15:19:13.176Z
8466689 8466689 20251114185211_MqfWx AU001D 2025-11-16T14:12:44.304Z 2025-11-23T15:17:04.368Z
8466533 8466533 20251114183738_POUfS AU001D 2025-11-16T14:12:24.225Z 2025-11-23T15:17:03.462Z
8464772 8464772 20251114152107_BkiAp AU001D 2025-11-16T14:07:17.054Z 2025-11-23T15:16:31.695Z
8463414 8463414 20251114130509_mTI0U AU001D 2025-11-16T14:03:12.518Z 2025-11-23T15:15:51.424Z
8463274 8463274 20251114124921_sP7bb AU001D 2025-11-16T14:02:40.022Z 2025-11-23T15:15:48.351Z
8446594 8446594 20251112175535_Vez04 AU001D 2025-11-14T14:11:21.083Z 2025-11-21T15:11:11.970Z
8446429 8446429 20251112172940_mB9vl AU001D 2025-11-14T14:10:46.825Z 2025-11-21T15:11:10.194Z
8445047 8445047 20251112144018_xpttO AU001D 2025-11-14T14:06:17.969Z 2025-11-21T15:10:36.561Z
8435011 8435011 20251111190257_psN2w AU001D 2025-11-13T14:14:18.338Z 2025-11-20T15:21:58.394Z
8433300 8433300 20251111164856_VV5Re AU001D 2025-11-13T14:09:46.525Z 2025-11-20T15:20:38.788Z
8432551 8432551 20251111153930_usPgX AU001D 2025-11-13T14:07:55.890Z 2025-11-20T15:20:16.569Z
8432385 8432385 20251111152609_wBtU2 AU001D 2025-11-13T14:07:23.637Z 2025-11-20T15:20:12.996Z
8431986 8431986 20251111145545_poAol AU001D 2025-11-13T14:06:22.627Z 2025-11-20T15:20:06.703Z
8431696 8431696 20251111143712_s1LlK AU001D 2025-11-13T14:05:29.766Z 2025-11-20T15:20:02.251Z
8428739 8428739 20251110121417_b6tGP AU001D 2025-11-12T14:37:57.502Z 2025-11-18T15:22:07.255Z
8428737 8428737 20251110120118_2en7C AU001D 2025-11-12T14:37:55.758Z 2025-11-18T15:22:01.308Z
8420712 8420712 20251110193037_07UFf AU001D 2025-11-12T14:11:43.765Z 2025-11-19T15:14:14.000Z
8420584 8420584 20251110192209_GLh2v AU001D 2025-11-12T14:11:24.511Z 2025-11-19T15:14:11.651Z
8420527 8420527 20251110191403_36zFs AU001D 2025-11-12T14:11:08.240Z 2025-11-19T15:14:10.590Z
8419812 8419812 20251110173953_oI3YE AU001D 2025-11-12T14:08:28.230Z 2025-11-19T15:13:28.535Z
8419771 8419771 20251110173339_PXRar AU001D 2025-11-12T14:08:09.497Z 2025-11-19T15:13:25.147Z
8419744 8419744 20251110173018_LknlA AU001D 2025-11-12T14:08:02.142Z 2025-11-19T15:13:22.086Z
8419707 8419707 20251110172254_KpY1l AU001D 2025-11-12T14:07:55.782Z 2025-11-19T15:13:20.920Z
8419630 8419630 20251110170828_3eWtL AU001D 2025-11-12T14:07:32.592Z 2025-11-19T15:13:18.462Z
8418963 8418963 20251110150750_NqeC5 AU001D 2025-11-12T14:04:42.634Z 2025-11-19T15:12:54.381Z
8418759 8418759 20251110143042_Y0ELP AU001D 2025-11-12T14:03:32.735Z 2025-11-19T15:12:45.163Z
8418511 8418511 20251110135558_HztOu AU001D 2025-11-12T14:02:27.193Z 2025-11-19T15:12:33.961Z
8409756 8409756 20251109141926_S4rlD AU001D 2025-11-11T14:04:36.835Z 2025-11-18T15:18:42.907Z
8409514 8409514 20251109133347_0tsO0 AU001D 2025-11-11T14:03:19.346Z 2025-11-18T15:18:39.415Z
8408763 8408763 20251108121205_6PJBL AU001D 2025-11-10T14:31:46.810Z 2025-11-16T15:06:01.958Z
8408751 8408751 20251108115404_u1q3E AU001D 2025-11-10T14:31:36.927Z 2025-11-16T15:06:00.813Z
8402405 8402405 20251108194250_KCwDz AU001D 2025-11-10T14:06:48.329Z 2025-11-17T14:58:16.976Z
8402375 8402375 20251108193043_cGBGk AU001D 2025-11-10T14:06:29.752Z 2025-11-17T14:58:15.108Z
8402214 8402214 20251108185415_OhM89 AU001D 2025-11-10T14:05:54.544Z 2025-11-17T14:58:13.043Z
8402127 8402127 20251108183055_29xil AU001D 2025-11-10T14:05:38.547Z 2025-11-17T14:58:08.660Z
8402103 8402103 20251108182622_xau3B AU001D 2025-11-10T14:05:35.148Z 2025-11-17T14:58:07.824Z
8401871 8401871 20251108174639_RNM2n AU001D 2025-11-10T14:04:37.783Z 2025-11-17T14:58:03.491Z
8401819 8401819 20251108173818_YZd6h AU001D 2025-11-10T14:04:29.685Z 2025-11-17T14:58:02.999Z

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