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

4,340 rows where station_code = "HR001D" 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
8655475 8655475 20251130040345_YTGLb HR001D 2025-12-01T14:26:58.940Z 2025-12-05T14:44:34.212Z
8654688 8654688 20251130032617_iUmGo HR001D 2025-12-01T14:25:44.702Z 2025-12-05T14:44:20.686Z
8653891 8653891 20251130024659_81l0Q HR001D 2025-12-01T14:24:26.500Z 2025-12-05T14:43:42.364Z
8653025 8653025 20251130015119_2pQA4 HR001D 2025-12-01T14:22:39.547Z 2025-12-05T14:42:59.376Z
8652931 8652931 20251130014602_XhrNG HR001D 2025-12-01T14:22:33.264Z 2025-12-05T14:42:57.920Z
8652633 8652633 20251130012510_ymhQW HR001D 2025-12-01T14:21:53.477Z 2025-12-05T14:42:49.019Z
8652471 8652471 20251130011148_Swg3d HR001D 2025-12-01T14:21:28.538Z 2025-12-05T14:42:45.265Z
8651830 8651830 20251130002500_yPa8K HR001D 2025-12-01T14:20:06.142Z 2025-12-05T14:42:07.522Z
8651768 8651768 20251130001736_BCMwS HR001D 2025-12-01T14:19:51.332Z 2025-12-05T14:42:05.584Z
8651376 8651376 20251129233423_sNn4P HR001D 2025-12-01T14:18:55.124Z 2025-12-05T14:41:56.617Z
8650815 8650815 20251129213419_Q7w1z HR001D 2025-12-01T14:17:13.987Z 2025-12-05T14:41:19.230Z
8650686 8650686 20251129210706_W9Asm HR001D 2025-12-01T14:16:54.272Z 2025-12-05T14:41:14.441Z
8650599 8650599 20251129205004_x3sKA HR001D 2025-12-01T14:16:34.976Z 2025-12-05T14:41:11.980Z
8650293 8650293 20251129194922_RiA05 HR001D 2025-12-01T14:15:44.173Z 2025-12-05T14:41:02.828Z
8649165 8649165 20251129162846_ZCpcB HR001D 2025-12-01T14:11:16.077Z 2025-12-05T14:39:51.211Z
8646737 8646737 20251129024637_FWslF HR001D 2025-11-30T14:26:44.742Z 2025-12-05T14:51:52.819Z
8646173 8646173 20251129011945_GdVmT HR001D 2025-11-30T14:25:20.769Z 2025-12-05T14:51:34.929Z
8646097 8646097 20251129010454_dPoYO HR001D 2025-11-30T14:25:11.336Z 2025-12-05T14:51:32.965Z
8644452 8644452 20251128192736_02Za2 HR001D 2025-11-30T14:22:00.561Z 2025-12-05T14:50:22.322Z
8644314 8644314 20251128191937_GgZHf HR001D 2025-11-30T14:21:38.226Z 2025-12-05T14:50:20.065Z
8635047 8635047 20251128013646_80YV6 HR001D 2025-11-29T14:22:35.056Z 2025-12-05T14:58:28.352Z
8634372 8634372 20251128004232_BCnBd HR001D 2025-11-29T14:21:15.684Z 2025-12-05T14:58:19.729Z
8634363 8634363 20251128004157_eF2qf HR001D 2025-11-29T14:21:15.048Z 2025-12-05T14:58:19.612Z
8633733 8633733 20251127235034_IUfww HR001D 2025-11-29T14:20:09.037Z 2025-12-05T14:57:56.150Z
8633494 8633494 20251127232406_EpVeW HR001D 2025-11-29T14:19:48.105Z 2025-12-05T14:57:43.665Z
8633491 8633491 20251127232405_TZGDc HR001D 2025-11-29T14:19:47.897Z 2025-12-05T14:57:43.510Z
8633455 8633455 20251127231845_ab2PO HR001D 2025-11-29T14:19:44.076Z 2025-12-05T14:57:40.530Z
8632777 8632777 20251127215338_j1E6z HR001D 2025-11-29T14:18:21.799Z 2025-12-05T14:56:41.608Z
8623299 8623299 20251126235131_FL8Xp HR001D 2025-11-28T14:21:28.944Z 2025-12-05T15:03:42.005Z
8622945 8622945 20251126221219_mXBQK HR001D 2025-11-28T14:20:21.851Z 2025-12-05T15:03:20.371Z
8615752 8615752 20251126051643_ec0Xz HR001D 2025-11-27T14:30:07.946Z 2025-12-04T15:11:31.851Z
8585660 8585660 20251123172340_6EO3J HR001D 2025-11-25T14:10:30.345Z 2025-12-02T15:10:07.625Z
8585499 8585499 20251123163552_uvAhv HR001D 2025-11-25T14:09:53.785Z 2025-12-02T15:09:59.142Z
8579707 8579707 20251123005350_7ruky HR001D 2025-11-24T14:15:00.721Z 2025-12-01T15:20:57.458Z
8579519 8579519 20251123000541_zw47u HR001D 2025-11-24T14:14:31.869Z 2025-12-01T15:20:35.634Z
8524984 8524984 20251119044748_e6BTk HR001D 2025-11-20T14:21:52.036Z 2025-11-27T15:13:09.771Z
8523632 8523632 20251119022833_32Jjr HR001D 2025-11-20T14:18:54.123Z 2025-11-27T15:12:24.293Z
8521016 8521016 20251118202442_lXaub HR001D 2025-11-20T14:11:24.027Z 2025-11-27T15:11:36.778Z
8520857 8520857 20251118201023_R3fu3 HR001D 2025-11-20T14:11:09.669Z 2025-11-27T15:11:35.988Z
8520083 8520083 20251118184428_xnhWX HR001D 2025-11-20T14:08:55.115Z 2025-11-27T15:11:30.955Z
8442347 8442347 20251110195329_kAy8c HR001D 2025-11-13T14:43:18.970Z 2025-11-19T15:14:18.514Z
8442293 8442293 20251110175124_xeAxm HR001D 2025-11-13T14:42:23.622Z 2025-11-19T15:13:29.922Z
8439851 8439851 20251112044533_2iuko HR001D 2025-11-13T14:27:25.729Z 2025-11-13T14:27:25.729Z
8438424 8438424 20251112015525_jed15 HR001D 2025-11-13T14:23:46.010Z 2025-11-20T15:24:33.388Z
8438402 8438402 20251112015212_NN5la HR001D 2025-11-13T14:23:42.765Z 2025-11-20T15:24:31.805Z
8437547 8437547 20251112001712_vTAwO HR001D 2025-11-13T14:21:17.644Z 2025-11-20T15:23:42.502Z
8437482 8437482 20251112000854_b482q HR001D 2025-11-13T14:21:10.429Z 2025-11-20T15:23:37.168Z
8436838 8436838 20251111223956_7JT53 HR001D 2025-11-13T14:19:25.166Z 2025-11-20T15:23:01.847Z
8436804 8436804 20251111223613_Kq1KF HR001D 2025-11-13T14:19:08.417Z 2025-11-20T15:23:01.208Z
8435998 8435998 20251111203832_yoprY HR001D 2025-11-13T14:16:55.595Z 2025-11-20T15:22:38.700Z
8435684 8435684 20251111195932_vDo0D HR001D 2025-11-13T14:16:11.194Z 2025-11-20T15:22:27.730Z
8435493 8435493 20251111194144_ebneB HR001D 2025-11-13T14:15:38.133Z 2025-11-20T15:22:20.765Z
8435463 8435463 20251111194012_02SgB HR001D 2025-11-13T14:15:36.267Z 2025-11-20T15:22:18.665Z
8435283 8435283 20251111192404_mClcn HR001D 2025-11-13T14:15:05.354Z 2025-11-20T15:22:11.078Z
8434257 8434257 20251111180254_Ydf6L HR001D 2025-11-13T14:12:25.321Z 2025-11-20T15:21:31.485Z
8433838 8433838 20251111172528_Yyxqt HR001D 2025-11-13T14:11:11.825Z 2025-11-20T15:21:09.712Z
8433833 8433833 20251111172507_qH3Oz HR001D 2025-11-13T14:11:11.224Z 2025-11-20T15:21:09.650Z
8427260 8427260 20251111042213_NswEe HR001D 2025-11-12T14:27:32.380Z 2025-11-19T15:17:48.764Z
8424386 8424386 20251111001415_alVIw HR001D 2025-11-12T14:20:02.360Z 2025-11-19T15:16:13.339Z
8424075 8424075 20251110234835_3RwtO HR001D 2025-11-12T14:19:22.752Z 2025-11-19T15:16:05.914Z
8423499 8423499 20251110231253_cvTjB HR001D 2025-11-12T14:18:24.631Z 2025-11-19T15:15:53.926Z
8423003 8423003 20251110224531_B4aZZ HR001D 2025-11-12T14:17:34.491Z 2025-11-19T15:15:37.196Z
8420341 8420341 20251110185309_jLNCC HR001D 2025-11-12T14:10:25.262Z 2025-11-19T15:13:52.115Z
8414525 8414525 20251110025808_ZNgDQ HR001D 2025-11-11T14:20:54.618Z 2025-11-18T15:21:08.535Z
8414225 8414225 20251110015813_yDrxf HR001D 2025-11-11T14:19:59.831Z 2025-11-18T15:20:48.018Z
8414219 8414219 20251110015811_fYLqQ HR001D 2025-11-11T14:19:58.903Z 2025-11-18T15:20:47.961Z
8414147 8414147 20251110014618_1tnEn HR001D 2025-11-11T14:19:36.813Z 2025-11-18T15:20:42.377Z
8414144 8414144 20251110014618_Z9aIH HR001D 2025-11-11T14:19:36.695Z 2025-11-18T15:20:42.372Z
8414093 8414093 20251110013832_2Glaz HR001D 2025-11-11T14:19:29.387Z 2025-11-18T15:20:37.569Z
8413758 8413758 20251110003846_6wK2p HR001D 2025-11-11T14:18:16.854Z 2025-11-18T15:20:24.134Z
8413740 8413740 20251110003629_n3sxV HR001D 2025-11-11T14:18:15.177Z 2025-11-18T15:20:23.993Z
8413617 8413617 20251110000403_sGulW HR001D 2025-11-11T14:17:57.524Z 2025-11-18T15:20:22.947Z
8413104 8413104 20251109220959_NBjcC HR001D 2025-11-11T14:16:12.930Z 2025-11-18T15:20:18.266Z
8412637 8412637 20251109204032_LWWeJ HR001D 2025-11-11T14:14:42.433Z 2025-11-18T15:20:14.273Z
8412432 8412432 20251109202104_b2OWM HR001D 2025-11-11T14:14:05.544Z 2025-11-18T15:20:11.161Z
8411270 8411270 20251109183009_pjQ3E HR001D 2025-11-11T14:10:21.240Z 2025-11-18T15:19:31.712Z
8410942 8410942 20251109175113_3VJkb HR001D 2025-11-11T14:09:12.582Z 2025-11-18T15:19:17.031Z
8410908 8410908 20251109174812_xwIw0 HR001D 2025-11-11T14:09:05.876Z 2025-11-18T15:19:16.273Z
8405019 8405019 20251109025028_BQsgn HR001D 2025-11-10T14:13:18.637Z 2025-11-17T14:58:54.342Z
8403853 8403853 20251109002819_kQLP6 HR001D 2025-11-10T14:10:16.438Z 2025-11-17T14:58:39.991Z
8403080 8403080 20251108222226_QQ5cc HR001D 2025-11-10T14:08:16.979Z 2025-11-17T14:58:31.517Z
8402111 8402111 20251108182916_FXsQE HR001D 2025-11-10T14:05:36.689Z 2025-11-17T14:58:08.605Z
8398006 8398006 20251108031759_0qZpl HR001D 2025-11-09T14:13:52.004Z 2025-11-16T15:04:32.845Z
8397989 8397989 20251108031524_DQ3JC HR001D 2025-11-09T14:13:50.593Z 2025-11-16T15:04:32.682Z
8396440 8396440 20251107205412_I50V3 HR001D 2025-11-09T14:08:37.774Z 2025-11-16T15:03:31.456Z
8396365 8396365 20251107203140_2MJds HR001D 2025-11-09T14:08:15.583Z 2025-11-16T15:03:28.549Z
8395959 8395959 20251107185538_nXeKk HR001D 2025-11-09T14:06:41.287Z 2025-11-16T15:03:01.265Z
8391971 8391971 20251107041256_k2Snh HR001D 2025-11-08T14:16:44.885Z 2025-11-15T15:00:40.771Z
8390997 8390997 20251107015131_9h5Dg HR001D 2025-11-08T14:13:15.177Z 2025-11-15T15:00:16.540Z
8390628 8390628 20251107005838_2UlID HR001D 2025-11-08T14:11:48.915Z 2025-11-15T15:00:07.796Z
8390280 8390280 20251107000159_ifrB3 HR001D 2025-11-08T14:10:17.587Z 2025-11-15T14:59:58.533Z
8390079 8390079 20251106232521_d2hqn HR001D 2025-11-08T14:09:29.403Z 2025-11-15T14:59:53.422Z
8390048 8390048 20251106232141_Ki3ik HR001D 2025-11-08T14:09:23.344Z 2025-11-15T14:59:52.585Z
8390045 8390045 20251106232059_Qy2ij HR001D 2025-11-08T14:09:22.829Z 2025-11-15T14:59:52.561Z
8386474 8386474 20251106043152_lQCxI HR001D 2025-11-07T14:11:21.256Z 2025-11-14T15:08:43.121Z
8386183 8386183 20251106030114_wCDk6 HR001D 2025-11-07T14:10:03.242Z 2025-11-14T15:08:38.028Z
8386070 8386070 20251106022611_kmWFI HR001D 2025-11-07T14:09:27.483Z 2025-11-14T15:08:34.173Z
8385981 8385981 20251106021017_wYxBU HR001D 2025-11-07T14:09:04.626Z 2025-11-14T15:08:31.329Z
8385815 8385815 20251106013344_VXZaB HR001D 2025-11-07T14:08:16.409Z 2025-11-14T15:08:25.140Z
8385774 8385774 20251106012413_7gDnz HR001D 2025-11-07T14:08:08.479Z 2025-11-14T15:08:22.364Z

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