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

>10,000 rows count all where station_code = "AU001F" 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
8683402 8683402 20251201184527_hz0zM AU001F 2025-12-04T14:24:06.819Z 2025-12-04T14:24:06.819Z
8683398 8683398 20251201183906_vszls AU001F 2025-12-04T14:24:05.980Z 2025-12-04T14:24:05.980Z
8673519 8673519 20251201194525_n2ix2 AU001F 2025-12-03T14:19:05.947Z 2025-12-04T14:24:23.701Z
8673423 8673423 20251201190103_TU3HB AU001F 2025-12-03T14:18:48.811Z 2025-12-04T14:24:16.448Z
8673353 8673353 20251201183806_m4X3y AU001F 2025-12-03T14:18:27.214Z 2025-12-04T14:24:05.435Z
8673337 8673337 20251201183142_MfCyC AU001F 2025-12-03T14:18:24.532Z 2025-12-04T14:24:04.567Z
8673101 8673101 20251201165547_7yTrs AU001F 2025-12-03T14:17:33.414Z 2025-12-04T14:23:36.607Z
8673014 8673014 20251201162033_5LntG AU001F 2025-12-03T14:17:07.364Z 2025-12-04T14:23:29.246Z
8672419 8672419 20251201142642_p8Nf8 AU001F 2025-12-03T14:15:33.545Z 2025-12-04T14:22:50.688Z
8672298 8672298 20251201141102_aNjlk AU001F 2025-12-03T14:15:14.808Z 2025-12-04T14:22:40.869Z
8671987 8671987 20251201133505_cXG8c AU001F 2025-12-03T14:14:21.273Z 2025-12-04T14:22:23.519Z
8667272 8667272 20251129193927_8j773 AU001F 2025-12-02T14:36:00.761Z 2025-12-04T14:38:45.190Z
8667101 8667101 20251129165214_Q7WpF AU001F 2025-12-02T14:34:41.363Z 2025-12-04T14:37:50.695Z
8666995 8666995 20251129141433_evj0B AU001F 2025-12-02T14:33:50.096Z 2025-12-04T14:37:06.353Z
8666727 8666727 20251130192637_0iK2m AU001F 2025-12-02T14:27:12.943Z 2025-12-04T14:31:34.440Z
8666702 8666702 20251130184736_ReZkE AU001F 2025-12-02T14:27:10.441Z 2025-12-04T14:31:12.807Z
8666690 8666690 20251130183915_wW088 AU001F 2025-12-02T14:27:09.080Z 2025-12-04T14:31:07.565Z
8666686 8666686 20251130183636_UG73L AU001F 2025-12-02T14:27:07.821Z 2025-12-04T14:31:06.523Z
8666651 8666651 20251130174551_d0EOS AU001F 2025-12-02T14:27:03.209Z 2025-12-04T14:30:49.455Z
8666641 8666641 20251130172352_J2NVQ AU001F 2025-12-02T14:27:02.023Z 2025-12-04T14:30:28.368Z
8666637 8666637 20251130170822_tozut AU001F 2025-12-02T14:27:01.603Z 2025-12-04T14:30:22.503Z
8666615 8666615 20251130161844_nrilV AU001F 2025-12-02T14:26:59.018Z 2025-12-04T14:30:11.025Z
8662855 8662855 20251130194103_Th3uz AU001F 2025-12-02T14:16:52.039Z 2025-12-04T14:31:38.973Z
8662645 8662645 20251130191740_poEtx AU001F 2025-12-02T14:16:12.026Z 2025-12-04T14:31:30.373Z
8662605 8662605 20251130191318_0RALS AU001F 2025-12-02T14:16:00.115Z 2025-12-04T14:31:28.892Z
8662604 8662604 20251130191300_8iLdM AU001F 2025-12-02T14:15:59.082Z 2025-12-04T14:31:28.765Z
8662303 8662303 20251130182950_ngmEt AU001F 2025-12-02T14:15:05.371Z 2025-12-02T14:27:05.720Z
8662176 8662176 20251130181231_lOzFx AU001F 2025-12-02T14:14:36.756Z 2025-12-04T14:30:56.966Z
8662133 8662133 20251130180257_S1kD2 AU001F 2025-12-02T14:14:28.023Z 2025-12-04T14:30:54.625Z
8662077 8662077 20251130175137_HH2X2 AU001F 2025-12-02T14:14:15.478Z 2025-12-04T14:30:51.858Z
8661849 8661849 20251130172351_SI8lN AU001F 2025-12-02T14:13:14.459Z 2025-12-04T14:30:28.245Z
8661009 8661009 20251130142622_S0K82 AU001F 2025-12-02T14:09:59.337Z 2025-12-04T14:29:23.697Z
8650220 8650220 20251129194158_gLPAu AU001F 2025-12-01T14:15:27.757Z 2025-12-04T14:38:45.819Z
8649365 8649365 20251129171533_wtc5W AU001F 2025-12-01T14:12:13.230Z 2025-12-04T14:37:54.662Z
8649169 8649169 20251129162952_WeHg7 AU001F 2025-12-01T14:11:17.107Z 2025-12-04T14:37:46.941Z
8649147 8649147 20251129162422_g9lIf AU001F 2025-12-01T14:11:12.235Z 2025-12-04T14:37:45.818Z
8648963 8648963 20251129153214_x5vnH AU001F 2025-12-01T14:10:10.629Z 2025-12-04T14:37:19.890Z
8648958 8648958 20251129153032_2KPYC AU001F 2025-12-01T14:10:06.763Z 2025-12-04T14:37:19.117Z
8644804 8644804 20251128195932_2w3lb AU001F 2025-11-30T14:22:40.229Z 2025-12-04T14:48:35.700Z
8644755 8644755 20251128195206_w7YFM AU001F 2025-11-30T14:22:22.877Z 2025-12-04T14:48:35.007Z
8644724 8644724 20251128194835_eg6Ta AU001F 2025-11-30T14:22:21.077Z 2025-12-04T14:48:34.560Z
8644697 8644697 20251128194611_ukzTj AU001F 2025-11-30T14:22:15.825Z 2025-12-04T14:48:33.825Z
8644560 8644560 20251128193244_55YuK AU001F 2025-11-30T14:22:06.292Z 2025-12-04T14:48:28.812Z
8644449 8644449 20251128192724_t5srG AU001F 2025-11-30T14:22:00.248Z 2025-12-04T14:48:26.941Z
8644388 8644388 20251128192439_bhoPm AU001F 2025-11-30T14:21:56.436Z 2025-12-04T14:48:25.950Z
8644365 8644365 20251128192347_lFNrt AU001F 2025-11-30T14:21:53.287Z 2025-12-04T14:48:25.563Z
8644359 8644359 20251128192331_ejhDW AU001F 2025-11-30T14:21:51.012Z 2025-12-04T14:48:25.417Z
8644308 8644308 20251128191934_nB8A6 AU001F 2025-11-30T14:21:37.502Z 2025-12-04T14:48:24.340Z
8644099 8644099 20251128185701_s316j AU001F 2025-11-30T14:21:20.127Z 2025-12-04T14:48:19.974Z
8644038 8644038 20251128185222_c3hnR AU001F 2025-11-30T14:21:15.106Z 2025-12-04T14:48:18.395Z
8644003 8644003 20251128184831_dJy3C AU001F 2025-11-30T14:21:01.962Z 2025-12-04T14:48:17.674Z
8643613 8643613 20251128180913_z6YIP AU001F 2025-11-30T14:20:16.251Z 2025-12-04T14:47:49.253Z
8643515 8643515 20251128180218_xpoXe AU001F 2025-11-30T14:20:06.916Z 2025-12-04T14:47:47.703Z
8641001 8641001 20251128131859_3vWyg AU001F 2025-11-30T14:13:37.410Z 2025-12-04T14:46:02.739Z
8631161 8631161 20251127182525_wDyam AU001F 2025-11-29T14:14:43.450Z 2025-12-04T14:54:27.609Z
8631115 8631115 20251127182103_fa1Sj AU001F 2025-11-29T14:14:35.474Z 2025-12-04T14:54:26.473Z
8630092 8630092 20251127141619_TZydC AU001F 2025-11-29T14:11:33.130Z 2025-12-04T14:53:28.011Z
8630049 8630049 20251127132501_zzumB AU001F 2025-11-29T14:11:16.242Z 2025-12-04T14:53:23.596Z
8622438 8622438 20251126192132_81AnK AU001F 2025-11-28T14:18:52.392Z 2025-12-04T15:02:40.010Z
8622325 8622325 20251126184745_4zYed AU001F 2025-11-28T14:18:23.808Z 2025-12-04T15:02:16.642Z
8622315 8622315 20251126184559_3iRFX AU001F 2025-11-28T14:18:22.613Z 2025-12-04T15:02:14.280Z
8622293 8622293 20251126183615_UJdv3 AU001F 2025-11-28T14:18:19.686Z 2025-12-04T15:02:10.313Z
8622277 8622277 20251126183418_89VJS AU001F 2025-11-28T14:18:18.271Z 2025-12-04T15:02:09.894Z
8622261 8622261 20251126182919_pf2qN AU001F 2025-11-28T14:18:15.779Z 2025-12-04T15:02:08.551Z
8622191 8622191 20251126181021_Uh8v2 AU001F 2025-11-28T14:18:05.753Z 2025-12-04T15:01:59.057Z
8622172 8622172 20251126180621_QxFen AU001F 2025-11-28T14:17:53.301Z 2025-12-04T15:01:53.586Z
8622120 8622120 20251126175339_0OdDL AU001F 2025-11-28T14:17:45.079Z 2025-12-04T15:01:52.551Z
8622028 8622028 20251126173232_18IsH AU001F 2025-11-28T14:17:31.296Z 2025-12-04T15:01:50.164Z
8622008 8622008 20251126172800_hj8SW AU001F 2025-11-28T14:17:17.918Z 2025-11-28T14:26:46.621Z
8621751 8621751 20251126162039_ZsDV2 AU001F 2025-11-28T14:16:30.770Z 2025-12-04T15:01:43.067Z
8620731 8620731 20251126132516_Pw3AA AU001F 2025-11-28T14:13:49.139Z 2025-12-04T15:01:26.101Z
8606677 8606677 20251125192258_IXarP AU001F 2025-11-27T14:10:51.705Z 2025-12-04T15:06:48.537Z
8605724 8605724 20251125162051_PaenC AU001F 2025-11-27T14:07:26.856Z 2025-12-04T15:05:37.718Z
8605721 8605721 20251125162051_OYmu3 AU001F 2025-11-27T14:07:26.503Z 2025-12-04T15:05:37.697Z
8595523 8595523 20251124163852_UBc68 AU001F 2025-11-26T14:11:32.170Z 2025-12-02T15:06:00.181Z
8595521 8595521 20251124163842_8SxhK AU001F 2025-11-26T14:11:31.760Z 2025-12-02T15:06:00.178Z
8594922 8594922 20251124131916_iMt4Q AU001F 2025-11-26T14:09:27.043Z 2025-12-02T15:05:39.466Z
8586151 8586151 20251123185333_xxTVA AU001F 2025-11-25T14:12:11.155Z 2025-12-02T15:10:44.498Z
8586052 8586052 20251123183628_o3wu8 AU001F 2025-11-25T14:11:42.644Z 2025-12-02T15:10:39.990Z
8586037 8586037 20251123183321_XRb4s AU001F 2025-11-25T14:11:40.304Z 2025-12-02T15:10:39.830Z
8585843 8585843 20251123180408_6B9xL AU001F 2025-11-25T14:11:07.619Z 2025-12-02T15:10:22.527Z
8577870 8577870 20251122190618_3GfnB AU001F 2025-11-24T14:10:03.713Z 2025-12-01T15:19:00.939Z
8577814 8577814 20251122185721_pXqZM AU001F 2025-11-24T14:09:44.395Z 2025-12-01T15:18:59.014Z
8577554 8577554 20251122182919_KNIsY AU001F 2025-11-24T14:09:02.189Z 2025-12-01T15:18:53.905Z
8577356 8577356 20251122175848_rh654 AU001F 2025-11-24T14:08:27.760Z 2025-12-01T15:18:48.111Z
8577047 8577047 20251122171151_Tp3h9 AU001F 2025-11-24T14:07:25.123Z 2025-12-01T15:18:42.750Z
8576880 8576880 20251122163029_NxHtJ AU001F 2025-11-24T14:06:53.667Z 2025-12-01T15:18:40.962Z
8576852 8576852 20251122162850_S36Ok AU001F 2025-11-24T14:06:51.063Z 2025-12-01T15:18:40.736Z
8576038 8576038 20251122140331_5OCwy AU001F 2025-11-24T14:04:41.802Z 2025-12-01T15:18:32.598Z
8575704 8575704 20251122131803_wOKS4 AU001F 2025-11-24T14:03:56.566Z 2025-12-01T15:18:30.059Z
8562843 8562843 20251121145215_EnEJs AU001F 2025-11-23T14:06:45.120Z 2025-11-30T15:03:33.286Z
8562541 8562541 20251121142524_FTOOQ AU001F 2025-11-23T14:05:57.403Z 2025-11-30T15:03:30.748Z
8562381 8562381 20251121141232_5ctQ9 AU001F 2025-11-23T14:05:30.512Z 2025-11-30T15:03:28.682Z
8562220 8562220 20251121134956_lzBwB AU001F 2025-11-23T14:04:58.667Z 2025-11-30T15:03:24.952Z
8562143 8562143 20251121134027_2fwVJ AU001F 2025-11-23T14:04:46.349Z 2025-11-30T15:03:23.801Z
8562003 8562003 20251121132247_Y3r9o AU001F 2025-11-23T14:04:20.653Z 2025-11-30T15:03:20.921Z
8561908 8561908 20251121131228_YXPnL AU001F 2025-11-23T14:04:05.475Z 2025-11-30T15:03:14.144Z
8525182 8525182 20251117154904_GYIpC AU001F 2025-11-20T14:23:31.477Z 2025-11-26T15:06:15.745Z
8520100 8520100 20251118184903_CQuZ5 AU001F 2025-11-20T14:08:58.429Z 2025-11-27T15:11:31.149Z
8519938 8519938 20251118182947_7YJwX AU001F 2025-11-20T14:08:26.853Z 2025-11-27T15:11:30.180Z

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