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

5,839 rows where station_code = "AU0029" 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
8683368 8683368 20251201172210_scwVm AU0029 2025-12-04T14:23:47.755Z 2025-12-04T14:23:47.755Z
8673166 8673166 20251201171939_TBsGj AU0029 2025-12-03T14:17:43.277Z 2025-12-04T14:23:45.582Z
8667261 8667261 20251129193137_SXtN2 AU0029 2025-12-02T14:35:58.530Z 2025-12-04T14:38:43.116Z
8667259 8667259 20251129192820_Hu5wR AU0029 2025-12-02T14:35:57.734Z 2025-12-04T14:38:42.362Z
8667240 8667240 20251129191552_WoYKl AU0029 2025-12-02T14:35:53.732Z 2025-12-04T14:38:39.962Z
8650268 8650268 20251129194831_9EDed AU0029 2025-12-01T14:15:41.520Z 2025-12-04T14:38:47.623Z
8650076 8650076 20251129191840_JHCks AU0029 2025-12-01T14:15:01.188Z 2025-12-04T14:38:40.664Z
8649878 8649878 20251129184512_kdX0C AU0029 2025-12-01T14:14:12.066Z 2025-12-04T14:38:32.682Z
8649868 8649868 20251129184242_C6yLF AU0029 2025-12-01T14:14:10.288Z 2025-12-04T14:38:32.387Z
8649787 8649787 20251129182536_cw94m AU0029 2025-12-01T14:13:57.199Z 2025-12-04T14:38:26.652Z
8649619 8649619 20251129175732_F4M3H AU0029 2025-12-01T14:13:21.260Z 2025-12-04T14:38:07.617Z
8649542 8649542 20251129174400_Zz3TU AU0029 2025-12-01T14:12:59.867Z 2025-12-04T14:38:02.738Z
8649525 8649525 20251129174001_e7mLc AU0029 2025-12-01T14:12:56.607Z 2025-12-04T14:38:01.716Z
8649109 8649109 20251129161420_LAYna AU0029 2025-12-01T14:10:57.669Z 2025-12-04T14:37:30.978Z
8648974 8648974 20251129153658_Lrh9u AU0029 2025-12-01T14:10:15.841Z 2025-12-04T14:37:20.786Z
8648972 8648972 20251129153620_2Vizf AU0029 2025-12-01T14:10:15.503Z 2025-12-04T14:37:20.709Z
8648868 8648868 20251129141949_puebE AU0029 2025-12-01T14:08:42.138Z 2025-12-04T14:37:07.385Z
8648844 8648844 20251129135042_O1ZEo AU0029 2025-12-01T14:08:07.351Z 2025-12-04T14:37:03.534Z
8648789 8648789 20251129123140_IEaFB AU0029 2025-12-01T14:06:25.940Z 2025-12-04T14:36:38.075Z
8644595 8644595 20251128193558_mgQfZ AU0029 2025-11-30T14:22:08.173Z 2025-12-04T14:48:29.340Z
8644080 8644080 20251128185554_sO3L1 AU0029 2025-11-30T14:21:18.915Z 2025-12-04T14:48:19.606Z
8643448 8643448 20251128175808_bO1Dq AU0029 2025-11-30T14:20:02.218Z 2025-12-04T14:47:45.350Z
8643284 8643284 20251128174110_DDsP2 AU0029 2025-11-30T14:19:50.131Z 2025-12-04T14:47:41.946Z
8643140 8643140 20251128172804_uxgDH AU0029 2025-11-30T14:19:22.847Z 2025-12-04T14:47:39.679Z
8643050 8643050 20251128171601_dL3Rg AU0029 2025-11-30T14:19:16.340Z 2025-12-04T14:47:38.190Z
8643012 8643012 20251128171156_ISIXa AU0029 2025-11-30T14:19:13.026Z 2025-12-04T14:47:37.266Z
8642965 8642965 20251128170803_ytPu6 AU0029 2025-11-30T14:19:05.888Z 2025-12-04T14:47:36.497Z
8642812 8642812 20251128165241_0ELOy AU0029 2025-11-30T14:18:40.125Z 2025-12-04T14:47:33.277Z
8642597 8642597 20251128162948_dRNxK AU0029 2025-11-30T14:18:20.880Z 2025-12-04T14:47:21.270Z
8642504 8642504 20251128161342_rGx4P AU0029 2025-11-30T14:18:03.171Z 2025-12-04T14:47:01.970Z
8642472 8642472 20251128160958_8htyt AU0029 2025-11-30T14:18:00.894Z 2025-12-04T14:47:01.554Z
8642406 8642406 20251128160049_sYKiu AU0029 2025-11-30T14:17:52.562Z 2025-12-04T14:47:00.561Z
8641818 8641818 20251128151506_c8X8v AU0029 2025-11-30T14:17:02.645Z 2025-12-04T14:46:50.593Z
8641058 8641058 20251128133329_JviH3 AU0029 2025-11-30T14:14:00.141Z 2025-12-04T14:46:05.671Z
8641047 8641047 20251128132320_a354l AU0029 2025-11-30T14:13:52.114Z 2025-12-04T14:46:04.100Z
8631017 8631017 20251127180429_amyvL AU0029 2025-11-29T14:14:25.447Z 2025-12-04T14:54:24.280Z
8564894 8564894 20251121193049_H9kSP AU0029 2025-11-23T14:11:57.039Z 2025-11-30T15:04:33.918Z
8564318 8564318 20251121181902_P4S8F AU0029 2025-11-23T14:10:34.142Z 2025-11-30T15:04:12.712Z
8563901 8563901 20251121173834_GqkMS AU0029 2025-11-23T14:09:34.974Z 2025-11-30T15:03:53.854Z
8563035 8563035 20251121151033_g3tp1 AU0029 2025-11-23T14:07:07.373Z 2025-11-30T15:03:34.818Z
8563011 8563011 20251121150716_pW1aH AU0029 2025-11-23T14:07:04.339Z 2025-11-30T15:03:34.700Z
8562822 8562822 20251121144745_ywuD8 AU0029 2025-11-23T14:06:36.488Z 2025-11-30T15:03:33.200Z
8562526 8562526 20251121142412_Ud5y0 AU0029 2025-11-23T14:05:55.821Z 2025-11-30T15:03:30.635Z
8562193 8562193 20251121134646_Xw4wV AU0029 2025-11-23T14:04:53.810Z 2025-11-30T15:03:24.328Z
8561997 8561997 20251121132057_Zc8oi AU0029 2025-11-23T14:04:19.409Z 2025-11-30T15:03:20.760Z
8500001 8500001 20251115191059_lbve0 AU0029 2025-11-18T14:41:23.339Z 2025-11-24T15:04:42.866Z
8499999 8499999 20251115190354_21eu3 AU0029 2025-11-18T14:41:21.552Z 2025-11-24T15:04:38.515Z
8499989 8499989 20251115183631_dQC2g AU0029 2025-11-18T14:41:12.047Z 2025-11-24T15:04:32.499Z
8498774 8498774 20251116192702_gfsWX AU0029 2025-11-18T14:31:30.738Z 2025-11-25T15:08:15.599Z
8479602 8479602 20251115193530_kJoiO AU0029 2025-11-17T14:16:20.238Z 2025-11-24T15:04:46.184Z
8479206 8479206 20251115185114_1Bij8 AU0029 2025-11-17T14:15:13.552Z 2025-11-24T15:04:35.775Z
8478659 8478659 20251115174212_Jt9yd AU0029 2025-11-17T14:13:58.312Z 2025-11-24T15:04:18.862Z
8478651 8478651 20251115174111_1JgWX AU0029 2025-11-17T14:13:57.664Z 2025-11-24T15:04:18.747Z
8478622 8478622 20251115173632_3eHNI AU0029 2025-11-17T14:13:53.026Z 2025-11-24T15:04:17.042Z
8471241 8471241 20251113175435_yj2BP AU0029 2025-11-16T14:26:50.488Z 2025-11-22T15:20:34.962Z
8453948 8453948 20251113143321_5TIn0 AU0029 2025-11-15T14:04:22.814Z 2025-11-22T15:18:58.139Z
8453877 8453877 20251113142730_yUx16 AU0029 2025-11-15T14:04:12.090Z 2025-11-22T15:18:53.564Z
8442320 8442320 20251110191403_Ecq3I AU0029 2025-11-13T14:42:46.282Z 2025-11-19T15:14:10.696Z
8430041 8430041 20251108172808_T3PZl AU0029 2025-11-12T14:47:33.445Z 2025-11-17T14:58:02.068Z
8428738 8428738 20251110120118_2en7C AU0029 2025-11-12T14:37:55.758Z 2025-11-18T15:22:01.308Z
8428735 8428735 20251110115706_TEuT2 AU0029 2025-11-12T14:37:55.360Z 2025-11-18T15:22:01.066Z
8420447 8420447 20251110190713_7Fwly AU0029 2025-11-12T14:10:52.831Z 2025-11-19T15:14:03.862Z
8419913 8419913 20251110175416_nOEn2 AU0029 2025-11-12T14:08:44.700Z 2025-11-19T15:13:30.345Z
8419746 8419746 20251110173018_LknlA AU0029 2025-11-12T14:08:02.142Z 2025-11-19T15:13:22.086Z
8419563 8419563 20251110165658_bjEmn AU0029 2025-11-12T14:07:17.389Z 2025-11-19T15:13:15.537Z
8418977 8418977 20251110150947_XWBdY AU0029 2025-11-12T14:04:45.530Z 2025-11-19T15:12:54.654Z
8418938 8418938 20251110150154_NE3nw AU0029 2025-11-12T14:04:26.794Z 2025-11-12T14:38:14.191Z
8402450 8402450 20251108195733_HtaTx AU0029 2025-11-10T14:06:55.016Z 2025-11-17T14:58:17.997Z
8402412 8402412 20251108194528_5d7hp AU0029 2025-11-10T14:06:49.586Z 2025-11-17T14:58:17.113Z
8402135 8402135 20251108183323_292nL AU0029 2025-11-10T14:05:40.090Z 2025-11-17T14:58:08.702Z
8401744 8401744 20251108170728_f6mrl AU0029 2025-11-10T14:04:15.643Z 2025-11-17T14:58:00.907Z
8401661 8401661 20251108161203_on23o AU0029 2025-11-10T14:03:47.728Z 2025-11-17T14:57:56.767Z
8401537 8401537 20251108151809_wtBYf AU0029 2025-11-10T14:03:03.847Z 2025-11-17T14:57:52.777Z
8401426 8401426 20251108144847_5vMTU AU0029 2025-11-10T14:02:33.710Z 2025-11-17T14:57:48.886Z
8401325 8401325 20251108142416_Nq2dt AU0029 2025-11-10T14:02:12.874Z 2025-11-17T14:57:47.230Z
8401304 8401304 20251108141844_ATvd6 AU0029 2025-11-10T14:02:01.678Z 2025-11-17T14:57:46.980Z
8401142 8401142 20251108124559_hqliI AU0029 2025-11-10T14:00:50.624Z 2025-11-17T14:57:44.239Z
8400958 8400958 20251107122336_QcmBk AU0029 2025-11-09T14:30:21.189Z 2025-11-15T15:01:10.982Z
8396267 8396267 20251107200957_Zi0jU AU0029 2025-11-09T14:08:00.878Z 2025-11-16T15:03:23.130Z
8396130 8396130 20251107193943_pdN2g AU0029 2025-11-09T14:07:29.647Z 2025-11-16T15:03:10.197Z
8396044 8396044 20251107191607_Jdjd6 AU0029 2025-11-09T14:07:05.117Z 2025-11-16T15:03:05.330Z
8395978 8395978 20251107190126_ZHQhA AU0029 2025-11-09T14:06:46.504Z 2025-11-16T15:03:01.533Z
8395930 8395930 20251107185031_RgrUe AU0029 2025-11-09T14:06:34.175Z 2025-11-16T15:02:59.588Z
8395916 8395916 20251107184513_z3DvM AU0029 2025-11-09T14:06:30.961Z 2025-11-16T15:02:59.162Z
8395892 8395892 20251107184010_cG56P AU0029 2025-11-09T14:06:25.799Z 2025-11-16T15:02:55.812Z
8395768 8395768 20251107180845_NF78H AU0029 2025-11-09T14:05:51.758Z 2025-11-16T15:02:45.470Z
8395586 8395586 20251107172052_RMYLR AU0029 2025-11-09T14:05:00.060Z 2025-11-16T15:02:34.320Z
8395475 8395475 20251107164011_Q5H1f AU0029 2025-11-09T14:04:25.351Z 2025-11-10T14:25:35.766Z
8395447 8395447 20251107162924_gtHdj AU0029 2025-11-09T14:04:19.676Z 2025-11-16T15:02:24.322Z
8395396 8395396 20251107155726_QJLPL AU0029 2025-11-09T14:03:59.330Z 2025-11-16T15:02:18.473Z
8395120 8395120 20251107141442_4tKEY AU0029 2025-11-09T14:02:26.632Z 2025-11-16T15:02:02.426Z
8395079 8395079 20251107135521_2aP8g AU0029 2025-11-09T14:02:15.147Z 2025-11-16T15:02:01.545Z
8395050 8395050 20251107134708_5tvQ8 AU0029 2025-11-09T14:02:03.544Z 2025-11-16T15:02:00.772Z
8395028 8395028 20251107133650_SXplE AU0029 2025-11-09T14:01:55.216Z 2025-11-10T14:24:36.699Z
8394961 8394961 20251107125513_bx3IF AU0029 2025-11-09T14:01:27.879Z 2025-11-16T15:01:54.384Z
8394661 8394661 20251106122603_JAyre AU0029 2025-11-08T14:30:59.155Z 2025-11-14T15:08:57.160Z
8388653 8388653 20251106154623_J6y6x AU0029 2025-11-08T14:02:51.372Z 2025-11-15T14:59:11.066Z
8388649 8388649 20251106153848_xumON AU0029 2025-11-08T14:02:49.969Z 2025-11-15T14:59:10.901Z
8388626 8388626 20251106150154_j7TC2 AU0029 2025-11-08T14:02:31.411Z 2025-11-15T14:59:08.376Z
8388580 8388580 20251106135131_r3M9z AU0029 2025-11-08T14:02:03.487Z 2025-11-15T14:58:55.518Z

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