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,259 rows where station_code = "AU002D" 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
8672193 8672193 20251201140133_USCvd AU002D 2025-12-03T14:14:55.579Z 2025-12-06T14:31:48.298Z
8650310 8650310 20251129195157_jcrso AU002D 2025-12-01T14:15:46.479Z 2025-12-06T14:45:53.975Z
8650182 8650182 20251129193517_bfBFY AU002D 2025-12-01T14:15:20.079Z 2025-12-06T14:45:49.786Z
8649984 8649984 20251129190004_2g7BO AU002D 2025-12-01T14:14:38.347Z 2025-12-06T14:45:44.415Z
8649946 8649946 20251129185629_93u2F AU002D 2025-12-01T14:14:31.956Z 2025-12-06T14:45:43.586Z
8649661 8649661 20251129180412_CnIdk AU002D 2025-12-01T14:13:26.676Z 2025-12-06T14:45:35.604Z
8649531 8649531 20251129174216_Efss9 AU002D 2025-12-01T14:12:58.132Z 2025-12-06T14:45:32.270Z
8649362 8649362 20251129171500_DUkV8 AU002D 2025-12-01T14:12:12.472Z 2025-12-06T14:45:01.656Z
8649322 8649322 20251129170547_jS5qP AU002D 2025-12-01T14:12:01.065Z 2025-12-06T14:44:55.867Z
8649316 8649316 20251129170406_d3Owm AU002D 2025-12-01T14:11:59.441Z 2025-12-06T14:44:55.545Z
8649226 8649226 20251129164512_lUwJV AU002D 2025-12-01T14:11:31.033Z 2025-12-06T14:44:52.971Z
8649136 8649136 20251129162059_ZDlcM AU002D 2025-12-01T14:11:04.743Z 2025-12-06T14:44:49.536Z
8648921 8648921 20251129151001_Zr3Cg AU002D 2025-12-01T14:09:37.656Z 2025-12-06T14:44:40.738Z
8648919 8648919 20251129150744_VuPJY AU002D 2025-12-01T14:09:34.326Z 2025-12-06T14:44:40.255Z
8648876 8648876 20251129142105_xMePO AU002D 2025-12-01T14:08:44.287Z 2025-12-06T14:44:35.230Z
8648856 8648856 20251129141114_lelBA AU002D 2025-12-01T14:08:30.124Z 2025-12-06T14:44:33.267Z
8648852 8648852 20251129135850_SoNkl AU002D 2025-12-01T14:08:22.717Z 2025-12-06T14:44:32.508Z
8648770 8648770 20251129122330_WO71c AU002D 2025-12-01T14:06:05.827Z 2025-12-06T14:43:53.819Z
8644137 8644137 20251128190115_ykML8 AU002D 2025-11-30T14:21:23.095Z 2025-12-06T14:54:38.561Z
8643428 8643428 20251128175527_PlK3u AU002D 2025-11-30T14:20:01.145Z 2025-12-06T14:53:49.460Z
8643285 8643285 20251128174110_DDsP2 AU002D 2025-11-30T14:19:50.131Z 2025-12-06T14:53:45.851Z
8642080 8642080 20251128153013_7VR1R AU002D 2025-11-30T14:17:19.626Z 2025-12-06T14:53:15.340Z
8641819 8641819 20251128151506_c8X8v AU002D 2025-11-30T14:17:02.645Z 2025-12-06T14:52:55.978Z
8641059 8641059 20251128133329_JviH3 AU002D 2025-11-30T14:14:00.141Z 2025-12-06T14:52:21.233Z
8479425 8479425 20251115191724_a2pXc AU002D 2025-11-17T14:15:49.804Z 2025-11-24T15:04:44.758Z
8479403 8479403 20251115191548_i2p2C AU002D 2025-11-17T14:15:47.790Z 2025-11-24T15:04:44.487Z
8479194 8479194 20251115184805_7gYgn AU002D 2025-11-17T14:15:10.544Z 2025-11-24T15:04:35.131Z
8479156 8479156 20251115184225_VVyKs AU002D 2025-11-17T14:15:03.966Z 2025-11-24T15:04:33.987Z
8479102 8479102 20251115183701_G7yXI AU002D 2025-11-17T14:14:57.919Z 2025-11-24T15:04:32.588Z
8456627 8456627 20251113190518_Rzjd8 AU002D 2025-11-15T14:11:46.595Z 2025-11-22T15:20:45.263Z
8456368 8456368 20251113183153_Hsa2e AU002D 2025-11-15T14:11:08.197Z 2025-11-22T15:20:43.628Z
8420713 8420713 20251110193037_07UFf AU002D 2025-11-12T14:11:43.765Z 2025-11-19T15:14:14.000Z
8420585 8420585 20251110192209_GLh2v AU002D 2025-11-12T14:11:24.511Z 2025-11-19T15:14:11.651Z
8419778 8419778 20251110173349_H9ov0 AU002D 2025-11-12T14:08:10.298Z 2025-11-19T15:13:25.888Z
8419247 8419247 20251110155856_br682 AU002D 2025-11-12T14:06:04.104Z 2025-11-19T15:13:04.571Z
8418783 8418783 20251110143249_Suw40 AU002D 2025-11-12T14:03:36.565Z 2025-11-19T15:12:45.270Z
8418760 8418760 20251110143042_Y0ELP AU002D 2025-11-12T14:03:32.737Z 2025-11-19T15:12:45.163Z
8418514 8418514 20251110135558_zGU2c AU002D 2025-11-12T14:02:27.525Z 2025-11-19T15:12:33.963Z
8408764 8408764 20251108121205_6PJBL AU002D 2025-11-10T14:31:46.810Z 2025-11-16T15:06:01.958Z
8402406 8402406 20251108194250_KCwDz AU002D 2025-11-10T14:06:48.329Z 2025-11-17T14:58:16.976Z
8402376 8402376 20251108193043_cGBGk AU002D 2025-11-10T14:06:29.752Z 2025-11-17T14:58:15.108Z
8402128 8402128 20251108183055_29xil AU002D 2025-11-10T14:05:38.547Z 2025-11-17T14:58:08.660Z
8402104 8402104 20251108182622_xau3B AU002D 2025-11-10T14:05:35.148Z 2025-11-17T14:58:07.824Z
8401785 8401785 20251108172951_JF75U AU002D 2025-11-10T14:04:23.063Z 2025-11-17T14:58:02.314Z
8401737 8401737 20251108170424_cKDOs AU002D 2025-11-10T14:04:14.344Z 2025-11-17T14:58:00.667Z
8401634 8401634 20251108155502_C9hlA AU002D 2025-11-10T14:03:30.778Z 2025-11-17T14:57:56.593Z
8401595 8401595 20251108153326_7Akoj AU002D 2025-11-10T14:03:14.767Z 2025-11-17T14:57:56.178Z
8401503 8401503 20251108150927_YdfYn AU002D 2025-11-10T14:02:57.246Z 2025-11-17T14:57:50.859Z
8401447 8401447 20251108145614_8QaHU AU002D 2025-11-10T14:02:37.059Z 2025-11-17T14:57:48.985Z
8401356 8401356 20251108143028_xH9fZ AU002D 2025-11-10T14:02:21.812Z 2025-11-17T14:57:47.667Z
8401156 8401156 20251108130025_synnt AU002D 2025-11-10T14:01:00.288Z 2025-11-17T14:57:44.746Z
8400943 8400943 20251107121529_ve96i AU002D 2025-11-09T14:30:17.957Z 2025-11-15T15:01:09.848Z
8396047 8396047 20251107191716_S8YFJ AU002D 2025-11-09T14:07:05.442Z 2025-11-16T15:03:05.349Z
8395924 8395924 20251107184746_L5d7p AU002D 2025-11-09T14:06:32.540Z 2025-11-16T15:02:59.284Z
8395909 8395909 20251107184220_vAmoj AU002D 2025-11-09T14:06:28.843Z 2025-11-16T15:02:58.963Z
8395769 8395769 20251107180845_NF78H AU002D 2025-11-09T14:05:51.758Z 2025-11-16T15:02:45.470Z
8395558 8395558 20251107171255_kT325 AU002D 2025-11-09T14:04:53.919Z 2025-11-16T15:02:32.269Z
8395190 8395190 20251107144349_VNqiQ AU002D 2025-11-09T14:02:54.441Z 2025-11-16T15:02:03.640Z
8395171 8395171 20251107143752_32Rw7 AU002D 2025-11-09T14:02:42.833Z 2025-11-16T15:02:03.207Z
8394972 8394972 20251107130333_dP426 AU002D 2025-11-09T14:01:34.656Z 2025-11-16T15:01:54.671Z
8367106 8367106 20251102115523_3ck35 AU002D 2025-11-04T14:36:35.436Z 2025-11-10T15:10:39.345Z
8362923 8362923 20251102194049_K1CrJ AU002D 2025-11-04T14:12:47.415Z 2025-11-11T15:04:17.517Z
8362506 8362506 20251102191132_oEzhh AU002D 2025-11-04T14:11:38.884Z 2025-11-11T15:03:47.392Z
8362357 8362357 20251102190026_YY9q7 AU002D 2025-11-04T14:11:11.504Z 2025-11-11T15:03:36.779Z
8362198 8362198 20251102184751_LHP1U AU002D 2025-11-04T14:10:40.178Z 2025-11-11T15:03:28.064Z
8362187 8362187 20251102184648_z32NE AU002D 2025-11-04T14:10:38.164Z 2025-11-11T15:03:27.645Z
8362145 8362145 20251102184332_J72k5 AU002D 2025-11-04T14:10:33.222Z 2025-11-11T15:03:26.379Z
8361373 8361373 20251102172735_VI7Yy AU002D 2025-11-04T14:08:08.899Z 2025-11-11T15:02:52.385Z
8361153 8361153 20251102164250_4bQLH AU002D 2025-11-04T14:07:11.703Z 2025-11-11T15:02:45.412Z
8361030 8361030 20251102162536_2va43 AU002D 2025-11-04T14:06:45.177Z 2025-11-11T15:02:44.179Z
8361020 8361020 20251102162320_9moJu AU002D 2025-11-04T14:06:43.400Z 2025-11-11T15:02:43.924Z
8361011 8361011 20251102162308_VcaPv AU002D 2025-11-04T14:06:42.208Z 2025-11-11T15:02:43.792Z
8355869 8355869 20251101124808_SGJ2O AU002D 2025-11-03T14:38:30.104Z 2025-11-09T15:06:51.131Z
8348872 8348872 20251101165544_5uBG3 AU002D 2025-11-03T14:04:38.535Z 2025-11-10T15:03:48.514Z
8347934 8347934 20251101133750_0Yt9J AU002D 2025-11-03T14:00:42.619Z 2025-11-10T15:02:16.273Z
8332171 8332171 20251030152015_C5Lll AU002D 2025-11-02T14:14:04.487Z 2025-11-08T15:09:57.439Z
8317165 8317165 20251030191324_ZMaZn AU002D 2025-11-01T12:08:51.441Z 2025-11-08T15:11:31.654Z
8316562 8316562 20251030172719_IAlCC AU002D 2025-11-01T12:06:21.056Z 2025-11-08T15:10:34.607Z
8316152 8316152 20251030155759_abH5e AU002D 2025-11-01T12:04:29.321Z 2025-11-08T15:10:22.274Z
8296186 8296186 20251028191507_NoP7D AU002D 2025-10-30T12:45:59.077Z 2025-11-06T15:12:02.126Z
8290409 8290409 20251028200142_3ySHS AU002D 2025-10-30T12:16:55.824Z 2025-11-06T15:12:06.704Z
8290181 8290181 20251028194116_73U8I AU002D 2025-10-30T12:16:09.054Z 2025-10-30T12:16:09.054Z
8289777 8289777 20251028190805_Y0ObE AU002D 2025-10-30T12:14:41.714Z 2025-11-06T15:12:01.569Z
8289398 8289398 20251028184049_2sdGv AU002D 2025-10-30T12:13:25.505Z 2025-11-06T15:11:54.174Z
8289228 8289228 20251028182746_OCmcq AU002D 2025-10-30T12:12:58.861Z 2025-11-06T15:11:49.134Z
8289054 8289054 20251028181333_QLXRy AU002D 2025-10-30T12:12:18.275Z 2025-11-06T15:11:38.443Z
8289034 8289034 20251028181223_bY6P8 AU002D 2025-10-30T12:12:11.933Z 2025-11-06T15:11:38.324Z
8288554 8288554 20251028173655_4l4h2 AU002D 2025-10-30T12:10:37.198Z 2025-11-06T15:11:27.991Z
8288457 8288457 20251028172920_uR4ru AU002D 2025-10-30T12:10:23.342Z 2025-11-06T15:11:22.122Z
8288297 8288297 20251028171419_oxf2b AU002D 2025-10-30T12:09:50.244Z 2025-11-06T15:11:10.846Z
8288264 8288264 20251028171230_jc3AI AU002D 2025-10-30T12:09:45.661Z 2025-11-06T15:11:07.791Z
8287840 8287840 20251028162703_V9Jc3 AU002D 2025-10-30T12:08:28.089Z 2025-11-06T15:10:53.741Z
8287818 8287818 20251028162542_SdFZ8 AU002D 2025-10-30T12:08:26.156Z 2025-11-06T15:10:53.333Z
8287143 8287143 20251028153400_RAIlJ AU002D 2025-10-30T12:06:05.009Z 2025-11-06T15:10:33.559Z
8109026 8109026 20251015150029_ZFBXg AU002D 2025-10-17T12:03:27.508Z 2025-10-24T13:14:57.792Z
8108800 8108800 20251015123203_QRjrl AU002D 2025-10-17T12:02:29.786Z 2025-10-24T13:14:38.878Z
8108740 8108740 20251015114412_W3dKa AU002D 2025-10-17T12:01:58.544Z 2025-10-24T13:14:30.026Z
8100700 8100700 20251012125244_591q3 AU002D 2025-10-15T12:23:43.293Z 2025-10-21T13:08:19.762Z
8097256 8097256 20251013184310_OXKJX AU002D 2025-10-15T12:11:59.154Z 2025-10-22T13:09:27.030Z
8097215 8097215 20251013181655_9cgFa AU002D 2025-10-15T12:11:50.914Z 2025-10-22T13:09:26.057Z

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