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,583 rows where station_code = "HR002G" 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
8667560 8667560 20251130021525_khy8B HR002G 2025-12-02T14:38:53.809Z 2025-12-05T14:43:31.165Z
8667557 8667557 20251130021157_dI5d2 HR002G 2025-12-02T14:38:52.096Z 2025-12-05T14:43:29.786Z
8667436 8667436 20251130012049_YzlG6 HR002G 2025-12-02T14:38:08.818Z 2025-12-05T14:42:47.666Z
8667334 8667334 20251129235521_7hcgm HR002G 2025-12-02T14:37:18.035Z 2025-12-05T14:42:00.318Z
8667326 8667326 20251129234048_EKqiR HR002G 2025-12-02T14:37:13.682Z 2025-12-05T14:41:57.461Z
8656699 8656699 20251130050621_Y8vey HR002G 2025-12-01T14:28:54.704Z 2025-12-05T14:45:20.086Z
8656486 8656486 20251130045702_T0rcY HR002G 2025-12-01T14:28:41.082Z 2025-12-05T14:45:16.763Z
8656421 8656421 20251130045549_XFVxM HR002G 2025-12-01T14:28:38.073Z 2025-12-05T14:45:15.943Z
8656398 8656398 20251130045311_ZZA3M HR002G 2025-12-01T14:28:35.663Z 2025-12-01T14:28:35.663Z
8656162 8656162 20251130044103_Q9JmI HR002G 2025-12-01T14:28:07.446Z 2025-12-05T14:44:47.109Z
8656159 8656159 20251130044056_YDzdO HR002G 2025-12-01T14:28:07.196Z 2025-12-05T14:44:46.991Z
8656119 8656119 20251130043854_MmTP2 HR002G 2025-12-01T14:28:05.063Z 2025-12-05T14:44:46.332Z
8655802 8655802 20251130041931_j3jiN HR002G 2025-12-01T14:27:30.667Z 2025-12-05T14:44:39.343Z
8655799 8655799 20251130041931_vtmWI HR002G 2025-12-01T14:27:30.571Z 2025-12-05T14:44:39.303Z
8655711 8655711 20251130041229_WLAFb HR002G 2025-12-01T14:27:22.065Z 2025-12-01T14:27:22.065Z
8655616 8655616 20251130040916_KXtX9 HR002G 2025-12-01T14:27:17.819Z 2025-12-01T14:27:17.819Z
8655554 8655554 20251130040707_9RUtx HR002G 2025-12-01T14:27:03.220Z 2025-12-05T14:44:35.288Z
8655383 8655383 20251130040009_uPdEU HR002G 2025-12-01T14:26:52.376Z 2025-12-05T14:44:33.094Z
8655353 8655353 20251130035742_RFOAk HR002G 2025-12-01T14:26:49.728Z 2025-12-05T14:44:32.731Z
8655345 8655345 20251130035611_08zGd HR002G 2025-12-01T14:26:49.039Z 2025-12-05T14:44:32.430Z
8654857 8654857 20251130033609_3fd3r HR002G 2025-12-01T14:26:07.250Z 2025-12-01T14:26:07.250Z
8654748 8654748 20251130033054_nn3NG HR002G 2025-12-01T14:25:57.782Z 2025-12-05T14:44:22.825Z
8654625 8654625 20251130032312_suIRq HR002G 2025-12-01T14:25:38.405Z 2025-12-05T14:44:16.003Z
8654326 8654326 20251130031105_pa9tC HR002G 2025-12-01T14:25:09.597Z 2025-12-05T14:43:53.905Z
8654258 8654258 20251130030545_jxWYn HR002G 2025-12-01T14:25:02.513Z 2025-12-05T14:43:52.111Z
8654106 8654106 20251130025914_I9qRf HR002G 2025-12-01T14:24:52.224Z 2025-12-05T14:43:47.176Z
8653808 8653808 20251130024209_ELUGF HR002G 2025-12-01T14:24:17.536Z 2025-12-05T14:43:40.344Z
8653678 8653678 20251130023338_QV98q HR002G 2025-12-01T14:23:55.293Z 2025-12-05T14:43:37.464Z
8653521 8653521 20251130022234_7JZY0 HR002G 2025-12-01T14:23:38.744Z 2025-12-05T14:43:33.981Z
8653506 8653506 20251130022140_FgfhX HR002G 2025-12-01T14:23:37.394Z 2025-12-05T14:43:33.439Z
8653495 8653495 20251130022040_HEVa2 HR002G 2025-12-01T14:23:35.810Z 2025-12-05T14:43:33.029Z
8653469 8653469 20251130021742_H5AkD HR002G 2025-12-01T14:23:33.123Z 2025-12-05T14:43:32.250Z
8653319 8653319 20251130021012_eLTAz HR002G 2025-12-01T14:23:13.575Z 2025-12-05T14:43:28.846Z
8653083 8653083 20251130015540_23pmL HR002G 2025-12-01T14:22:45.620Z 2025-12-05T14:43:03.086Z
8653058 8653058 20251130015331_ZgSJS HR002G 2025-12-01T14:22:43.194Z 2025-12-05T14:43:02.199Z
8652881 8652881 20251130014249_Nvirt HR002G 2025-12-01T14:22:27.921Z 2025-12-05T14:42:56.588Z
8652870 8652870 20251130014154_2CnJC HR002G 2025-12-01T14:22:17.380Z 2025-12-05T14:42:55.774Z
8652846 8652846 20251130013800_y6abb HR002G 2025-12-01T14:22:14.174Z 2025-12-05T14:42:54.629Z
8652515 8652515 20251130011404_N3oCG HR002G 2025-12-01T14:21:36.692Z 2025-12-05T14:42:46.382Z
8652318 8652318 20251130010250_ipgRI HR002G 2025-12-01T14:21:15.597Z 2025-12-05T14:42:42.649Z
8652271 8652271 20251130010112_I32Qg HR002G 2025-12-01T14:21:05.407Z 2025-12-05T14:42:41.261Z
8652147 8652147 20251130005049_ZF4QK HR002G 2025-12-01T14:20:48.960Z 2025-12-05T14:42:27.004Z
8652077 8652077 20251130004455_K9dGS HR002G 2025-12-01T14:20:40.848Z 2025-12-05T14:42:16.664Z
8651921 8651921 20251130003446_a46HN HR002G 2025-12-01T14:20:16.578Z 2025-12-05T14:42:11.523Z
8651892 8651892 20251130003218_kG2RQ HR002G 2025-12-01T14:20:13.148Z 2025-12-05T14:42:10.800Z
8651870 8651870 20251130002949_9J8OL HR002G 2025-12-01T14:20:09.693Z 2025-12-05T14:42:10.038Z
8651832 8651832 20251130002504_xWDNC HR002G 2025-12-01T14:20:06.550Z 2025-12-05T14:42:07.578Z
8651612 8651612 20251130000152_Kqjz7 HR002G 2025-12-01T14:19:27.835Z 2025-12-05T14:42:01.929Z
8651384 8651384 20251129233509_62LYH HR002G 2025-12-01T14:18:56.323Z 2025-12-05T14:41:56.772Z
8651341 8651341 20251129232951_ym93o HR002G 2025-12-01T14:18:49.713Z 2025-12-05T14:41:55.689Z
8651327 8651327 20251129232718_bXlon HR002G 2025-12-01T14:18:46.056Z 2025-12-05T14:41:55.157Z
8651310 8651310 20251129232515_6Jap2 HR002G 2025-12-01T14:18:43.719Z 2025-12-05T14:41:54.392Z
8651293 8651293 20251129232157_pGbgW HR002G 2025-12-01T14:18:41.540Z 2025-12-05T14:41:53.954Z
8651269 8651269 20251129231609_OuuIm HR002G 2025-12-01T14:18:31.202Z 2025-12-05T14:41:53.417Z
8651238 8651238 20251129231050_n9hS2 HR002G 2025-12-01T14:18:27.720Z 2025-12-05T14:41:52.674Z
8651187 8651187 20251129230207_iiyyu HR002G 2025-12-01T14:18:19.674Z 2025-12-05T14:41:51.378Z
8650996 8650996 20251129222259_ZqHAW HR002G 2025-12-01T14:17:45.201Z 2025-12-05T14:41:30.533Z
8650756 8650756 20251129212200_8iUA2 HR002G 2025-12-01T14:17:05.928Z 2025-12-05T14:41:16.481Z
8650657 8650657 20251129210125_0NzN8 HR002G 2025-12-01T14:16:50.032Z 2025-12-05T14:41:13.655Z
8650575 8650575 20251129204331_TQw0d HR002G 2025-12-01T14:16:31.935Z 2025-12-05T14:41:11.239Z
8650033 8650033 20251129191004_8ZVM4 HR002G 2025-12-01T14:14:45.094Z 2025-12-05T14:40:52.612Z
8649600 8649600 20251129175445_n33d7 HR002G 2025-12-01T14:13:14.348Z 2025-12-05T14:40:14.351Z
8647628 8647628 20251129045856_xVJ0J HR002G 2025-11-30T14:28:40.211Z 2025-12-05T14:52:44.374Z
8647577 8647577 20251129045223_K5TZN HR002G 2025-11-30T14:28:36.669Z 2025-12-05T14:52:43.300Z
8647573 8647573 20251129045222_QUwDr HR002G 2025-11-30T14:28:36.519Z 2025-12-05T14:52:43.213Z
8647232 8647232 20251129040923_P1icX HR002G 2025-11-30T14:27:52.442Z 2025-12-05T14:52:35.756Z
8647139 8647139 20251129035004_IrD7o HR002G 2025-11-30T14:27:44.599Z 2025-12-05T14:52:33.928Z
8647064 8647064 20251129033451_GoSeb HR002G 2025-11-30T14:27:23.627Z 2025-12-05T14:52:32.122Z
8647054 8647054 20251129033344_Na9RX HR002G 2025-11-30T14:27:22.922Z 2025-12-05T14:52:31.945Z
8646973 8646973 20251129032134_5DxW1 HR002G 2025-11-30T14:27:12.554Z 2025-12-05T14:52:09.284Z
8646964 8646964 20251129032054_x4cDQ HR002G 2025-11-30T14:27:11.745Z 2025-12-05T14:52:08.166Z
8646949 8646949 20251129031809_HzLS6 HR002G 2025-11-30T14:27:10.318Z 2025-12-05T14:52:04.159Z
8646812 8646812 20251129025924_zwC0u HR002G 2025-11-30T14:26:59.526Z 2025-12-05T14:51:54.736Z
8646776 8646776 20251129025241_WoRRK HR002G 2025-11-30T14:26:56.734Z 2025-12-05T14:51:53.864Z
8646617 8646617 20251129023116_n79g9 HR002G 2025-11-30T14:26:23.341Z 2025-12-05T14:51:45.583Z
8646594 8646594 20251129022647_hLjr2 HR002G 2025-11-30T14:26:14.552Z 2025-12-05T14:51:45.160Z
8646541 8646541 20251129021955_5tNpU HR002G 2025-11-30T14:26:08.578Z 2025-12-05T14:51:44.112Z
8646460 8646460 20251129020841_fSjOV HR002G 2025-11-30T14:26:01.495Z 2025-12-05T14:51:42.550Z
8646440 8646440 20251129020643_Qu1uP HR002G 2025-11-30T14:25:59.461Z 2025-12-05T14:51:42.094Z
8646431 8646431 20251129020454_dtZfU HR002G 2025-11-30T14:25:58.742Z 2025-12-05T14:51:41.915Z
8646414 8646414 20251129020338_YZDoB HR002G 2025-11-30T14:25:57.590Z 2025-12-05T14:51:41.479Z
8646213 8646213 20251129012511_QTnx5 HR002G 2025-11-30T14:25:25.554Z 2025-12-05T14:51:36.019Z
8646129 8646129 20251129011025_544B2 HR002G 2025-11-30T14:25:15.004Z 2025-12-05T14:51:33.762Z
8646100 8646100 20251129010525_2xZg1 HR002G 2025-11-30T14:25:11.614Z 2025-12-05T14:51:32.997Z
8646056 8646056 20251129005628_XWz8T HR002G 2025-11-30T14:25:07.058Z 2025-12-05T14:51:31.848Z
8646034 8646034 20251129005328_ZjZ9T HR002G 2025-11-30T14:25:05.707Z 2025-12-05T14:51:31.500Z
8646016 8646016 20251129004739_X832W HR002G 2025-11-30T14:25:04.297Z 2025-12-05T14:51:31.103Z
8645969 8645969 20251129003644_20mM2 HR002G 2025-11-30T14:25:00.245Z 2025-12-05T14:51:30.065Z
8645961 8645961 20251129003528_INyEN HR002G 2025-11-30T14:24:59.352Z 2025-12-05T14:51:29.862Z
8645942 8645942 20251129003335_OSTbB HR002G 2025-11-30T14:24:57.881Z 2025-12-05T14:51:29.292Z
8645887 8645887 20251129001545_mDYm7 HR002G 2025-11-30T14:24:42.840Z 2025-12-05T14:51:27.623Z
8645836 8645836 20251129000102_ZVAI8 HR002G 2025-11-30T14:24:36.708Z 2025-12-05T14:51:22.469Z
8645801 8645801 20251128235133_kQrLf HR002G 2025-11-30T14:24:33.205Z 2025-12-05T14:51:13.463Z
8645781 8645781 20251128234925_N08fm HR002G 2025-11-30T14:24:31.397Z 2025-12-05T14:51:12.628Z
8645767 8645767 20251128234610_3VmKB HR002G 2025-11-30T14:24:30.258Z 2025-12-05T14:51:11.783Z
8645731 8645731 20251128234116_WaUo8 HR002G 2025-11-30T14:24:27.779Z 2025-12-05T14:51:10.390Z
8645711 8645711 20251128233442_WVDaK HR002G 2025-11-30T14:24:25.755Z 2025-12-05T14:51:07.783Z
8645638 8645638 20251128231405_MH1tw HR002G 2025-11-30T14:24:19.348Z 2025-12-05T14:50:59.643Z
8645620 8645620 20251128230654_pJuw2 HR002G 2025-11-30T14:24:17.439Z 2025-12-05T14:50:58.452Z
8645595 8645595 20251128230235_lyvBa HR002G 2025-11-30T14:24:15.231Z 2025-12-05T14:50:53.074Z

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