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 = "ES000D" 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
8017980 8017980 20250930022709_BLYiJ ES000D 2025-10-01T12:27:39.676Z 2025-10-08T12:43:32.459Z
7989881 7989881 20250926042122_Ma3n9 ES000D 2025-09-28T12:36:54.235Z 2025-10-04T13:07:24.791Z
7985773 7985773 20250927035538_HuEMB ES000D 2025-09-28T12:26:55.008Z 2025-10-05T13:11:20.240Z
7984575 7984575 20250927015735_SFinC ES000D 2025-09-28T12:24:29.685Z 2025-10-05T13:10:54.528Z
7963254 7963254 20250925030942_CPPP6 ES000D 2025-09-26T12:28:26.398Z 2025-09-26T12:30:00.056Z
7962847 7962847 20250925024816_HYSWn ES000D 2025-09-26T12:27:46.893Z 2025-09-26T12:29:59.953Z
7962677 7962677 20250925023709_zL576 ES000D 2025-09-26T12:27:38.494Z 2025-10-03T13:04:23.633Z
7937421 7937421 20250924033719_AdP9W ES000D 2025-09-25T12:00:20.873Z 2025-10-03T13:02:24.609Z
7922347 7922347 20250923024017_kbC78 ES000D 2025-09-24T12:31:13.061Z 2025-10-01T13:24:54.518Z
7920433 7920433 20250923011048_UM3By ES000D 2025-09-24T12:28:49.065Z 2025-10-01T13:24:27.178Z
7919734 7919734 20250923003559_vfSga ES000D 2025-09-24T12:27:42.538Z 2025-10-01T13:24:21.270Z
7918807 7918807 20250922234714_3USeI ES000D 2025-09-24T12:26:18.640Z 2025-10-01T13:24:12.928Z
7918287 7918287 20250922231611_m2sw3 ES000D 2025-09-24T12:25:29.223Z 2025-10-01T13:24:05.033Z
7917333 7917333 20250922221759_vW0nc ES000D 2025-09-24T12:23:42.122Z 2025-10-01T13:23:51.590Z
7909789 7909789 20250923033703_b2pQi ES000D 2025-09-24T12:01:47.452Z 2025-10-02T13:22:23.568Z
7909559 7909559 20250923032520_vzurH ES000D 2025-09-24T12:01:18.214Z 2025-10-02T13:22:20.366Z
7909461 7909461 20250923031955_beD0x ES000D 2025-09-24T12:01:02.654Z 2025-10-02T13:22:19.707Z
7894845 7894845 20250919230541_9HBlB ES000D 2025-09-21T12:37:48.387Z 2025-09-28T12:54:37.772Z
7883894 7883894 20250920014521_B1BQE ES000D 2025-09-21T12:01:19.830Z 2025-09-29T13:02:39.569Z
7883219 7883219 20250919004836_FW1c4 ES000D 2025-09-20T12:37:42.710Z 2025-09-27T12:48:00.147Z
7874795 7874795 20250919042158_oEdHX ES000D 2025-09-20T12:12:11.476Z 2025-09-28T12:53:21.485Z
7874521 7874521 20250919035247_42jaA ES000D 2025-09-20T12:11:14.849Z 2025-09-28T12:53:19.425Z
7874300 7874300 20250919033517_wRBry ES000D 2025-09-20T12:10:18.123Z 2025-09-20T12:10:18.123Z
7872216 7872216 20250919010934_xZyzX ES000D 2025-09-20T12:01:14.140Z 2025-09-28T12:53:03.569Z
7866275 7866275 20250918033305_f3Dvd ES000D 2025-09-19T12:09:40.754Z 2025-09-27T12:46:28.459Z
7865819 7865819 20250918025000_CIjFW ES000D 2025-09-19T12:07:47.190Z 2025-09-27T12:46:20.890Z
7864199 7864199 20250918002446_ggt6M ES000D 2025-09-19T12:00:38.936Z 2025-09-27T12:45:42.078Z
7832184 7832184 20250915030059_Yj9TF ES000D 2025-09-16T12:08:35.902Z 2025-09-22T13:02:36.021Z
7831488 7831488 20250915013115_xzNTZ ES000D 2025-09-16T12:05:39.881Z 2025-09-22T13:02:13.350Z
7804409 7804409 20250910223515_n0tYn ES000D 2025-09-12T12:02:35.939Z 2025-09-19T12:56:44.238Z
7740582 7740582 20250902003023_S6Y8w ES000D 2025-09-03T12:18:29.032Z 2025-09-10T12:46:34.832Z
7738914 7738914 20250901223004_yt1z3 ES000D 2025-09-03T12:14:04.777Z 2025-09-10T12:46:02.252Z
7715215 7715215 20250831023817_MetQK ES000D 2025-09-01T12:20:32.317Z 2025-09-08T12:52:42.713Z
7547463 7547463 20250815222537_C9MsM ES000D 2025-08-18T12:44:56.803Z 2025-08-23T12:49:55.832Z
7547130 7547130 20250815221238_37isI ES000D 2025-08-18T12:44:46.368Z 2025-08-23T12:49:53.780Z
7546541 7546541 20250815214154_htoYk ES000D 2025-08-18T12:43:54.975Z 2025-08-23T12:49:50.458Z
7533661 7533661 20250816033043_hk8hp ES000D 2025-08-18T12:13:18.338Z 2025-08-18T12:13:18.338Z
7533431 7533431 20250816030358_aGFU2 ES000D 2025-08-18T12:12:42.320Z 2025-08-24T12:47:47.668Z
7532866 7532866 20250816021634_l2aAx ES000D 2025-08-18T12:11:05.216Z 2025-08-24T12:47:43.408Z
7532843 7532843 20250816021423_xxTZw ES000D 2025-08-18T12:11:02.176Z 2025-08-24T12:47:43.218Z
7531888 7531888 20250816012022_0miJQ ES000D 2025-08-18T12:08:16.833Z 2025-08-24T12:47:35.505Z
7531406 7531406 20250816004348_H7DIC ES000D 2025-08-18T12:06:47.110Z 2025-08-24T12:47:32.747Z
7530659 7530659 20250815235931_bUe2L ES000D 2025-08-18T12:04:11.615Z 2025-08-24T12:47:29.800Z
7530646 7530646 20250815235831_nTurY ES000D 2025-08-18T12:04:08.153Z 2025-08-24T12:47:29.732Z
7529757 7529757 20250815230711_6HB9T ES000D 2025-08-18T12:01:06.485Z 2025-08-24T12:47:25.692Z
7528767 7528767 20250814213351_HMQb3 ES000D 2025-08-17T12:49:38.482Z 2025-08-22T12:47:34.792Z
7528260 7528260 20250814211344_W0tpK ES000D 2025-08-17T12:48:40.992Z 2025-08-22T12:47:33.789Z
7527703 7527703 20250814204947_KmBR2 ES000D 2025-08-17T12:48:17.218Z 2025-08-22T12:47:33.085Z
7521323 7521323 20250815032051_gQYUv ES000D 2025-08-17T12:20:55.516Z 2025-08-23T12:48:48.312Z
7521190 7521190 20250815030948_pfH4V ES000D 2025-08-17T12:20:47.841Z 2025-08-23T12:48:48.130Z
7520805 7520805 20250815025104_Bs4tf ES000D 2025-08-17T12:20:04.621Z 2025-08-23T12:48:47.603Z
7520778 7520778 20250815025031_bZL9R ES000D 2025-08-17T12:20:03.344Z 2025-08-17T12:20:03.344Z
7520651 7520651 20250815024454_TwlOC ES000D 2025-08-17T12:19:55.608Z 2025-08-23T12:48:47.418Z
7520517 7520517 20250815023945_TbhTo ES000D 2025-08-17T12:19:39.884Z 2025-08-23T12:48:47.290Z
7520437 7520437 20250815023837_b23rG ES000D 2025-08-17T12:19:27.585Z 2025-08-23T12:48:46.929Z
7520055 7520055 20250815022716_HIJiW ES000D 2025-08-17T12:19:05.102Z 2025-08-23T12:48:45.563Z
7519870 7519870 20250815022050_3uLTY ES000D 2025-08-17T12:18:34.155Z 2025-08-23T12:48:45.249Z
7519725 7519725 20250815021723_907bd ES000D 2025-08-17T12:18:24.080Z 2025-08-23T12:48:45.046Z
7519562 7519562 20250815021213_7uac3 ES000D 2025-08-17T12:18:13.867Z 2025-08-23T12:48:44.757Z
7517791 7517791 20250815010804_b5IgQ ES000D 2025-08-17T12:14:32.700Z 2025-08-23T12:48:36.458Z
7517783 7517783 20250815010750_Ou49s ES000D 2025-08-17T12:14:32.332Z 2025-08-23T12:48:36.450Z
7517092 7517092 20250815004352_XX222 ES000D 2025-08-17T12:13:07.965Z 2025-08-23T12:48:33.958Z
7515841 7515841 20250815000237_wGQ8s ES000D 2025-08-17T12:10:13.773Z 2025-08-23T12:48:29.446Z
7514972 7514972 20250814233159_XCkSH ES000D 2025-08-17T12:08:19.599Z 2025-08-23T12:48:26.991Z
7514594 7514594 20250814231911_NtiZr ES000D 2025-08-17T12:07:17.639Z 2025-08-23T12:48:26.411Z
7514199 7514199 20250814230551_JTO7K ES000D 2025-08-17T12:06:29.454Z 2025-08-23T12:48:24.487Z
7514180 7514180 20250814230525_rtJ23 ES000D 2025-08-17T12:06:27.584Z 2025-08-23T12:48:24.464Z
7513761 7513761 20250814225343_143HM ES000D 2025-08-17T12:05:17.387Z 2025-08-23T12:48:16.661Z
7512490 7512490 20250814220721_bGx2E ES000D 2025-08-17T12:01:35.566Z 2025-08-23T12:48:06.407Z
7512336 7512336 20250814220226_TSMuU ES000D 2025-08-17T12:01:06.995Z 2025-08-23T12:48:06.012Z
7512308 7512308 20250814220124_sBmnx ES000D 2025-08-17T12:00:59.409Z 2025-08-23T12:48:05.911Z
7506550 7506550 20250814022709_UrXdL ES000D 2025-08-16T12:50:23.260Z 2025-08-22T12:46:51.803Z
7506386 7506386 20250814021851_2JY4b ES000D 2025-08-16T12:50:19.083Z 2025-08-22T12:46:51.435Z
7506256 7506256 20250814021107_siT7B ES000D 2025-08-16T12:50:15.369Z 2025-08-22T12:46:51.123Z
7506169 7506169 20250814020504_E6I9T ES000D 2025-08-16T12:50:13.456Z 2025-08-22T12:46:50.640Z
7505501 7505501 20250814012439_WxM3Z ES000D 2025-08-16T12:49:11.689Z 2025-08-22T12:46:48.450Z
7476633 7476633 20250813035036_IGjeu ES000D 2025-08-14T12:36:45.880Z 2025-08-21T12:47:49.602Z
7476627 7476627 20250813034818_n8CzM ES000D 2025-08-14T12:36:44.382Z 2025-08-21T12:47:49.106Z
7476625 7476625 20250813034800_bqGLQ ES000D 2025-08-14T12:36:44.376Z 2025-08-21T12:47:49.102Z
7476611 7476611 20250813032817_jt66X ES000D 2025-08-14T12:36:43.770Z 2025-08-21T12:47:48.849Z
7476606 7476606 20250813032658_KX1De ES000D 2025-08-14T12:36:43.759Z 2025-08-14T12:36:43.759Z
7476604 7476604 20250813032655_IlPot ES000D 2025-08-14T12:36:43.713Z 2025-08-21T12:47:48.771Z
7476568 7476568 20250813031700_3WYbb ES000D 2025-08-14T12:36:40.173Z 2025-08-21T12:47:47.906Z
7476564 7476564 20250813031540_2V3yw ES000D 2025-08-14T12:36:40.163Z 2025-08-21T12:47:47.860Z
7476544 7476544 20250813031037_3gbVZ ES000D 2025-08-14T12:36:39.570Z 2025-08-21T12:47:47.736Z
7476536 7476536 20250813030749_QNlH0 ES000D 2025-08-14T12:36:39.309Z 2025-08-14T12:36:39.309Z
7476489 7476489 20250813030443_7dLZs ES000D 2025-08-14T12:36:38.221Z 2025-08-21T12:47:47.548Z
7476468 7476468 20250813030238_68vmV ES000D 2025-08-14T12:36:37.265Z 2025-08-21T12:47:47.463Z
7476442 7476442 20250813025916_J2704 ES000D 2025-08-14T12:36:36.077Z 2025-08-14T12:36:36.077Z
7476388 7476388 20250813025537_RLo8z ES000D 2025-08-14T12:36:34.795Z 2025-08-14T12:36:34.795Z
7476336 7476336 20250813025208_2sTm3 ES000D 2025-08-14T12:36:31.627Z 2025-08-21T12:47:46.874Z
7476331 7476331 20250813025159_w1vQx ES000D 2025-08-14T12:36:31.521Z 2025-08-21T12:47:46.863Z
7476197 7476197 20250813024347_pPeoV ES000D 2025-08-14T12:36:25.322Z 2025-08-21T12:47:46.448Z
7476104 7476104 20250813023845_9GDrU ES000D 2025-08-14T12:36:20.763Z 2025-08-14T12:36:20.763Z
7476093 7476093 20250813023808_qRjbP ES000D 2025-08-14T12:36:20.074Z 2025-08-21T12:47:45.997Z
7476076 7476076 20250813023741_tV9YE ES000D 2025-08-14T12:36:19.897Z 2025-08-21T12:47:45.963Z
7475868 7475868 20250813023003_12CBg ES000D 2025-08-14T12:36:13.986Z 2025-08-21T12:47:44.868Z
7475854 7475854 20250813022929_5wX7G ES000D 2025-08-14T12:36:13.414Z 2025-08-21T12:47:44.702Z
7475636 7475636 20250813022211_iFnjX ES000D 2025-08-14T12:36:07.839Z 2025-08-21T12:47:44.130Z
7475595 7475595 20250813022032_FT294 ES000D 2025-08-14T12:36:06.958Z 2025-08-14T12:36:06.958Z

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