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 = "IT0001" 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
7589233 7589233 20250819001056_O3QLw IT0001 2025-08-21T12:36:45.207Z 2025-08-27T13:15:30.446Z
7589134 7589134 20250819000535_IhyEm IT0001 2025-08-21T12:36:42.709Z 2025-08-27T13:15:28.754Z
7589112 7589112 20250819000442_Rl2g7 IT0001 2025-08-21T12:36:42.140Z 2025-08-27T13:15:27.953Z
7588152 7588152 20250818230129_MBjcC IT0001 2025-08-21T12:36:17.963Z 2025-08-27T13:15:04.687Z
7588040 7588040 20250818225449_bt0et IT0001 2025-08-21T12:36:16.494Z 2025-08-27T13:15:03.685Z
7587994 7587994 20250818225044_CH6hU IT0001 2025-08-21T12:36:16.081Z 2025-08-27T13:15:03.226Z
7585645 7585645 20250818194348_eYZ2i IT0001 2025-08-21T12:34:57.584Z 2025-08-27T13:14:01.416Z
7585448 7585448 20250820023140_3L7yT IT0001 2025-08-21T12:24:06.064Z 2025-08-28T12:52:42.238Z
7585417 7585417 20250820022221_hmgTw IT0001 2025-08-21T12:24:04.134Z 2025-08-28T12:52:42.178Z
7585409 7585409 20250820021745_oapco IT0001 2025-08-21T12:24:03.490Z 2025-08-28T12:52:42.147Z
7585402 7585402 20250820021604_lqUxK IT0001 2025-08-21T12:24:03.005Z 2025-08-28T12:52:42.130Z
7585295 7585295 20250820020155_GEcFy IT0001 2025-08-21T12:23:36.555Z 2025-08-28T12:52:41.922Z
7585081 7585081 20250820012532_lHCS3 IT0001 2025-08-21T12:23:14.169Z 2025-08-28T12:52:41.470Z
7585079 7585079 20250820012434_O00m1 IT0001 2025-08-21T12:23:14.096Z 2025-08-21T12:24:11.297Z
7584941 7584941 20250820010742_RDOWe IT0001 2025-08-21T12:23:07.522Z 2025-08-28T12:52:41.224Z
7584829 7584829 20250820005248_sor5z IT0001 2025-08-21T12:23:00.860Z 2025-08-28T12:52:40.974Z
7584594 7584594 20250820002019_sXiXR IT0001 2025-08-21T12:22:23.145Z 2025-08-28T12:52:39.869Z
7584541 7584541 20250820001539_1gD4O IT0001 2025-08-21T12:22:20.311Z 2025-08-21T12:24:11.129Z
7584356 7584356 20250819235408_IYocI IT0001 2025-08-21T12:22:07.615Z 2025-08-28T12:52:38.248Z
7584305 7584305 20250819235044_piDDK IT0001 2025-08-21T12:21:50.071Z 2025-08-28T12:52:38.192Z
7584177 7584177 20250819233632_Hqn44 IT0001 2025-08-21T12:21:38.037Z 2025-08-28T12:52:37.251Z
7584163 7584163 20250819233403_zZq0g IT0001 2025-08-21T12:21:36.745Z 2025-08-28T12:52:37.203Z
7584051 7584051 20250819232036_erzk0 IT0001 2025-08-21T12:21:27.043Z 2025-08-28T12:52:36.689Z
7583897 7583897 20250819225707_nZbPz IT0001 2025-08-21T12:20:55.706Z 2025-08-21T12:24:10.947Z
7583701 7583701 20250819223151_Jd5ld IT0001 2025-08-21T12:20:38.438Z 2025-08-28T12:52:34.136Z
7583528 7583528 20250819220618_6eqsW IT0001 2025-08-21T12:20:10.379Z 2025-08-28T12:52:33.663Z
7583439 7583439 20250819215139_9cQVO IT0001 2025-08-21T12:20:00.691Z 2025-08-28T12:52:32.485Z
7583320 7583320 20250819213110_YhAmz IT0001 2025-08-21T12:19:49.790Z 2025-08-28T12:52:32.021Z
7583271 7583271 20250819212448_34aop IT0001 2025-08-21T12:19:29.364Z 2025-08-28T12:52:31.564Z
7583153 7583153 20250819210612_txyDY IT0001 2025-08-21T12:19:15.724Z 2025-08-28T12:52:31.136Z
7582731 7582731 20250819194942_Vbggu IT0001 2025-08-21T12:18:25.607Z 2025-08-28T12:52:24.734Z
7582676 7582676 20250819193822_NYDU6 IT0001 2025-08-21T12:18:06.809Z 2025-08-28T12:52:23.678Z
7582608 7582608 20250819192354_3XL7C IT0001 2025-08-21T12:18:00.005Z 2025-08-28T12:52:23.320Z
7582602 7582602 20250819192223_cQJ1x IT0001 2025-08-21T12:17:59.130Z 2025-08-28T12:52:23.235Z
7577147 7577147 20250819024139_Sg71k IT0001 2025-08-21T12:03:43.735Z 2025-08-28T12:51:39.813Z
7577112 7577112 20250819023746_kvrhe IT0001 2025-08-21T12:03:37.328Z 2025-08-28T12:51:38.228Z
7577110 7577110 20250819023746_yyqxN IT0001 2025-08-21T12:03:37.214Z 2025-08-28T12:51:38.223Z
7576063 7576063 20250820025436_x4Arf IT0001 2025-08-21T12:00:21.001Z 2025-08-29T12:55:19.311Z
7576038 7576038 20250820024712_rDkHW IT0001 2025-08-21T12:00:15.072Z 2025-08-21T12:00:15.072Z
7576018 7576018 20250820024204_ibZ0G IT0001 2025-08-21T12:00:09.569Z 2025-08-29T12:55:18.845Z
7575829 7575829 20250816230922_rO1tq IT0001 2025-08-20T12:45:40.707Z 2025-08-24T12:49:00.626Z
7566014 7566014 20250818024338_xl44W IT0001 2025-08-20T12:06:30.737Z 2025-08-27T13:13:16.600Z
7565984 7565984 20250818024046_OuKru IT0001 2025-08-20T12:06:22.275Z 2025-08-27T13:13:16.474Z
7565393 7565393 20250818015054_ldIcW IT0001 2025-08-20T12:04:01.234Z 2025-08-27T13:13:13.385Z
7565274 7565274 20250818014236_VQOes IT0001 2025-08-20T12:03:34.252Z 2025-08-27T13:13:11.548Z
7565166 7565166 20250818013524_Kk1FH IT0001 2025-08-20T12:03:09.015Z 2025-08-27T13:13:09.308Z
7563337 7563337 20250816233404_Tg4es IT0001 2025-08-19T13:03:13.223Z 2025-08-24T12:49:03.748Z
7562875 7562875 20250816231633_n813S IT0001 2025-08-19T13:02:30.759Z 2025-08-24T12:49:01.006Z
7562702 7562702 20250816230922_ATqZD IT0001 2025-08-19T13:01:58.032Z 2025-08-19T13:04:10.305Z
7562593 7562593 20250816230519_Dpuaw IT0001 2025-08-19T13:01:52.030Z 2025-08-24T12:49:00.537Z
7562196 7562196 20250816224132_ieIsK IT0001 2025-08-19T13:00:56.540Z 2025-08-24T12:48:59.415Z
7562067 7562067 20250816223515_lUgrz IT0001 2025-08-19T13:00:48.451Z 2025-08-24T12:48:58.870Z
7561876 7561876 20250816222800_zo98e IT0001 2025-08-19T13:00:19.461Z 2025-08-24T12:48:55.756Z
7561758 7561758 20250816222012_q2ISR IT0001 2025-08-19T13:00:10.753Z 2025-08-24T12:48:55.235Z
7561532 7561532 20250816221054_n5VI2 IT0001 2025-08-19T12:59:40.031Z 2025-08-24T12:48:52.935Z
7560930 7560930 20250816214352_hZ4q7 IT0001 2025-08-19T12:58:41.168Z 2025-08-24T12:48:50.719Z
7560410 7560410 20250816211714_r7TGG IT0001 2025-08-19T12:57:45.094Z 2025-08-24T12:48:48.452Z
7560353 7560353 20250816211410_Q1BI3 IT0001 2025-08-19T12:57:23.842Z 2025-08-24T12:48:47.968Z
7560216 7560216 20250816210729_EUdpP IT0001 2025-08-19T12:57:15.567Z 2025-08-24T12:48:46.554Z
7560066 7560066 20250816210054_NcMmC IT0001 2025-08-19T12:57:06.497Z 2025-08-24T12:48:45.922Z
7550615 7550615 20250817002653_6nohO IT0001 2025-08-19T12:07:15.696Z 2025-08-25T12:51:41.182Z
7550307 7550307 20250817001444_SfzO2 IT0001 2025-08-19T12:05:23.441Z 2025-08-25T12:51:40.534Z
7550023 7550023 20250817000229_KCxIB IT0001 2025-08-19T12:03:01.941Z 2025-08-25T12:51:39.806Z
7549922 7549922 20250816235900_YgXDJ IT0001 2025-08-19T12:02:11.470Z 2025-08-25T12:51:39.651Z
7547202 7547202 20250815221527_st1lH IT0001 2025-08-18T12:44:48.899Z 2025-08-23T12:49:54.487Z
7547166 7547166 20250815221304_wuOPb IT0001 2025-08-18T12:44:47.339Z 2025-08-23T12:49:53.813Z
7547065 7547065 20250815220939_w5TEB IT0001 2025-08-18T12:44:44.938Z 2025-08-23T12:49:53.687Z
7546968 7546968 20250815220412_7BBoG IT0001 2025-08-18T12:44:42.265Z 2025-08-23T12:49:53.563Z
7546531 7546531 20250815214041_7V1QS IT0001 2025-08-18T12:43:51.038Z 2025-08-23T12:49:50.413Z
7546421 7546421 20250815213447_n1U9J IT0001 2025-08-18T12:43:44.615Z 2025-08-23T12:49:49.052Z
7546315 7546315 20250815212825_wkcaN IT0001 2025-08-18T12:43:40.592Z 2025-08-23T12:49:48.435Z
7545569 7545569 20250815202822_fxMmB IT0001 2025-08-18T12:42:32.516Z 2025-08-23T12:49:40.740Z
7545502 7545502 20250815202131_Yv7zn IT0001 2025-08-18T12:42:29.693Z 2025-08-23T12:49:40.499Z
7536886 7536886 20250814222630_GQKD0 IT0001 2025-08-18T12:23:43.255Z 2025-08-23T12:48:12.808Z
7529572 7529572 20250815225554_MnBch IT0001 2025-08-18T12:00:23.655Z 2025-08-24T12:47:24.183Z
7529536 7529536 20250815225405_3StCs IT0001 2025-08-18T12:00:17.574Z 2025-08-24T12:47:22.576Z
7529293 7529293 20250814215201_LpCVh IT0001 2025-08-17T12:49:53.057Z 2025-08-22T12:47:35.462Z
7528988 7528988 20250814214137_lv5HN IT0001 2025-08-17T12:49:44.095Z 2025-08-22T12:47:35.045Z
7528957 7528957 20250814214056_4m7Xw IT0001 2025-08-17T12:49:43.352Z 2025-08-22T12:47:35.004Z
7528214 7528214 20250814211121_n8lKb IT0001 2025-08-17T12:48:35.157Z 2025-08-22T12:47:33.722Z
7528088 7528088 20250814210639_kNbmx IT0001 2025-08-17T12:48:31.284Z 2025-08-22T12:47:33.517Z
7527667 7527667 20250814204642_2VROE IT0001 2025-08-17T12:48:15.856Z 2025-08-22T12:47:33.031Z
7527525 7527525 20250814203838_xVXik IT0001 2025-08-17T12:48:10.284Z 2025-08-22T12:47:32.875Z
7527457 7527457 20250814203312_DfB09 IT0001 2025-08-17T12:47:44.954Z 2025-08-22T12:47:32.780Z
7527258 7527258 20250814201637_m5dLl IT0001 2025-08-17T12:47:21.705Z 2025-08-22T12:47:32.375Z
7527200 7527200 20250814201008_ycn1x IT0001 2025-08-17T12:47:16.525Z 2025-08-22T12:47:32.183Z
7527141 7527141 20250814200420_Yv6Oy IT0001 2025-08-17T12:47:13.781Z 2025-08-22T12:47:32.033Z
7526959 7526959 20250814193624_ALnSP IT0001 2025-08-17T12:47:03.967Z 2025-08-22T12:47:30.948Z
7513869 7513869 20250814225647_APwmm IT0001 2025-08-17T12:05:40.261Z 2025-08-23T12:48:19.337Z
7513639 7513639 20250814224818_d2aeU IT0001 2025-08-17T12:05:04.494Z 2025-08-23T12:48:16.555Z
7513175 7513175 20250814223458_bIvk3 IT0001 2025-08-17T12:03:46.847Z 2025-08-23T12:48:13.868Z
7512986 7512986 20250814222630_TCqh2 IT0001 2025-08-17T12:03:13.667Z 2025-08-17T12:49:57.526Z
7512755 7512755 20250814221743_Y9gzG IT0001 2025-08-17T12:02:31.337Z 2025-08-23T12:48:08.949Z
7512484 7512484 20250814220652_gaw3m IT0001 2025-08-17T12:01:30.828Z 2025-08-23T12:48:06.385Z
7512201 7512201 20250814215656_mZsTE IT0001 2025-08-17T12:00:36.614Z 2025-08-23T12:48:03.965Z
7512093 7512093 20250814215348_bvn0C IT0001 2025-08-17T12:00:17.102Z 2025-08-23T12:48:03.670Z
7511773 7511773 20250810195857_xx8F2 IT0001 2025-08-16T13:06:03.311Z 2025-08-18T13:36:58.959Z
7511745 7511745 20250812194228_72Xxq IT0001 2025-08-16T13:05:38.092Z 2025-08-20T13:08:00.738Z
7511596 7511596 20250811194620_bdRnj IT0001 2025-08-16T12:57:17.312Z 2025-08-20T13:05:44.486Z
7504119 7504119 20250813205108_T3qD2 IT0001 2025-08-16T12:45:40.044Z 2025-08-21T12:48:28.680Z

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