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

5,234 rows where station_code = "SI0006" 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
8675836 8675836 20251202051735_uFqC8 SI0006 2025-12-03T14:24:24.707Z 2025-12-05T14:28:41.907Z
8661768 8661768 20251130170944_jCEbB SI0006 2025-12-02T14:12:58.695Z 2025-12-05T14:32:35.052Z
8661641 8661641 20251130163826_m5vfc SI0006 2025-12-02T14:12:26.372Z 2025-12-05T14:32:28.491Z
8656824 8656824 20251130051057_o5ZGM SI0006 2025-12-01T14:29:03.144Z 2025-12-05T14:45:21.777Z
8656782 8656782 20251130050927_l8BiZ SI0006 2025-12-01T14:29:00.124Z 2025-12-05T14:45:21.120Z
8656721 8656721 20251130050721_iKOwy SI0006 2025-12-01T14:28:57.940Z 2025-12-01T14:28:57.940Z
8656229 8656229 20251130044436_Mlg2m SI0006 2025-12-01T14:28:12.117Z 2025-12-01T14:28:12.117Z
8656169 8656169 20251130044126_zRduq SI0006 2025-12-01T14:28:07.979Z 2025-12-05T14:44:47.293Z
8656091 8656091 20251130043641_uNedL SI0006 2025-12-01T14:28:02.539Z 2025-12-05T14:44:45.562Z
8655785 8655785 20251130041756_s32Ui SI0006 2025-12-01T14:27:28.741Z 2025-12-05T14:44:39.010Z
8655780 8655780 20251130041732_GFJgr SI0006 2025-12-01T14:27:28.244Z 2025-12-05T14:44:38.875Z
8655737 8655737 20251130041407_lFYXJ SI0006 2025-12-01T14:27:24.032Z 2025-12-05T14:44:37.773Z
8655513 8655513 20251130040544_WHyeY SI0006 2025-12-01T14:27:01.534Z 2025-12-05T14:44:34.687Z
8655376 8655376 20251130035934_fWbHb SI0006 2025-12-01T14:26:51.744Z 2025-12-05T14:44:33.026Z
8655077 8655077 20251130034256_ytO3H SI0006 2025-12-01T14:26:22.067Z 2025-12-05T14:44:27.704Z
8654940 8654940 20251130033846_W3RN7 SI0006 2025-12-01T14:26:11.572Z 2025-12-05T14:44:26.057Z
8654928 8654928 20251130033838_LEoOj SI0006 2025-12-01T14:26:10.879Z 2025-12-05T14:44:25.963Z
8654710 8654710 20251130032807_NAdg1 SI0006 2025-12-01T14:25:46.414Z 2025-12-05T14:44:21.857Z
8654645 8654645 20251130032439_pSqc3 SI0006 2025-12-01T14:25:40.371Z 2025-12-01T14:25:40.371Z
8654585 8654585 20251130032056_727Uf SI0006 2025-12-01T14:25:35.602Z 2025-12-05T14:44:12.518Z
8652998 8652998 20251130014955_F7lVr SI0006 2025-12-01T14:22:37.574Z 2025-12-05T14:42:58.868Z
8652680 8652680 20251130012647_X7tjv SI0006 2025-12-01T14:21:58.405Z 2025-12-05T14:42:50.028Z
8652293 8652293 20251130010208_gCKke SI0006 2025-12-01T14:21:14.044Z 2025-12-05T14:42:41.819Z
8652145 8652145 20251130005046_oYB08 SI0006 2025-12-01T14:20:48.488Z 2025-12-05T14:42:26.868Z
8652052 8652052 20251130004331_fdDIn SI0006 2025-12-01T14:20:31.993Z 2025-12-05T14:42:14.447Z
8651839 8651839 20251130002505_wYs2W SI0006 2025-12-01T14:20:06.942Z 2025-12-05T14:42:07.633Z
8651554 8651554 20251129235422_BXHVk SI0006 2025-12-01T14:19:19.676Z 2025-12-05T14:42:00.239Z
8651388 8651388 20251129233542_37qZg SI0006 2025-12-01T14:18:57.967Z 2025-12-05T14:41:56.887Z
8651325 8651325 20251129232716_5kI22 SI0006 2025-12-01T14:18:45.380Z 2025-12-05T14:41:55.040Z
8651284 8651284 20251129232108_vrL74 SI0006 2025-12-01T14:18:33.272Z 2025-12-05T14:41:53.786Z
8651103 8651103 20251129224217_Ku2T4 SI0006 2025-12-01T14:18:00.675Z 2025-12-05T14:41:49.028Z
8650981 8650981 20251129222012_SmuLd SI0006 2025-12-01T14:17:42.058Z 2025-12-05T14:41:24.628Z
8650960 8650960 20251129221159_H6B92 SI0006 2025-12-01T14:17:37.593Z 2025-12-05T14:41:23.637Z
8650800 8650800 20251129213320_ctvcX SI0006 2025-12-01T14:17:12.061Z 2025-12-05T14:41:17.846Z
8650792 8650792 20251129212808_JYQ9M SI0006 2025-12-01T14:17:11.176Z 2025-12-05T14:41:17.662Z
8650697 8650697 20251129211023_TeWyK SI0006 2025-12-01T14:16:58.357Z 2025-12-05T14:41:14.888Z
8650421 8650421 20251129201144_Vsaot SI0006 2025-12-01T14:16:08.591Z 2025-12-05T14:41:06.645Z
8650150 8650150 20251129192919_TuY9C SI0006 2025-12-01T14:15:14.618Z 2025-12-05T14:40:57.610Z
8650025 8650025 20251129190801_BYx2f SI0006 2025-12-01T14:14:43.430Z 2025-12-05T14:40:50.020Z
8649950 8649950 20251129185636_2oaRo SI0006 2025-12-01T14:14:32.590Z 2025-12-05T14:40:38.383Z
8649597 8649597 20251129175347_9GFSP SI0006 2025-12-01T14:13:11.974Z 2025-12-05T14:40:14.161Z
8649251 8649251 20251129165046_UkDg3 SI0006 2025-12-01T14:11:46.621Z 2025-12-05T14:40:02.254Z
8647743 8647743 20251129051821_Ldjam SI0006 2025-11-30T14:28:50.284Z 2025-12-05T14:52:46.639Z
8647604 8647604 20251129045544_PGxha SI0006 2025-11-30T14:28:38.507Z 2025-12-05T14:52:43.830Z
8647571 8647571 20251129045221_vXQ3A SI0006 2025-11-30T14:28:36.142Z 2025-12-05T14:52:43.097Z
8647523 8647523 20251129044650_C2ATd SI0006 2025-11-30T14:28:32.389Z 2025-12-05T14:52:41.960Z
8647512 8647512 20251129044602_r3u3S SI0006 2025-11-30T14:28:31.497Z 2025-12-05T14:52:41.722Z
8647463 8647463 20251129043900_fwttM SI0006 2025-11-30T14:28:27.604Z 2025-12-05T14:52:40.793Z
8647459 8647459 20251129043859_DdNIg SI0006 2025-11-30T14:28:27.568Z 2025-12-05T14:52:40.737Z
8647424 8647424 20251129043331_kIAzr SI0006 2025-11-30T14:28:10.480Z 2025-12-05T14:52:39.877Z
8647413 8647413 20251129043220_NkCaD SI0006 2025-11-30T14:28:07.975Z 2025-12-05T14:52:39.479Z
8647372 8647372 20251129042823_7kMX6 SI0006 2025-11-30T14:28:03.854Z 2025-12-05T14:52:38.648Z
8647244 8647244 20251129041214_8UopW SI0006 2025-11-30T14:27:53.091Z 2025-12-05T14:52:36.024Z
8647060 8647060 20251129033428_Xp3L9 SI0006 2025-11-30T14:27:23.342Z 2025-12-05T14:52:32.073Z
8647013 8647013 20251129032612_jrosE SI0006 2025-11-30T14:27:16.745Z 2025-12-05T14:52:19.164Z
8646935 8646935 20251129031459_ktHkt SI0006 2025-11-30T14:27:08.863Z 2025-12-05T14:52:03.480Z
8646851 8646851 20251129030121_2rG6K SI0006 2025-11-30T14:27:01.696Z 2025-12-05T14:51:55.322Z
8646808 8646808 20251129025733_BvzYf SI0006 2025-11-30T14:26:59.212Z 2025-12-05T14:51:54.658Z
8646800 8646800 20251129025711_L6YXQ SI0006 2025-11-30T14:26:58.718Z 2025-12-05T14:51:54.577Z
8646709 8646709 20251129024027_aeDkM SI0006 2025-11-30T14:26:41.311Z 2025-12-05T14:51:48.992Z
8646513 8646513 20251129021325_cgEPr SI0006 2025-11-30T14:26:05.966Z 2025-12-05T14:51:43.601Z
8646340 8646340 20251129014709_YvF3J SI0006 2025-11-30T14:25:51.735Z 2025-12-05T14:51:39.685Z
8646258 8646258 20251129013354_O7dL3 SI0006 2025-11-30T14:25:44.717Z 2025-12-05T14:51:37.340Z
8646061 8646061 20251129005720_Y8S7l SI0006 2025-11-30T14:25:07.527Z 2025-12-05T14:51:31.932Z
8645923 8645923 20251129002834_ApX9K SI0006 2025-11-30T14:24:55.263Z 2025-12-05T14:51:28.370Z
8645868 8645868 20251129000655_w2Fj9 SI0006 2025-11-30T14:24:38.322Z 2025-12-05T14:51:26.746Z
8645832 8645832 20251128235932_gKscy SI0006 2025-11-30T14:24:36.234Z 2025-12-05T14:51:21.092Z
8645440 8645440 20251128221057_k5Kba SI0006 2025-11-30T14:23:44.374Z 2025-12-05T14:50:38.996Z
8645396 8645396 20251128215634_go11f SI0006 2025-11-30T14:23:39.908Z 2025-12-05T14:50:38.224Z
8645102 8645102 20251128203651_nX2Kc SI0006 2025-11-30T14:23:03.147Z 2025-12-05T14:50:31.749Z
8644892 8644892 20251128201200_lRfmS SI0006 2025-11-30T14:22:50.543Z 2025-12-05T14:50:28.852Z
8644727 8644727 20251128194910_YQh7z SI0006 2025-11-30T14:22:21.377Z 2025-12-05T14:50:26.256Z
8644583 8644583 20251128193435_9E4w0 SI0006 2025-11-30T14:22:07.114Z 2025-12-05T14:50:23.976Z
8643844 8643844 20251128183057_iaxu3 SI0006 2025-11-30T14:20:44.402Z 2025-12-05T14:49:48.595Z
8643410 8643410 20251128175218_LBBeF SI0006 2025-11-30T14:19:59.592Z 2025-12-05T14:49:17.398Z
8637050 8637050 20251128045513_hqpLr SI0006 2025-11-29T14:26:47.855Z 2025-12-05T14:59:36.548Z
8636709 8636709 20251128041910_aJWiw SI0006 2025-11-29T14:26:06.789Z 2025-12-05T14:59:28.439Z
8636612 8636612 20251128040901_dSLjk SI0006 2025-11-29T14:25:44.937Z 2025-12-05T14:59:26.793Z
8636563 8636563 20251128040433_k3l2x SI0006 2025-11-29T14:25:42.469Z 2025-12-05T14:59:26.164Z
8636554 8636554 20251128040023_b5vqa SI0006 2025-11-29T14:25:39.649Z 2025-12-05T14:59:26.034Z
8636395 8636395 20251128034142_3GAiv SI0006 2025-11-29T14:25:26.998Z 2025-12-05T14:59:23.544Z
8636155 8636155 20251128032310_zmQ2J SI0006 2025-11-29T14:24:58.502Z 2025-12-05T14:59:20.476Z
8636140 8636140 20251128032115_9LOZB SI0006 2025-11-29T14:24:57.439Z 2025-12-05T14:59:20.207Z
8636084 8636084 20251128031420_MYSuT SI0006 2025-11-29T14:24:52.650Z 2025-12-05T14:59:19.037Z
8636066 8636066 20251128031229_aQ5Fu SI0006 2025-11-29T14:24:51.359Z 2025-12-05T14:59:18.808Z
8636048 8636048 20251128031019_m2pPN SI0006 2025-11-29T14:24:50.421Z 2025-12-05T14:59:18.707Z
8635990 8635990 20251128030412_bfLBr SI0006 2025-11-29T14:24:44.162Z 2025-12-05T14:59:17.643Z
8635940 8635940 20251128030035_1R8a0 SI0006 2025-11-29T14:24:40.296Z 2025-12-05T14:59:17.066Z
8635930 8635930 20251128025922_4yzXr SI0006 2025-11-29T14:24:36.162Z 2025-12-05T14:59:16.834Z
8635883 8635883 20251128025552_YYpA3 SI0006 2025-11-29T14:24:19.782Z 2025-12-05T14:59:15.932Z
8635870 8635870 20251128025501_qqMVl SI0006 2025-11-29T14:24:17.949Z 2025-12-05T14:59:15.788Z
8635717 8635717 20251128024031_vY9kI SI0006 2025-11-29T14:24:03.543Z 2025-12-05T14:59:13.540Z
8635694 8635694 20251128023820_uCbjx SI0006 2025-11-29T14:24:01.523Z 2025-12-05T14:59:13.197Z
8635606 8635606 20251128023141_e1oSb SI0006 2025-11-29T14:23:55.737Z 2025-12-05T14:59:10.428Z
8635572 8635572 20251128022718_uiRDn SI0006 2025-11-29T14:23:42.094Z 2025-12-05T14:59:05.745Z
8635561 8635561 20251128022637_BVWYe SI0006 2025-11-29T14:23:40.955Z 2025-12-05T14:59:04.388Z
8635468 8635468 20251128021541_CKntC SI0006 2025-11-29T14:23:26.993Z 2025-12-05T14:58:44.115Z
8635380 8635380 20251128020821_UHyD1 SI0006 2025-11-29T14:23:18.384Z 2025-12-05T14:58:34.588Z
8635220 8635220 20251128015338_T2A0Q SI0006 2025-11-29T14:22:51.082Z 2025-12-05T14:58:32.366Z
8635120 8635120 20251128014307_h9AoN SI0006 2025-11-29T14:22:41.607Z 2025-12-05T14:58:30.643Z

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