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 = "SI0002" 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
8675835 8675835 20251202051735_uFqC8 SI0002 2025-12-03T14:24:24.707Z 2025-12-06T14:35:01.701Z
8675493 8675493 20251202044958_GV12X SI0002 2025-12-03T14:23:47.220Z 2025-12-06T14:34:54.727Z
8675426 8675426 20251202043751_fKzt3 SI0002 2025-12-03T14:23:42.343Z 2025-12-06T14:34:52.457Z
8665706 8665706 20251201035113_LZWJE SI0002 2025-12-02T14:24:20.993Z 2025-12-06T14:41:46.634Z
8665667 8665667 20251201034901_kxzlt SI0002 2025-12-02T14:24:17.907Z 2025-12-06T14:41:45.362Z
8656823 8656823 20251130051057_o5ZGM SI0002 2025-12-01T14:29:03.143Z 2025-12-06T14:49:41.833Z
8656720 8656720 20251130050721_iKOwy SI0002 2025-12-01T14:28:57.940Z 2025-12-01T14:28:57.940Z
8656719 8656719 20251130050659_9KJrR SI0002 2025-12-01T14:28:57.595Z 2025-12-06T14:49:39.181Z
8656616 8656616 20251130050210_QVMVd SI0002 2025-12-01T14:28:48.420Z 2025-12-06T14:49:37.068Z
8656614 8656614 20251130050138_L6QYH SI0002 2025-12-01T14:28:48.073Z 2025-12-01T14:28:48.073Z
8656528 8656528 20251130045743_6c7ox SI0002 2025-12-01T14:28:43.130Z 2025-12-06T14:49:35.538Z
8656524 8656524 20251130045743_NaDgw SI0002 2025-12-01T14:28:42.852Z 2025-12-06T14:49:35.453Z
8656410 8656410 20251130045422_DwRpC SI0002 2025-12-01T14:28:36.832Z 2025-12-06T14:49:34.521Z
8656290 8656290 20251130044755_Z5zrh SI0002 2025-12-01T14:28:18.163Z 2025-12-06T14:49:33.200Z
8656249 8656249 20251130044521_bRlH2 SI0002 2025-12-01T14:28:13.481Z 2025-12-01T14:28:13.481Z
8656234 8656234 20251130044511_I8yU2 SI0002 2025-12-01T14:28:12.759Z 2025-12-06T14:49:32.584Z
8656222 8656222 20251130044359_BBO42 SI0002 2025-12-01T14:28:11.183Z 2025-12-06T14:49:32.323Z
8656090 8656090 20251130043641_uNedL SI0002 2025-12-01T14:28:02.539Z 2025-12-06T14:49:30.615Z
8656054 8656054 20251130043227_31Vw1 SI0002 2025-12-01T14:27:59.323Z 2025-12-01T14:27:59.323Z
8655922 8655922 20251130042511_nTfMM SI0002 2025-12-01T14:27:40.830Z 2025-12-06T14:49:29.149Z
8655917 8655917 20251130042439_X0u0e SI0002 2025-12-01T14:27:40.442Z 2025-12-06T14:49:29.136Z
8655889 8655889 20251130042313_y6wqk SI0002 2025-12-01T14:27:36.036Z 2025-12-01T14:27:36.036Z
8655862 8655862 20251130042059_vllbI SI0002 2025-12-01T14:27:33.202Z 2025-12-06T14:49:28.564Z
8655798 8655798 20251130041927_mly3M SI0002 2025-12-01T14:27:30.281Z 2025-12-06T14:49:28.057Z
8655779 8655779 20251130041732_GFJgr SI0002 2025-12-01T14:27:28.244Z 2025-12-06T14:49:27.738Z
8655512 8655512 20251130040544_WHyeY SI0002 2025-12-01T14:27:01.534Z 2025-12-06T14:49:24.613Z
8655352 8655352 20251130035629_2lXpR SI0002 2025-12-01T14:26:49.416Z 2025-12-06T14:49:09.071Z
8655076 8655076 20251130034256_ytO3H SI0002 2025-12-01T14:26:22.067Z 2025-12-06T14:48:51.342Z
8654985 8654985 20251130034017_mV7Yd SI0002 2025-12-01T14:26:14.075Z 2025-12-06T14:48:50.592Z
8654773 8654773 20251130033224_jaBFJ SI0002 2025-12-01T14:25:59.920Z 2025-12-01T14:25:59.920Z
8654709 8654709 20251130032807_NAdg1 SI0002 2025-12-01T14:25:46.414Z 2025-12-06T14:48:46.144Z
8654677 8654677 20251130032514_tSNd4 SI0002 2025-12-01T14:25:43.075Z 2025-12-06T14:48:45.579Z
8654644 8654644 20251130032439_pSqc3 SI0002 2025-12-01T14:25:40.371Z 2025-12-01T14:25:40.371Z
8654636 8654636 20251130032402_3WXfF SI0002 2025-12-01T14:25:39.312Z 2025-12-06T14:48:45.212Z
8654448 8654448 20251130031707_ivCKo SI0002 2025-12-01T14:25:26.390Z 2025-12-06T14:48:42.778Z
8654322 8654322 20251130031045_T7lN5 SI0002 2025-12-01T14:25:09.041Z 2025-12-06T14:48:40.791Z
8654317 8654317 20251130031031_bvoai SI0002 2025-12-01T14:25:08.791Z 2025-12-06T14:48:40.757Z
8654290 8654290 20251130030730_7HtKI SI0002 2025-12-01T14:25:04.311Z 2025-12-06T14:48:39.947Z
8654176 8654176 20251130030234_nZv7p SI0002 2025-12-01T14:24:56.669Z 2025-12-06T14:48:38.457Z
8654076 8654076 20251130025554_PSSUN SI0002 2025-12-01T14:24:48.678Z 2025-12-06T14:48:36.792Z
8653575 8653575 20251130022558_fmrzD SI0002 2025-12-01T14:23:43.014Z 2025-12-06T14:48:16.046Z
8653557 8653557 20251130022514_aqVJC SI0002 2025-12-01T14:23:41.779Z 2025-12-06T14:48:13.870Z
8653504 8653504 20251130022124_LKCfT SI0002 2025-12-01T14:23:37.079Z 2025-12-06T14:48:04.390Z
8653204 8653204 20251130020201_axh4v SI0002 2025-12-01T14:23:03.705Z 2025-12-06T14:47:51.454Z
8653101 8653101 20251130015559_1TWDx SI0002 2025-12-01T14:22:48.771Z 2025-12-06T14:47:50.018Z
8653004 8653004 20251130014958_6m70S SI0002 2025-12-01T14:22:38.061Z 2025-12-06T14:47:47.522Z
8652997 8652997 20251130014955_F7lVr SI0002 2025-12-01T14:22:37.574Z 2025-12-06T14:47:47.465Z
8652951 8652951 20251130014612_y9iGE SI0002 2025-12-01T14:22:34.262Z 2025-12-06T14:47:46.633Z
8652924 8652924 20251130014558_4JH8n SI0002 2025-12-01T14:22:31.636Z 2025-12-06T14:47:46.201Z
8652920 8652920 20251130014557_UiAHD SI0002 2025-12-01T14:22:31.089Z 2025-12-06T14:47:46.003Z
8652808 8652808 20251130013525_ovCkU SI0002 2025-12-01T14:22:08.942Z 2025-12-06T14:47:42.770Z
8652798 8652798 20251130013438_tKL3x SI0002 2025-12-01T14:22:07.803Z 2025-12-06T14:47:42.611Z
8652792 8652792 20251130013437_VdUCD SI0002 2025-12-01T14:22:07.459Z 2025-12-06T14:47:42.571Z
8652759 8652759 20251130013210_8qMgT SI0002 2025-12-01T14:22:05.423Z 2025-12-06T14:47:42.155Z
8652405 8652405 20251130010652_srzaH SI0002 2025-12-01T14:21:21.079Z 2025-12-06T14:47:36.674Z
8652401 8652401 20251130010640_u4Xae SI0002 2025-12-01T14:21:20.777Z 2025-12-06T14:47:36.636Z
8652360 8652360 20251130010401_QbYxw SI0002 2025-12-01T14:21:18.070Z 2025-12-06T14:47:36.130Z
8652356 8652356 20251130010401_PzaA0 SI0002 2025-12-01T14:21:17.699Z 2025-12-06T14:47:36.021Z
8652292 8652292 20251130010208_gCKke SI0002 2025-12-01T14:21:14.044Z 2025-12-06T14:47:34.153Z
8652233 8652233 20251130005703_QCgpF SI0002 2025-12-01T14:20:57.606Z 2025-12-06T14:47:32.365Z
8652224 8652224 20251130005551_J00Jx SI0002 2025-12-01T14:20:56.475Z 2025-12-06T14:47:31.814Z
8652141 8652141 20251130004916_gaP5F SI0002 2025-12-01T14:20:47.539Z 2025-12-06T14:47:23.401Z
8652137 8652137 20251130004916_3358G SI0002 2025-12-01T14:20:47.232Z 2025-12-06T14:47:22.697Z
8651838 8651838 20251130002505_wYs2W SI0002 2025-12-01T14:20:06.942Z 2025-12-06T14:46:54.923Z
8651553 8651553 20251129235422_BXHVk SI0002 2025-12-01T14:19:19.675Z 2025-12-06T14:46:48.257Z
8651405 8651405 20251129233815_NwXk2 SI0002 2025-12-01T14:18:59.175Z 2025-12-06T14:46:45.488Z
8651371 8651371 20251129233330_r5MD4 SI0002 2025-12-01T14:18:54.267Z 2025-12-06T14:46:44.948Z
8650263 8650263 20251129194657_jA6hf SI0002 2025-12-01T14:15:40.273Z 2025-12-06T14:45:53.156Z
8649905 8649905 20251129185001_IKxtq SI0002 2025-12-01T14:14:17.357Z 2025-12-06T14:45:42.715Z
8649832 8649832 20251129183709_gIRGt SI0002 2025-12-01T14:14:05.132Z 2025-12-06T14:45:40.923Z
8649408 8649408 20251129172216_ZyERs SI0002 2025-12-01T14:12:27.347Z 2025-12-06T14:45:15.913Z
8649212 8649212 20251129164033_gthnD SI0002 2025-12-01T14:11:27.710Z 2025-12-06T14:44:51.427Z
8647742 8647742 20251129051821_Ldjam SI0002 2025-11-30T14:28:50.284Z 2025-12-06T14:56:46.154Z
8647695 8647695 20251129050809_guSvf SI0002 2025-11-30T14:28:45.252Z 2025-12-06T14:56:44.167Z
8647680 8647680 20251129050724_4oGcN SI0002 2025-11-30T14:28:44.600Z 2025-12-06T14:56:43.056Z
8647654 8647654 20251129050217_IYXEu SI0002 2025-11-30T14:28:41.903Z 2025-12-06T14:56:42.609Z
8647634 8647634 20251129045924_ozQrc SI0002 2025-11-30T14:28:40.434Z 2025-12-06T14:56:42.320Z
8647582 8647582 20251129045232_vdIOo SI0002 2025-11-30T14:28:36.826Z 2025-12-06T14:56:41.552Z
8647570 8647570 20251129045221_vXQ3A SI0002 2025-11-30T14:28:36.142Z 2025-12-06T14:56:41.396Z
8647547 8647547 20251129044927_4hoBX SI0002 2025-11-30T14:28:34.893Z 2025-12-06T14:56:41.021Z
8647544 8647544 20251129044840_rBFiY SI0002 2025-11-30T14:28:34.548Z 2025-12-06T14:56:40.955Z
8647522 8647522 20251129044650_C2ATd SI0002 2025-11-30T14:28:32.389Z 2025-12-06T14:56:40.452Z
8647515 8647515 20251129044638_rn4b6 SI0002 2025-11-30T14:28:31.880Z 2025-12-06T14:56:40.329Z
8647473 8647473 20251129044014_PSHwZ SI0002 2025-11-30T14:28:28.438Z 2025-12-06T14:56:39.563Z
8647462 8647462 20251129043900_fwttM SI0002 2025-11-30T14:28:27.604Z 2025-12-06T14:56:39.458Z
8647454 8647454 20251129043809_J6nQ7 SI0002 2025-11-30T14:28:27.027Z 2025-12-06T14:56:39.357Z
8647442 8647442 20251129043640_lCBx5 SI0002 2025-11-30T14:28:26.235Z 2025-12-06T14:56:39.182Z
8647423 8647423 20251129043331_kIAzr SI0002 2025-11-30T14:28:10.480Z 2025-12-06T14:56:38.681Z
8647411 8647411 20251129043220_jOtRE SI0002 2025-11-30T14:28:07.691Z 2025-12-06T14:56:38.318Z
8647407 8647407 20251129043207_LkTYv SI0002 2025-11-30T14:28:06.869Z 2025-12-06T14:56:38.219Z
8647304 8647304 20251129041816_l2dh9 SI0002 2025-11-30T14:27:57.794Z 2025-12-06T14:56:36.233Z
8647219 8647219 20251129040633_CHImE SI0002 2025-11-30T14:27:51.655Z 2025-12-06T14:56:34.050Z
8647155 8647155 20251129035302_zepIY SI0002 2025-11-30T14:27:45.701Z 2025-12-06T14:56:32.921Z
8647084 8647084 20251129033732_2u2I8 SI0002 2025-11-30T14:27:28.359Z 2025-12-06T14:56:31.380Z
8647059 8647059 20251129033428_Xp3L9 SI0002 2025-11-30T14:27:23.341Z 2025-12-06T14:56:31.049Z
8647044 8647044 20251129033223_TEdlR SI0002 2025-11-30T14:27:22.209Z 2025-12-06T14:56:30.751Z
8647039 8647039 20251129033043_rr30U SI0002 2025-11-30T14:27:21.733Z 2025-12-06T14:56:30.701Z
8647037 8647037 20251129033029_fj7kX SI0002 2025-11-30T14:27:21.461Z 2025-12-06T14:56:30.608Z
8647019 8647019 20251129032723_EWXO0 SI0002 2025-11-30T14:27:17.897Z 2025-12-06T14:56:29.855Z
8647009 8647009 20251129032547_MgwuA SI0002 2025-11-30T14:27:15.655Z 2025-12-06T14:56:29.639Z

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