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

1,704 rows where station_code = "CL0003" 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
8687259 8687259 20251204063007_mNx3O CL0003 2025-12-05T14:14:31.803Z 2025-12-05T14:14:35.670Z
8687221 8687221 20251204055642_APX7a CL0003 2025-12-05T14:14:25.923Z 2025-12-05T14:14:35.655Z
8683819 8683819 20251204083539_Idddp CL0003 2025-12-05T14:00:47.072Z 2025-12-05T14:00:47.072Z
8683803 8683803 20251204082119_kkll8 CL0003 2025-12-05T14:00:41.921Z 2025-12-05T14:00:41.921Z
8683289 8683289 20251203065224_nX39R CL0003 2025-12-04T14:19:05.055Z 2025-12-05T14:23:14.667Z
8683278 8683278 20251203064939_oDWjA CL0003 2025-12-04T14:19:03.374Z 2025-12-05T14:23:13.964Z
8683201 8683201 20251203063859_Dyx39 CL0003 2025-12-04T14:18:54.851Z 2025-12-05T14:23:11.057Z
8683098 8683098 20251203062712_cLXgI CL0003 2025-12-04T14:18:34.687Z 2025-12-05T14:23:07.802Z
8682860 8682860 20251203061035_wG8kX CL0003 2025-12-04T14:18:09.287Z 2025-12-05T14:22:54.617Z
8681774 8681774 20251203040248_QaQy5 CL0003 2025-12-04T14:15:33.905Z 2025-12-05T14:22:00.032Z
8681417 8681417 20251203030628_5c00W CL0003 2025-12-04T14:14:41.038Z 2025-12-05T14:21:36.364Z
8681230 8681230 20251203024637_6Y2gg CL0003 2025-12-04T14:14:06.059Z 2025-12-05T14:21:27.932Z
8677319 8677319 20251203084050_LBDUQ CL0003 2025-12-04T14:00:45.799Z 2025-12-05T14:14:34.799Z
8677315 8677315 20251203083533_HhmVn CL0003 2025-12-04T14:00:44.914Z 2025-12-05T14:14:34.797Z
8677283 8677283 20251203081334_pR9Eq CL0003 2025-12-04T14:00:35.811Z 2025-12-05T14:14:34.787Z
8677271 8677271 20251203080859_DO6B2 CL0003 2025-12-04T14:00:33.134Z 2025-12-05T14:14:34.783Z
8677229 8677229 20251203072949_CtNpN CL0003 2025-12-04T14:00:25.837Z 2025-12-05T14:14:34.770Z
8677227 8677227 20251203072855_a7otd CL0003 2025-12-04T14:00:25.360Z 2025-12-05T14:14:34.769Z
8677145 8677145 20251202070544_qrnP2 CL0003 2025-12-03T14:26:21.800Z 2025-12-05T14:29:22.973Z
8677081 8677081 20251202064425_abLnp CL0003 2025-12-03T14:26:16.613Z 2025-12-05T14:29:20.478Z
8677055 8677055 20251202064256_dq9gg CL0003 2025-12-03T14:26:13.990Z 2025-12-05T14:29:19.436Z
8676351 8676351 20251202054824_YfbyD CL0003 2025-12-03T14:25:08.536Z 2025-12-05T14:28:54.950Z
8675869 8675869 20251202051923_uzivZ CL0003 2025-12-03T14:24:27.299Z 2025-12-05T14:28:42.878Z
8675693 8675693 20251202050948_fL4VK CL0003 2025-12-03T14:24:10.521Z 2025-12-05T14:28:38.650Z
8675182 8675182 20251202041344_CmHJV CL0003 2025-12-03T14:23:15.710Z 2025-12-05T14:28:14.495Z
8675158 8675158 20251202040708_gY4Mz CL0003 2025-12-03T14:23:13.382Z 2025-12-05T14:28:13.505Z
8674865 8674865 20251202033531_TaWi6 CL0003 2025-12-03T14:22:32.452Z 2025-12-05T14:28:05.389Z
8674857 8674857 20251202033423_uI2qm CL0003 2025-12-03T14:22:29.701Z 2025-12-05T14:28:04.856Z
8674729 8674729 20251202031559_XP2Er CL0003 2025-12-03T14:22:16.186Z 2025-12-05T14:28:01.240Z
8674625 8674625 20251202030050_fL2oH CL0003 2025-12-03T14:22:09.199Z 2025-12-05T14:27:58.207Z
8674381 8674381 20251202021414_5tr81 CL0003 2025-12-03T14:21:33.596Z 2025-12-05T14:27:39.803Z
8674352 8674352 20251202020621_3MkgO CL0003 2025-12-03T14:21:27.301Z 2025-12-05T14:27:38.675Z
8674226 8674226 20251202014853_5xYt6 CL0003 2025-12-03T14:21:15.478Z 2025-12-05T14:27:33.120Z
8668661 8668661 20251202081258_Cn6aP CL0003 2025-12-03T14:00:45.468Z 2025-12-05T14:14:53.617Z
8668648 8668648 20251202080845_72xc2 CL0003 2025-12-03T14:00:40.261Z 2025-12-05T14:14:48.842Z
8668608 8668608 20251202075722_7AL2V CL0003 2025-12-03T14:00:33.284Z 2025-12-05T14:14:46.337Z
8668579 8668579 20251202074702_sMMkt CL0003 2025-12-03T14:00:29.276Z 2025-12-05T14:14:45.208Z
8668577 8668577 20251202074547_iaSuq CL0003 2025-12-03T14:00:28.873Z 2025-12-05T14:14:44.988Z
8668561 8668561 20251202073532_pxkMv CL0003 2025-12-03T14:00:23.175Z 2025-12-05T14:14:43.914Z
8666551 8666551 20251201065817_tOtcx CL0003 2025-12-02T14:26:26.881Z 2025-12-05T14:37:03.562Z
8666436 8666436 20251201053931_o0wWl CL0003 2025-12-02T14:26:10.276Z 2025-12-05T14:36:58.203Z
8666316 8666316 20251201051114_nNQdx CL0003 2025-12-02T14:25:45.980Z 2025-12-05T14:36:54.069Z
8666166 8666166 20251201044437_iqh2t CL0003 2025-12-02T14:25:32.014Z 2025-12-05T14:36:34.844Z
8666063 8666063 20251201042914_9jX86 CL0003 2025-12-02T14:25:10.577Z 2025-12-05T14:36:31.105Z
8665871 8665871 20251201040417_wi3GA CL0003 2025-12-02T14:24:37.263Z 2025-12-05T14:36:22.339Z
8665774 8665774 20251201035705_hwUdH CL0003 2025-12-02T14:24:27.444Z 2025-12-05T14:36:18.765Z
8665387 8665387 20251201031444_TKSoV CL0003 2025-12-02T14:23:36.572Z 2025-12-05T14:35:54.425Z
8665169 8665169 20251201024118_XAnuZ CL0003 2025-12-02T14:23:03.717Z 2025-12-05T14:35:44.606Z
8665149 8665149 20251201023615_D4wJP CL0003 2025-12-02T14:23:01.227Z 2025-12-05T14:35:43.942Z
8665045 8665045 20251201022051_4ePAt CL0003 2025-12-02T14:22:41.239Z 2025-12-05T14:35:40.441Z
8664429 8664429 20251201002608_cJlmZ CL0003 2025-12-02T14:21:03.460Z 2025-12-05T14:35:03.836Z
8658823 8658823 20251130082702_E6SVq CL0003 2025-12-02T14:01:01.619Z 2025-12-05T14:29:31.288Z
8658708 8658708 20251201083347_tazoL CL0003 2025-12-02T14:00:22.426Z 2025-12-05T14:23:19.968Z
8658698 8658698 20251201080448_hivud CL0003 2025-12-02T14:00:19.555Z 2025-12-05T14:23:18.577Z
8658678 8658678 20251201073629_kwD96 CL0003 2025-12-02T14:00:12.223Z 2025-12-05T14:23:16.980Z
8658177 8658177 20251130072013_HFUYn CL0003 2025-12-01T14:35:16.354Z 2025-12-05T14:46:06.598Z
8658155 8658155 20251130065439_zG25M CL0003 2025-12-01T14:35:01.071Z 2025-12-05T14:46:04.723Z
8658153 8658153 20251130065436_f2hsc CL0003 2025-12-01T14:34:59.921Z 2025-12-05T14:46:04.618Z
8658122 8658122 20251130064416_C2aPe CL0003 2025-12-01T14:34:55.852Z 2025-12-05T14:46:02.949Z
8656507 8656507 20251130045730_ul4Qs CL0003 2025-12-01T14:28:42.318Z 2025-12-05T14:45:16.966Z
8655139 8655139 20251130034538_KHi4X CL0003 2025-12-01T14:26:25.835Z 2025-12-05T14:44:28.694Z
8655002 8655002 20251130034047_pjruT CL0003 2025-12-01T14:26:15.201Z 2025-12-01T14:26:15.201Z
8653113 8653113 20251130015839_c3YiA CL0003 2025-12-01T14:22:50.490Z 2025-12-05T14:43:04.019Z
8648382 8648382 20251129074106_6IwMN CL0003 2025-11-30T14:30:07.259Z 2025-12-05T14:53:19.256Z
8648365 8648365 20251129073634_pO35w CL0003 2025-11-30T14:30:06.038Z 2025-12-05T14:53:17.732Z
8648277 8648277 20251129071829_fEKeW CL0003 2025-11-30T14:30:00.875Z 2025-12-05T14:53:04.349Z
8648232 8648232 20251129070437_dvk1t CL0003 2025-11-30T14:29:58.716Z 2025-12-05T14:53:02.987Z
8647771 8647771 20251129052308_RAp2P CL0003 2025-11-30T14:28:52.723Z 2025-12-05T14:52:47.178Z
8647612 8647612 20251129045806_dTEyE CL0003 2025-11-30T14:28:39.181Z 2025-12-05T14:52:44.024Z
8647479 8647479 20251129044148_xtcSk CL0003 2025-11-30T14:28:28.874Z 2025-12-05T14:52:41.043Z
8647173 8647173 20251129035623_bUC9t CL0003 2025-11-30T14:27:47.299Z 2025-12-05T14:52:34.690Z
8646310 8646310 20251129014422_sIoFR CL0003 2025-11-30T14:25:49.460Z 2025-12-05T14:51:39.103Z
8638387 8638387 20251129083557_HwLUQ CL0003 2025-11-30T14:00:46.151Z 2025-12-05T14:37:14.538Z
8638011 8638011 20251128075733_yHNP6 CL0003 2025-11-29T14:28:24.525Z 2025-12-05T15:00:42.917Z
8637807 8637807 20251128064556_poT3g CL0003 2025-11-29T14:27:53.546Z 2025-12-05T15:00:28.895Z
8637350 8637350 20251128053121_h9YMD CL0003 2025-11-29T14:27:06.338Z 2025-12-05T14:59:42.532Z
8637308 8637308 20251128052811_84Nfw CL0003 2025-11-29T14:27:04.338Z 2025-12-05T14:59:40.230Z
8637178 8637178 20251128051134_4wtzu CL0003 2025-11-29T14:26:56.197Z 2025-12-05T14:59:38.303Z
8636926 8636926 20251128043842_XQ2qp CL0003 2025-11-29T14:26:20.992Z 2025-12-05T14:59:32.008Z
8636873 8636873 20251128043146_8BkTC CL0003 2025-11-29T14:26:17.131Z 2025-12-05T14:59:31.043Z
8636502 8636502 20251128035250_IG81D CL0003 2025-11-29T14:25:35.267Z 2025-12-05T14:59:25.098Z
8635922 8635922 20251128025901_7LV2I CL0003 2025-11-29T14:24:26.855Z 2025-12-05T14:59:16.582Z
8634766 8634766 20251128011707_fRLzt CL0003 2025-11-29T14:22:02.446Z 2025-12-05T14:58:24.682Z
8625191 8625191 20251127082950_fWyK2 CL0003 2025-11-28T14:26:24.337Z 2025-12-05T15:05:47.072Z
8625139 8625139 20251127081221_TQaZx CL0003 2025-11-28T14:26:17.713Z 2025-12-05T15:05:42.911Z
8625120 8625120 20251127080809_P7j0g CL0003 2025-11-28T14:26:16.347Z 2025-12-05T15:05:42.470Z
8624951 8624951 20251127071527_d0cV6 CL0003 2025-11-28T14:26:02.819Z 2025-12-05T15:05:33.193Z
8624805 8624805 20251127064206_gOAuk CL0003 2025-11-28T14:25:31.261Z 2025-12-05T15:05:28.691Z
8624770 8624770 20251127063009_lXtIW CL0003 2025-11-28T14:25:28.317Z 2025-12-05T15:05:27.957Z
8624697 8624697 20251127060509_5FGCk CL0003 2025-11-28T14:25:20.779Z 2025-12-05T15:05:23.976Z
8624596 8624596 20251127053234_t5p23 CL0003 2025-11-28T14:25:11.652Z 2025-12-05T15:05:15.995Z
8624419 8624419 20251127044423_Mmenm CL0003 2025-11-28T14:24:38.851Z 2025-12-05T15:05:04.690Z
8624185 8624185 20251127033325_MmdKG CL0003 2025-11-28T14:23:57.509Z 2025-12-05T15:04:54.008Z
8624169 8624169 20251127032405_EZDuy CL0003 2025-11-28T14:23:54.240Z 2025-12-05T15:04:49.225Z
8623740 8623740 20251127015151_bwpkh CL0003 2025-11-28T14:22:46.555Z 2025-12-05T15:04:14.529Z
8616996 8616996 20251126080339_PDiR3 CL0003 2025-11-27T14:32:05.415Z 2025-12-04T15:11:55.029Z
8616811 8616811 20251126063721_QmZ92 CL0003 2025-11-27T14:31:51.343Z 2025-12-04T15:11:43.784Z
8616809 8616809 20251126063548_SCvjD CL0003 2025-11-27T14:31:51.064Z 2025-12-04T15:11:43.717Z
8616077 8616077 20251126053642_CzBdM CL0003 2025-11-27T14:30:28.632Z 2025-12-04T15:11:35.286Z
8615520 8615520 20251126050732_ASfFH CL0003 2025-11-27T14:29:38.921Z 2025-12-04T15:11:29.944Z

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