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 = "HR001E" 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
8667942 8667942 20251130051958_mHvCM HR001E 2025-12-02T14:41:21.411Z 2025-12-06T14:49:43.321Z
8667313 8667313 20251129232806_CjlY3 HR001E 2025-12-02T14:37:00.264Z 2025-12-06T14:46:44.047Z
8667125 8667125 20251129172719_w2oAz HR001E 2025-12-02T14:35:05.799Z 2025-12-06T14:45:22.521Z
8665866 8665866 20251201040332_Mr2Wc HR001E 2025-12-02T14:24:36.589Z 2025-12-06T14:42:05.373Z
8665858 8665858 20251201040312_Vf3RK HR001E 2025-12-02T14:24:35.893Z 2025-12-06T14:42:05.172Z
8665166 8665166 20251201024038_buG3Y HR001E 2025-12-02T14:23:03.368Z 2025-12-06T14:41:28.518Z
8665146 8665146 20251201023612_jmN0p HR001E 2025-12-02T14:23:00.889Z 2025-12-06T14:41:28.003Z
8664900 8664900 20251201020115_CbIPf HR001E 2025-12-02T14:22:25.065Z 2025-12-06T14:41:02.488Z
8664749 8664749 20251201013426_WzEXZ HR001E 2025-12-02T14:22:01.296Z 2025-12-06T14:40:56.430Z
8656838 8656838 20251130051335_cE2IE HR001E 2025-12-01T14:29:14.866Z 2025-12-06T14:49:42.265Z
8656825 8656825 20251130051240_BH2BX HR001E 2025-12-01T14:29:04.155Z 2025-12-06T14:49:42.062Z
8656420 8656420 20251130045548_Vv42h HR001E 2025-12-01T14:28:37.830Z 2025-12-06T14:49:34.635Z
8656344 8656344 20251130045107_pBvD7 HR001E 2025-12-01T14:28:21.842Z 2025-12-06T14:49:33.797Z
8656231 8656231 20251130044503_aveWC HR001E 2025-12-01T14:28:12.507Z 2025-12-06T14:49:32.536Z
8656034 8656034 20251130043129_1ySYT HR001E 2025-12-01T14:27:57.537Z 2025-12-06T14:49:29.894Z
8655885 8655885 20251130042245_vJVxY HR001E 2025-12-01T14:27:35.658Z 2025-12-06T14:49:28.842Z
8655572 8655572 20251130040738_aXped HR001E 2025-12-01T14:27:07.533Z 2025-12-06T14:49:25.417Z
8654894 8654894 20251130033816_iQdvv HR001E 2025-12-01T14:26:09.817Z 2025-12-06T14:48:49.909Z
8654755 8654755 20251130033149_3hBek HR001E 2025-12-01T14:25:58.309Z 2025-12-06T14:48:47.921Z
8654098 8654098 20251130025854_7JrDT HR001E 2025-12-01T14:24:51.499Z 2025-12-06T14:48:37.488Z
8653880 8653880 20251130024549_2iDki HR001E 2025-12-01T14:24:25.207Z 2025-12-06T14:48:33.983Z
8653672 8653672 20251130023338_D1wZ5 HR001E 2025-12-01T14:23:54.867Z 2025-12-06T14:48:26.240Z
8653631 8653631 20251130023204_XQNJs HR001E 2025-12-01T14:23:52.387Z 2025-12-01T14:35:22.380Z
8653498 8653498 20251130022112_zXFo7 HR001E 2025-12-01T14:23:36.584Z 2025-12-06T14:48:03.855Z
8653496 8653496 20251130022057_0f2tj HR001E 2025-12-01T14:23:36.221Z 2025-12-06T14:48:03.557Z
8653427 8653427 20251130021528_Hbvod HR001E 2025-12-01T14:23:29.758Z 2025-12-06T14:47:58.028Z
8653375 8653375 20251130021315_zboic HR001E 2025-12-01T14:23:18.685Z 2025-12-06T14:47:56.770Z
8653329 8653329 20251130021047_Mg5iU HR001E 2025-12-01T14:23:15.102Z 2025-12-06T14:47:55.920Z
8653325 8653325 20251130021021_vOjjR HR001E 2025-12-01T14:23:14.364Z 2025-12-06T14:47:55.761Z
8653236 8653236 20251130020357_QvGqk HR001E 2025-12-01T14:23:06.688Z 2025-12-06T14:47:51.915Z
8652992 8652992 20251130014929_519g6 HR001E 2025-12-01T14:22:37.296Z 2025-12-06T14:47:47.428Z
8652876 8652876 20251130014240_c4YxS HR001E 2025-12-01T14:22:26.811Z 2025-12-06T14:47:44.133Z
8651966 8651966 20251130003758_oFkWa HR001E 2025-12-01T14:20:21.216Z 2025-12-06T14:46:56.943Z
8651960 8651960 20251130003735_iGuZS HR001E 2025-12-01T14:20:20.504Z 2025-12-06T14:46:56.833Z
8651911 8651911 20251130003403_N654A HR001E 2025-12-01T14:20:15.459Z 2025-12-06T14:46:56.149Z
8651819 8651819 20251130002346_f1F9W HR001E 2025-12-01T14:20:00.256Z 2025-12-06T14:46:54.677Z
8651814 8651814 20251130002210_U2Y1F HR001E 2025-12-01T14:19:59.074Z 2025-12-06T14:46:54.437Z
8651505 8651505 20251129235025_gqm3P HR001E 2025-12-01T14:19:14.052Z 2025-12-06T14:46:47.598Z
8651410 8651410 20251129233936_hrpPT HR001E 2025-12-01T14:19:00.821Z 2025-12-06T14:46:45.728Z
8651408 8651408 20251129233921_4NBjJ HR001E 2025-12-01T14:19:00.242Z 2025-12-06T14:46:45.674Z
8651202 8651202 20251129230450_WLLQG HR001E 2025-12-01T14:18:22.751Z 2025-12-06T14:46:41.802Z
8651194 8651194 20251129230330_E4d3e HR001E 2025-12-01T14:18:20.982Z 2025-12-06T14:46:41.746Z
8651010 8651010 20251129222346_gNclx HR001E 2025-12-01T14:17:51.020Z 2025-12-06T14:46:38.264Z
8650972 8650972 20251129221829_WWA9H HR001E 2025-12-01T14:17:39.520Z 2025-12-06T14:46:37.368Z
8650919 8650919 20251129220611_3rF9I HR001E 2025-12-01T14:17:31.647Z 2025-12-06T14:46:35.935Z
8650892 8650892 20251129215724_2nrqQ HR001E 2025-12-01T14:17:28.444Z 2025-12-06T14:46:35.520Z
8650784 8650784 20251129212703_3sDxv HR001E 2025-12-01T14:17:10.091Z 2025-12-06T14:46:33.743Z
8650758 8650758 20251129212315_z8AtX HR001E 2025-12-01T14:17:06.507Z 2025-12-06T14:46:33.212Z
8650539 8650539 20251129203714_lTa9U HR001E 2025-12-01T14:16:25.491Z 2025-12-06T14:46:05.997Z
8650452 8650452 20251129202338_vcKiE HR001E 2025-12-01T14:16:15.177Z 2025-12-06T14:45:56.946Z
8650449 8650449 20251129202206_PTI1T HR001E 2025-12-01T14:16:14.733Z 2025-12-06T14:45:56.870Z
8650447 8650447 20251129202142_mSLFI HR001E 2025-12-01T14:16:14.012Z 2025-12-06T14:45:56.814Z
8649883 8649883 20251129184817_bDKxe HR001E 2025-12-01T14:14:14.709Z 2025-12-06T14:45:42.322Z
8649837 8649837 20251129183732_mWZKi HR001E 2025-12-01T14:14:05.913Z 2025-12-06T14:45:41.038Z
8649628 8649628 20251129175747_c6E72 HR001E 2025-12-01T14:13:23.080Z 2025-12-06T14:45:34.994Z
8649520 8649520 20251129173836_3k8rg HR001E 2025-12-01T14:12:55.544Z 2025-12-06T14:45:31.836Z
8649441 8649441 20251129172719_1D8N3 HR001E 2025-12-01T14:12:34.066Z 2025-12-01T14:35:20.743Z
8649196 8649196 20251129163534_DAfbV HR001E 2025-12-01T14:11:24.581Z 2025-12-06T14:44:51.083Z
8647673 8647673 20251129050630_0Qi8Y HR001E 2025-11-30T14:28:43.855Z 2025-12-06T14:56:42.944Z
8646892 8646892 20251129030740_1Rmdj HR001E 2025-11-30T14:27:05.465Z 2025-12-06T14:56:27.355Z
8646818 8646818 20251129025939_KZg3n HR001E 2025-11-30T14:26:59.968Z 2025-12-06T14:56:25.852Z
8646802 8646802 20251129025724_SG2yC HR001E 2025-11-30T14:26:58.958Z 2025-12-06T14:56:25.596Z
8646635 8646635 20251129023346_6nXzi HR001E 2025-11-30T14:26:35.609Z 2025-12-06T14:56:21.866Z
8646583 8646583 20251129022542_Mizb2 HR001E 2025-11-30T14:26:13.631Z 2025-12-06T14:56:15.537Z
8646569 8646569 20251129022327_brzuu HR001E 2025-11-30T14:26:12.430Z 2025-12-06T14:56:15.095Z
8646410 8646410 20251129020259_UAGu2 HR001E 2025-11-30T14:25:57.426Z 2025-12-06T14:56:05.169Z
8646260 8646260 20251129013420_IJWy4 HR001E 2025-11-30T14:25:44.938Z 2025-12-06T14:55:50.493Z
8646219 8646219 20251129012658_zOn4z HR001E 2025-11-30T14:25:26.942Z 2025-12-06T14:55:45.381Z
8646180 8646180 20251129012008_2FOJY HR001E 2025-11-30T14:25:22.392Z 2025-12-06T14:55:42.991Z
8645993 8645993 20251129004514_a7xOP HR001E 2025-11-30T14:25:02.589Z 2025-12-06T14:55:24.831Z
8645951 8645951 20251129003350_ZyuTQ HR001E 2025-11-30T14:24:58.670Z 2025-12-06T14:55:19.931Z
8645821 8645821 20251128235709_TwZ8Z HR001E 2025-11-30T14:24:35.632Z 2025-12-06T14:55:09.517Z
8645657 8645657 20251128231914_IxYgL HR001E 2025-11-30T14:24:21.530Z 2025-12-06T14:55:01.746Z
8645655 8645655 20251128231829_v1DqL HR001E 2025-11-30T14:24:21.278Z 2025-12-06T14:55:01.686Z
8645532 8645532 20251128224301_VqPre HR001E 2025-11-30T14:23:56.116Z 2025-12-06T14:54:59.711Z
8645437 8645437 20251128221047_e118Y HR001E 2025-11-30T14:23:44.038Z 2025-12-06T14:54:57.764Z
8645425 8645425 20251128220722_PgPcK HR001E 2025-11-30T14:23:43.008Z 2025-12-06T14:54:57.563Z
8645404 8645404 20251128215817_JptI3 HR001E 2025-11-30T14:23:40.555Z 2025-12-06T14:54:55.993Z
8645371 8645371 20251128213520_yPDzv HR001E 2025-11-30T14:23:37.884Z 2025-12-06T14:54:54.860Z
8645307 8645307 20251128211509_kBUza HR001E 2025-11-30T14:23:33.268Z 2025-12-06T14:54:53.354Z
8645274 8645274 20251128211047_BGd5E HR001E 2025-11-30T14:23:30.853Z 2025-12-06T14:54:52.403Z
8644822 8644822 20251128200234_AUUhh HR001E 2025-11-30T14:22:45.243Z 2025-12-06T14:54:47.791Z
8644229 8644229 20251128190942_Mq7IO HR001E 2025-11-30T14:21:29.811Z 2025-12-06T14:54:39.498Z
8643980 8643980 20251128184657_PLUL8 HR001E 2025-11-30T14:20:57.034Z 2025-12-06T14:54:36.416Z
8637273 8637273 20251128052446_T0UDO HR001E 2025-11-29T14:27:02.713Z 2025-12-06T15:03:58.507Z
8637199 8637199 20251128051355_IjCF7 HR001E 2025-11-29T14:26:57.572Z 2025-12-06T15:03:57.581Z
8636399 8636399 20251128034206_xMeIo HR001E 2025-11-29T14:25:27.485Z 2025-12-06T15:03:14.585Z
8636243 8636243 20251128032950_SeY2c HR001E 2025-11-29T14:25:09.162Z 2025-12-06T15:03:01.334Z
8635993 8635993 20251128030450_8VyQH HR001E 2025-11-29T14:24:44.522Z 2025-12-06T15:02:54.939Z
8635947 8635947 20251128030145_5JQYd HR001E 2025-11-29T14:24:41.318Z 2025-12-06T15:02:54.521Z
8635494 8635494 20251128021905_qXSuB HR001E 2025-11-29T14:23:29.652Z 2025-12-06T15:02:45.298Z
8634681 8634681 20251128011004_uQ93w HR001E 2025-11-29T14:21:55.479Z 2025-12-06T15:02:29.473Z
8634612 8634612 20251128010439_YWeoZ HR001E 2025-11-29T14:21:40.020Z 2025-12-06T15:02:25.700Z
8634433 8634433 20251128005054_NxUnq HR001E 2025-11-29T14:21:21.512Z 2025-12-06T15:02:04.275Z
8634381 8634381 20251128004448_ceylL HR001E 2025-11-29T14:21:16.420Z 2025-12-06T15:02:02.146Z
8634004 8634004 20251128001403_V3Mho HR001E 2025-11-29T14:20:37.270Z 2025-12-06T15:01:50.536Z
8633304 8633304 20251127230122_qlx21 HR001E 2025-11-29T14:19:23.750Z 2025-12-06T15:01:42.173Z
8633122 8633122 20251127224013_500Dj HR001E 2025-11-29T14:19:00.025Z 2025-12-06T15:01:40.117Z
8632763 8632763 20251127215102_svye6 HR001E 2025-11-29T14:18:19.596Z 2025-12-06T15:01:33.151Z
8632715 8632715 20251127214241_D0T6b HR001E 2025-11-29T14:18:07.130Z 2025-12-06T15:01:32.634Z

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