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

3,366 rows where station_code = "US0051" 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
8674321 8674321 20251202015954_Jo7tI US0051 2025-12-03T14:21:24.558Z 2025-12-06T14:34:04.306Z
8626352 8626352 20251126090129_f4RNO US0051 2025-11-28T14:38:50.141Z 2025-12-04T15:12:16.739Z
8626327 8626327 20251126085532_J2F7k US0051 2025-11-28T14:38:49.106Z 2025-12-04T15:12:16.041Z
8626312 8626312 20251126085118_lxABq US0051 2025-11-28T14:38:46.283Z 2025-12-04T15:12:14.846Z
8626285 8626285 20251126084525_EG7e6 US0051 2025-11-28T14:38:32.927Z 2025-12-04T15:12:10.830Z
8626226 8626226 20251126082024_FlobT US0051 2025-11-28T14:38:15.854Z 2025-12-04T15:12:02.128Z
8626156 8626156 20251126075646_j8xNh US0051 2025-11-28T14:37:57.204Z 2025-12-04T15:11:53.839Z
8626151 8626151 20251126075639_aFrZt US0051 2025-11-28T14:37:53.968Z 2025-12-04T15:11:53.789Z
8626093 8626093 20251126073300_B5Ko2 US0051 2025-11-28T14:37:39.647Z 2025-12-04T15:11:52.289Z
8626033 8626033 20251126070922_wRthR US0051 2025-11-28T14:37:32.438Z 2025-12-04T15:11:50.585Z
8625994 8625994 20251126065252_JZ9OH US0051 2025-11-28T14:37:29.063Z 2025-12-04T15:11:49.546Z
8625952 8625952 20251126064248_KWBR2 US0051 2025-11-28T14:37:26.738Z 2025-12-04T15:11:44.454Z
8625804 8625804 20251126053215_O35Xf US0051 2025-11-28T14:37:01.577Z 2025-12-04T15:11:34.598Z
8625770 8625770 20251126050650_0I9OP US0051 2025-11-28T14:36:26.599Z 2025-12-04T15:11:29.827Z
8625669 8625669 20251126040748_Od7XD US0051 2025-11-28T14:36:01.188Z 2025-12-04T15:10:39.673Z
8625601 8625601 20251126033059_K40PX US0051 2025-11-28T14:35:19.955Z 2025-12-04T15:09:51.067Z
8625516 8625516 20251126023236_uz366 US0051 2025-11-28T14:34:31.124Z 2025-12-04T15:09:31.011Z
8625482 8625482 20251126015537_MmwU2 US0051 2025-11-28T14:33:51.512Z 2025-12-04T15:09:23.267Z
8620249 8620249 20251126120145_dXA3w US0051 2025-11-28T14:12:05.848Z 2025-12-05T15:01:34.227Z
8620229 8620229 20251126120023_nKxM3 US0051 2025-11-28T14:12:02.967Z 2025-12-05T15:01:33.659Z
8620215 8620215 20251126115852_nm2V4 US0051 2025-11-28T14:12:00.644Z 2025-12-05T15:01:33.235Z
8619984 8619984 20251126112730_yoaG0 US0051 2025-11-28T14:11:14.565Z 2025-12-05T15:01:19.154Z
8619696 8619696 20251126104806_CI8zS US0051 2025-11-28T14:10:00.529Z 2025-12-05T15:01:04.906Z
8619659 8619659 20251126104203_Jz1Oy US0051 2025-11-28T14:09:53.607Z 2025-12-05T15:01:04.231Z
8619596 8619596 20251126103118_HOJ8S US0051 2025-11-28T14:09:35.435Z 2025-12-05T15:01:02.563Z
8619587 8619587 20251126103033_vr2ws US0051 2025-11-28T14:09:32.758Z 2025-12-05T15:01:02.472Z
8619520 8619520 20251126102223_w3doj US0051 2025-11-28T14:09:17.305Z 2025-12-05T15:01:00.847Z
8619300 8619300 20251126094704_EipG6 US0051 2025-11-28T14:08:17.954Z 2025-12-05T15:00:55.837Z
8619281 8619281 20251126094054_p5Rvj US0051 2025-11-28T14:08:13.555Z 2025-12-05T15:00:55.296Z
8619260 8619260 20251126093732_tP2PD US0051 2025-11-28T14:08:08.127Z 2025-12-05T15:00:54.647Z
8619248 8619248 20251126093636_ALaoM US0051 2025-11-28T14:08:06.503Z 2025-12-05T15:00:54.444Z
8619242 8619242 20251126093435_E2h5U US0051 2025-11-28T14:08:04.829Z 2025-12-05T15:00:54.263Z
8619175 8619175 20251126092230_VF8EU US0051 2025-11-28T14:07:42.929Z 2025-12-05T15:00:51.147Z
8619171 8619171 20251126092155_c7nVJ US0051 2025-11-28T14:07:41.449Z 2025-12-05T15:00:50.974Z
8619094 8619094 20251126090559_YbAVv US0051 2025-11-28T14:07:15.794Z 2025-12-05T15:00:48.482Z
8441620 8441620 20251112114606_c2BE5 US0051 2025-11-13T14:31:22.141Z 2025-11-20T15:26:20.021Z
8441543 8441543 20251112110434_FtYqJ US0051 2025-11-13T14:31:17.115Z 2025-11-20T15:26:16.136Z
8441410 8441410 20251112101813_Lwcor US0051 2025-11-13T14:30:48.762Z 2025-11-20T15:26:14.014Z
8441400 8441400 20251112101628_VufDi US0051 2025-11-13T14:30:47.877Z 2025-11-20T15:26:13.484Z
8441311 8441311 20251112095448_hN3hj US0051 2025-11-13T14:30:42.082Z 2025-11-20T15:26:10.516Z
8441219 8441219 20251112093038_fg1gV US0051 2025-11-13T14:30:35.141Z 2025-11-20T15:26:07.811Z
8441158 8441158 20251112091115_2EgBn US0051 2025-11-13T14:30:25.538Z 2025-11-20T15:26:04.836Z
8440469 8440469 20251112063546_pGsmO US0051 2025-11-13T14:28:54.156Z 2025-11-20T15:25:51.203Z
8440452 8440452 20251112063320_xKD2n US0051 2025-11-13T14:28:53.200Z 2025-11-20T15:25:50.763Z
8440389 8440389 20251112062359_FBfRY US0051 2025-11-13T14:28:50.295Z 2025-11-20T15:25:49.355Z
8430425 8430425 20251111123025_vlUOU US0051 2025-11-13T14:01:11.865Z 2025-11-20T15:19:30.950Z
8430341 8430341 20251111122259_E0eMp US0051 2025-11-13T14:00:51.317Z 2025-11-20T15:19:29.230Z
8430170 8430170 20251112122613_pVMFt US0051 2025-11-13T14:00:17.932Z 2025-11-21T15:10:17.262Z
8430160 8430160 20251112122346_7tVjw US0051 2025-11-13T14:00:15.524Z 2025-11-21T15:10:16.648Z
8430144 8430144 20251112121234_aznol US0051 2025-11-13T14:00:10.758Z 2025-11-21T15:10:13.676Z
8429841 8429841 20251111113210_gKvJo US0051 2025-11-12T14:45:08.146Z 2025-11-19T15:19:07.405Z
8429822 8429822 20251111112728_1iqV5 US0051 2025-11-12T14:45:07.199Z 2025-11-19T15:19:04.130Z
8429764 8429764 20251111110835_gJ06d US0051 2025-11-12T14:45:04.731Z 2025-11-19T15:18:57.980Z
8429758 8429758 20251111110735_GUWcd US0051 2025-11-12T14:45:04.069Z 2025-11-19T15:18:57.796Z
8429732 8429732 20251111110330_UlJR3 US0051 2025-11-12T14:45:02.543Z 2025-11-19T15:18:57.007Z
8429704 8429704 20251111105419_HkeHp US0051 2025-11-12T14:45:00.728Z 2025-11-19T15:18:54.100Z
8429512 8429512 20251111100958_ZKqOP US0051 2025-11-12T14:44:37.479Z 2025-11-19T15:18:44.386Z
8429424 8429424 20251111095119_IhkUf US0051 2025-11-12T14:44:21.105Z 2025-11-19T15:18:41.004Z
8429389 8429389 20251111094503_TbR32 US0051 2025-11-12T14:44:13.233Z 2025-11-19T15:18:40.247Z
8414632 8414632 20251110032116_S72IM US0051 2025-11-11T14:21:22.474Z 2025-11-18T15:21:10.357Z
8399989 8399989 20251108102405_pi4QF US0051 2025-11-09T14:19:36.677Z 2025-11-16T15:05:56.158Z
8399907 8399907 20251108101129_6PzUy US0051 2025-11-09T14:19:27.243Z 2025-11-16T15:05:55.398Z
8399903 8399903 20251108101058_JcpZN US0051 2025-11-09T14:19:26.326Z 2025-11-16T15:05:55.377Z
8399841 8399841 20251108100322_yGXQW US0051 2025-11-09T14:19:19.086Z 2025-11-16T15:05:54.899Z
8399644 8399644 20251108092524_9AGTW US0051 2025-11-09T14:18:45.338Z 2025-11-16T15:05:47.523Z
8399589 8399589 20251108091201_gqEOX US0051 2025-11-09T14:18:40.137Z 2025-11-16T15:05:46.641Z
8399576 8399576 20251108090811_hijVw US0051 2025-11-09T14:18:37.908Z 2025-11-16T15:05:46.332Z
8399315 8399315 20251108082520_oz468 US0051 2025-11-09T14:17:58.460Z 2025-11-16T15:05:37.545Z
8382573 8382573 20251105112504_43PT5 US0051 2025-11-06T14:18:15.533Z 2025-11-13T15:16:08.002Z
8382453 8382453 20251105104824_SfYrB US0051 2025-11-06T14:17:51.497Z 2025-11-13T15:16:04.551Z
8376547 8376547 20251103111547_5syLB US0051 2025-11-05T14:36:49.232Z 2025-11-11T15:08:43.551Z
8376489 8376489 20251103110302_63m8g US0051 2025-11-05T14:36:42.630Z 2025-11-11T15:08:40.791Z
8376227 8376227 20251103101749_IGm36 US0051 2025-11-05T14:36:27.156Z 2025-11-11T15:08:27.174Z
8376189 8376189 20251103101220_qIzv9 US0051 2025-11-05T14:36:23.017Z 2025-11-11T15:08:25.907Z
8376153 8376153 20251103100430_DkiXr US0051 2025-11-05T14:36:04.198Z 2025-11-11T15:08:25.489Z
8376019 8376019 20251103094105_XVmQe US0051 2025-11-05T14:35:45.772Z 2025-11-11T15:08:23.881Z
8375974 8375974 20251103093255_varuL US0051 2025-11-05T14:35:43.021Z 2025-11-11T15:08:23.496Z
8375914 8375914 20251103092207_CnQVD US0051 2025-11-05T14:35:39.150Z 2025-11-11T15:08:22.824Z
8375841 8375841 20251103091013_dw3kW US0051 2025-11-05T14:35:34.607Z 2025-11-11T15:08:21.855Z
8375724 8375724 20251103084113_q7p8V US0051 2025-11-05T14:35:24.288Z 2025-11-11T15:08:18.425Z
8375705 8375705 20251103083328_3QiGU US0051 2025-11-05T14:35:17.312Z 2025-11-11T15:08:18.133Z
8375583 8375583 20251103081324_MPw9t US0051 2025-11-05T14:35:04.605Z 2025-11-11T15:08:16.884Z
8372095 8372095 20251104071438_Pvu5G US0051 2025-11-05T14:17:15.763Z 2025-11-12T15:11:13.715Z
8372082 8372082 20251104071047_x1AK3 US0051 2025-11-05T14:17:12.141Z 2025-11-12T15:11:13.596Z
8371934 8371934 20251104062302_HVCgx US0051 2025-11-05T14:16:41.984Z 2025-11-12T15:11:11.590Z
8371888 8371888 20251104061036_5J7PS US0051 2025-11-05T14:16:36.355Z 2025-11-12T15:11:08.021Z
8371881 8371881 20251104060926_bsfZC US0051 2025-11-05T14:16:35.523Z 2025-11-12T15:11:07.950Z
8371845 8371845 20251104060017_WeSqH US0051 2025-11-05T14:16:31.403Z 2025-11-12T15:11:07.566Z
8371830 8371830 20251104055656_jKHOO US0051 2025-11-05T14:16:19.551Z 2025-11-12T15:11:07.399Z
8371805 8371805 20251104055107_QNrnu US0051 2025-11-05T14:16:13.687Z 2025-11-12T15:11:07.046Z
8371699 8371699 20251104051857_6sAZB US0051 2025-11-05T14:15:56.392Z 2025-11-12T15:11:05.351Z
8371492 8371492 20251104042639_CxKpP US0051 2025-11-05T14:15:11.527Z 2025-11-12T15:11:02.239Z
8371453 8371453 20251104042159_NcIVG US0051 2025-11-05T14:14:58.712Z 2025-11-12T15:11:01.744Z
8371382 8371382 20251104041701_MCfsp US0051 2025-11-05T14:14:45.709Z 2025-11-12T15:11:00.780Z
8371273 8371273 20251104040506_3pcT2 US0051 2025-11-05T14:14:19.607Z 2025-11-12T15:10:58.988Z
8370858 8370858 20251104031215_vE5sV US0051 2025-11-05T14:12:44.852Z 2025-11-12T15:10:52.476Z
8370610 8370610 20251104023500_K1BNS US0051 2025-11-05T14:11:48.914Z 2025-11-12T15:10:48.057Z
8357519 8357519 20251102061706_dmoIi US0051 2025-11-03T14:43:09.113Z 2025-11-10T15:09:50.055Z
8357477 8357477 20251102061213_oSHsU US0051 2025-11-03T14:43:07.533Z 2025-11-10T15:09:44.942Z
8357462 8357462 20251102060840_MORFN US0051 2025-11-03T14:43:06.731Z 2025-11-10T15:09:43.733Z

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