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,962 rows where station_code = "AU001C" 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
8683416 8683416 20251201192337_pHVXQ AU001C 2025-12-04T14:24:21.022Z 2025-12-04T14:24:21.022Z
8678601 8678601 20251202155233_mJ7B2 AU001C 2025-12-04T14:07:29.648Z 2025-12-04T14:19:08.138Z
8673090 8673090 20251201165230_IJPS0 AU001C 2025-12-03T14:17:31.440Z 2025-12-04T14:23:34.144Z
8673056 8673056 20251201163839_riEE2 AU001C 2025-12-03T14:17:15.753Z 2025-12-04T14:23:31.702Z
8673055 8673055 20251201163810_8SUEF AU001C 2025-12-03T14:17:15.517Z 2025-12-04T14:23:31.605Z
8673050 8673050 20251201163218_pBSXk AU001C 2025-12-03T14:17:15.036Z 2025-12-04T14:23:31.305Z
8672776 8672776 20251201151707_BwkNh AU001C 2025-12-03T14:16:25.667Z 2025-12-04T14:23:10.254Z
8672238 8672238 20251201140755_1se6m AU001C 2025-12-03T14:15:08.989Z 2025-12-04T14:22:36.308Z
8666710 8666710 20251130190507_duw2o AU001C 2025-12-02T14:27:11.273Z 2025-12-04T14:31:25.752Z
8666649 8666649 20251130174257_nU5jB AU001C 2025-12-02T14:27:02.803Z 2025-12-04T14:30:48.073Z
8662753 8662753 20251130192646_u3trz AU001C 2025-12-02T14:16:29.147Z 2025-12-04T14:31:34.543Z
8662429 8662429 20251130184918_vrW3W AU001C 2025-12-02T14:15:27.513Z 2025-12-04T14:31:20.978Z
8662135 8662135 20251130180444_F1h4m AU001C 2025-12-02T14:14:28.356Z 2025-12-04T14:30:54.748Z
8662049 8662049 20251130174759_gJzJf AU001C 2025-12-02T14:14:05.692Z 2025-12-04T14:30:50.259Z
8661907 8661907 20251130173022_WHjrH AU001C 2025-12-02T14:13:34.822Z 2025-12-04T14:30:31.867Z
8661885 8661885 20251130172913_UIE8T AU001C 2025-12-02T14:13:31.651Z 2025-12-04T14:30:31.000Z
8661450 8661450 20251130152407_Ban2p AU001C 2025-12-02T14:11:31.305Z 2025-12-04T14:29:53.107Z
8661133 8661133 20251130144738_megvW AU001C 2025-12-02T14:10:30.239Z 2025-12-04T14:29:36.788Z
8660856 8660856 20251130140312_2Ehfi AU001C 2025-12-02T14:09:29.476Z 2025-12-04T14:29:14.985Z
8660760 8660760 20251130134712_AxhEY AU001C 2025-12-02T14:09:06.437Z 2025-12-04T14:29:10.530Z
8649281 8649281 20251129165925_gLDG2 AU001C 2025-12-01T14:11:53.184Z 2025-12-04T14:37:51.360Z
8649279 8649279 20251129165918_R6vrm AU001C 2025-12-01T14:11:52.595Z 2025-12-04T14:37:51.299Z
8649271 8649271 20251129165552_u6e9g AU001C 2025-12-01T14:11:50.774Z 2025-12-04T14:37:50.925Z
8649224 8649224 20251129164415_jOBa6 AU001C 2025-12-01T14:11:30.594Z 2025-12-04T14:37:49.190Z
8649126 8649126 20251129161809_qHU65 AU001C 2025-12-01T14:11:02.532Z 2025-12-04T14:37:43.757Z
8649110 8649110 20251129161532_m3Xgw AU001C 2025-12-01T14:10:58.335Z 2025-12-04T14:37:32.115Z
8649065 8649065 20251129155933_NPsGK AU001C 2025-12-01T14:10:47.100Z 2025-12-04T14:37:27.975Z
8644586 8644586 20251128193453_x0EFA AU001C 2025-11-30T14:22:07.509Z 2025-12-04T14:48:29.194Z
8644516 8644516 20251128193001_hdR5w AU001C 2025-11-30T14:22:03.906Z 2025-12-04T14:48:27.903Z
8644506 8644506 20251128192908_X70j6 AU001C 2025-11-30T14:22:03.096Z 2025-12-04T14:48:27.705Z
8644193 8644193 20251128190614_keLdl AU001C 2025-11-30T14:21:26.953Z 2025-12-04T14:48:21.821Z
8644094 8644094 20251128185649_3zFb5 AU001C 2025-11-30T14:21:19.490Z 2025-12-04T14:48:19.754Z
8643971 8643971 20251128184232_WJfBh AU001C 2025-11-30T14:20:55.891Z 2025-12-04T14:48:16.737Z
8638154 8638154 20251126175318_5ZKWg AU001C 2025-11-29T14:33:23.639Z 2025-12-04T15:01:52.414Z
8631089 8631089 20251127181557_2zNPi AU001C 2025-11-29T14:14:32.758Z 2025-12-04T14:54:25.922Z
8631071 8631071 20251127181222_uV5Sa AU001C 2025-11-29T14:14:30.756Z 2025-12-04T14:54:25.549Z
8630194 8630194 20251127151544_42Y5N AU001C 2025-11-29T14:12:03.685Z 2025-12-04T14:53:33.821Z
8625295 8625295 20251125172814_163A8 AU001C 2025-11-28T14:30:15.612Z 2025-12-04T15:05:48.305Z
8622322 8622322 20251126184644_z3wcE AU001C 2025-11-28T14:18:23.520Z 2025-12-04T15:02:15.491Z
8622280 8622280 20251126183419_X78p7 AU001C 2025-11-28T14:18:18.693Z 2025-12-04T15:02:10.063Z
8622189 8622189 20251126180915_31kos AU001C 2025-11-28T14:18:05.388Z 2025-12-04T15:01:58.134Z
8622091 8622091 20251126174849_bijAS AU001C 2025-11-28T14:17:40.382Z 2025-12-04T15:01:51.679Z
8621921 8621921 20251126170823_xzcpK AU001C 2025-11-28T14:17:02.608Z 2025-12-04T15:01:45.860Z
8621876 8621876 20251126165346_sZYLi AU001C 2025-11-28T14:16:56.790Z 2025-12-04T15:01:45.070Z
8605727 8605727 20251125162533_NDocY AU001C 2025-11-27T14:07:27.753Z 2025-12-04T15:05:37.768Z
8605673 8605673 20251125155512_qZDo7 AU001C 2025-11-27T14:07:16.082Z 2025-12-04T15:05:36.654Z
8595418 8595418 20251124153851_ko2NF AU001C 2025-11-26T14:11:01.960Z 2025-12-02T15:05:56.376Z
8586122 8586122 20251123184744_xBx23 AU001C 2025-11-25T14:12:06.490Z 2025-12-02T15:10:44.132Z
8586118 8586118 20251123184701_lsAfM AU001C 2025-11-25T14:12:05.777Z 2025-12-02T15:10:44.093Z
8586067 8586067 20251123183836_0UDrm AU001C 2025-11-25T14:11:45.622Z 2025-12-02T15:10:40.185Z
8577981 8577981 20251122192027_1vtbd AU001C 2025-11-24T14:10:22.302Z 2025-12-01T15:19:05.191Z
8577446 8577446 20251122180950_0tO5Q AU001C 2025-11-24T14:08:37.476Z 2025-12-01T15:18:50.380Z
8577336 8577336 20251122175649_2ijZy AU001C 2025-11-24T14:08:25.114Z 2025-12-01T15:18:47.782Z
8576972 8576972 20251122165512_5Qq86 AU001C 2025-11-24T14:07:13.723Z 2025-12-01T15:18:41.999Z
8561996 8561996 20251121132057_Zc8oi AU001C 2025-11-23T14:04:19.409Z 2025-11-30T15:03:20.760Z
8561770 8561770 20251121125725_oc5r7 AU001C 2025-11-23T14:03:40.006Z 2025-11-30T15:03:12.060Z
8520247 8520247 20251118190722_Z9U9j AU001C 2025-11-20T14:09:24.510Z 2025-11-27T15:11:32.252Z
8503043 8503043 20251117162315_GBgbe AU001C 2025-11-19T14:04:26.197Z 2025-11-26T15:06:18.955Z
8502206 8502206 20251117130758_9cHXe AU001C 2025-11-19T14:01:50.625Z 2025-11-26T15:06:07.370Z
8501628 8501628 20251114161059_AoxkO AU001C 2025-11-18T14:48:45.790Z 2025-11-23T15:16:51.054Z
8501621 8501621 20251114153907_wc0lw AU001C 2025-11-18T14:48:41.392Z 2025-11-23T15:16:38.163Z
8498730 8498730 20251116163721_FUcmk AU001C 2025-11-18T14:31:12.432Z 2025-11-25T15:07:30.153Z
8489914 8489914 20251116180419_jqpBR AU001C 2025-11-18T14:12:04.516Z 2025-11-25T15:07:51.685Z
8489666 8489666 20251116171825_GLcOC AU001C 2025-11-18T14:11:04.176Z 2025-11-25T15:07:37.660Z
8489458 8489458 20251116164113_LVt5q AU001C 2025-11-18T14:10:11.706Z 2025-11-25T15:07:30.199Z
8489448 8489448 20251116163721_o7rZZ AU001C 2025-11-18T14:10:09.807Z 2025-11-25T15:07:30.139Z
8489388 8489388 20251116162259_ZupBQ AU001C 2025-11-18T14:09:56.498Z 2025-11-25T15:07:29.309Z
8489219 8489219 20251116153938_YdeX6 AU001C 2025-11-18T14:09:12.139Z 2025-11-25T15:07:19.147Z
8479655 8479655 20251115194239_K8Wwr AU001C 2025-11-17T14:16:26.718Z 2025-11-24T15:04:46.793Z
8478815 8478815 20251115180506_Dh9yM AU001C 2025-11-17T14:14:23.912Z 2025-11-24T15:04:24.218Z
8478800 8478800 20251115180128_f5nqd AU001C 2025-11-17T14:14:21.491Z 2025-11-24T15:04:23.709Z
8478658 8478658 20251115174212_Jt9yd AU001C 2025-11-17T14:13:58.312Z 2025-11-24T15:04:18.862Z
8478052 8478052 20251115164139_55I0p AU001C 2025-11-17T14:12:42.181Z 2025-11-24T15:03:59.031Z
8477932 8477932 20251115162421_wekIK AU001C 2025-11-17T14:12:12.915Z 2025-11-24T15:03:53.063Z
8477766 8477766 20251115160142_NX3GJ AU001C 2025-11-17T14:11:57.763Z 2025-11-24T15:03:48.845Z
8477584 8477584 20251115154235_E3EJk AU001C 2025-11-17T14:11:26.053Z 2025-11-24T15:03:44.185Z
8477093 8477093 20251115151517_1IdFA AU001C 2025-11-17T14:10:30.829Z 2025-11-24T15:03:24.181Z
8475173 8475173 20251115134139_FdDtN AU001C 2025-11-17T14:06:02.530Z 2025-11-24T15:03:00.754Z
8474753 8474753 20251115132146_EjJeW AU001C 2025-11-17T14:05:18.713Z 2025-11-24T15:02:58.063Z
8471160 8471160 20251113154325_Yt709 AU001C 2025-11-16T14:25:59.334Z 2025-11-22T15:19:47.342Z
8471119 8471119 20251113150236_LHzxE AU001C 2025-11-16T14:25:30.252Z 2025-11-22T15:19:13.176Z
8467157 8467157 20251114194434_260Mo AU001C 2025-11-16T14:13:57.473Z 2025-11-23T15:17:07.218Z
8466542 8466542 20251114183855_0fOKE AU001C 2025-11-16T14:12:25.831Z 2025-11-23T15:17:03.604Z
8466301 8466301 20251114181730_TaaA6 AU001C 2025-11-16T14:11:47.755Z 2025-11-23T15:17:02.067Z
8465926 8465926 20251114173008_REOGe AU001C 2025-11-16T14:10:37.482Z 2025-11-23T15:16:59.535Z
8465860 8465860 20251114171930_oZ1qA AU001C 2025-11-16T14:10:28.733Z 2025-11-23T15:16:58.923Z
8465219 8465219 20251114160536_2mx9X AU001C 2025-11-16T14:08:36.191Z 2025-11-23T15:16:50.013Z
8465191 8465191 20251114160216_72u23 AU001C 2025-11-16T14:08:34.130Z 2025-11-23T15:16:49.946Z
8465031 8465031 20251114154056_cZN6V AU001C 2025-11-16T14:07:58.257Z 2025-11-23T15:16:40.705Z
8463722 8463722 20251114133832_amSa5 AU001C 2025-11-16T14:04:08.281Z 2025-11-23T15:16:03.443Z
8447286 8447286 20251112192532_y10vB AU001C 2025-11-14T14:13:36.265Z 2025-11-21T15:11:17.519Z
8447254 8447254 20251112192151_hgR8X AU001C 2025-11-14T14:13:29.511Z 2025-11-21T15:11:17.401Z
8446776 8446776 20251112181724_TdPiP AU001C 2025-11-14T14:11:59.547Z 2025-11-21T15:11:13.661Z
8446140 8446140 20251112165522_Lk2JZ AU001C 2025-11-14T14:09:37.807Z 2025-11-21T15:11:07.521Z
8446059 8446059 20251112164141_oRGow AU001C 2025-11-14T14:09:24.016Z 2025-11-21T15:11:06.864Z
8444480 8444480 20251112124057_KEMni AU001C 2025-11-14T14:04:10.863Z 2025-11-21T15:10:19.772Z
8442241 8442241 20251110133309_9YU9U AU001C 2025-11-13T14:40:23.052Z 2025-11-19T15:12:30.766Z
8442239 8442239 20251110131253_s2nTg AU001C 2025-11-13T14:40:20.857Z 2025-11-19T15:12:26.659Z
8435636 8435636 20251111195626_XZ4jo AU001C 2025-11-13T14:16:04.574Z 2025-11-20T15:22:25.529Z
8434075 8434075 20251111174849_1L4ST AU001C 2025-11-13T14:11:53.303Z 2025-11-20T15:21:21.842Z

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