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

858 rows where station_code = "US004L" 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
9583036 9583036 20260326103812_QKUdU US004L 2026-03-27T12:07:28.415Z 2026-04-04T12:40:42.277Z
9582798 9582798 20260326093007_p4a5O US004L 2026-03-27T12:06:49.993Z 2026-04-04T12:40:28.908Z
9556146 9556146 20260322092723_hjgtG US004L 2026-03-23T12:04:24.230Z 2026-03-30T12:28:45.962Z
9543799 9543799 20260321053223_OBIj3 US004L 2026-03-22T12:04:47.907Z 2026-03-29T12:19:11.445Z
9542949 9542949 20260321020150_qqX2D US004L 2026-03-22T12:02:10.339Z 2026-03-29T12:19:00.679Z
9542412 9542412 20260316091201_hQ2eT US004L 2026-03-21T12:40:02.216Z 2026-03-24T12:41:16.673Z
9536394 9536394 20260320094429_sy33K US004L 2026-03-21T12:13:17.246Z 2026-03-28T12:35:01.175Z
9524162 9524162 20260319112530_XuPh2 US004L 2026-03-20T12:12:32.170Z 2026-03-27T12:41:49.211Z
9523349 9523349 20260319095113_Mi7N3 US004L 2026-03-20T12:11:15.178Z 2026-03-27T12:41:27.910Z
9496129 9496129 20260316103801_OjG5j US004L 2026-03-17T12:09:08.594Z 2026-03-24T12:41:18.440Z
9471753 9471753 20260313112922_BF2oW US004L 2026-03-14T12:11:20.221Z 2026-03-21T12:49:42.721Z
9466023 9466023 20260312113747_s9o78 US004L 2026-03-13T12:11:17.113Z 2026-03-20T12:37:07.123Z
9465549 9465549 20260312102313_JTKW9 US004L 2026-03-13T12:10:13.840Z 2026-03-20T12:37:04.887Z
9447760 9447760 20260309084351_G34Ol US004L 2026-03-10T12:07:44.091Z 2026-03-17T12:41:56.354Z
9442811 9442811 20260308062629_njMuD US004L 2026-03-09T12:05:38.267Z 2026-03-16T12:43:57.274Z
9404278 9404278 20260227115308_IvHVq US004L 2026-02-28T14:10:26.756Z 2026-03-07T14:48:42.625Z
9404156 9404156 20260227114237_T6QJp US004L 2026-02-28T14:10:08.002Z 2026-03-07T14:48:37.768Z
9403927 9403927 20260227110220_eYf21 US004L 2026-02-28T14:09:30.430Z 2026-03-07T14:48:20.496Z
9403581 9403581 20260227101413_7ZwYe US004L 2026-02-28T14:08:38.568Z 2026-03-07T14:48:00.253Z
9403347 9403347 20260227091649_SDoms US004L 2026-02-28T14:08:00.549Z 2026-03-07T14:47:48.007Z
9374706 9374706 20260223092449_sUnn9 US004L 2026-02-24T14:06:46.888Z 2026-03-03T14:31:34.652Z
9366728 9366728 20260222102346_OiTxg US004L 2026-02-23T14:08:25.869Z 2026-02-24T14:16:35.187Z
9366004 9366004 20260222080914_MFOXF US004L 2026-02-23T14:05:59.847Z 2026-02-24T14:15:53.241Z
9365813 9365813 20260222062754_8E2oN US004L 2026-02-23T14:05:13.674Z 2026-02-24T14:15:40.469Z
9353463 9353463 20260220105440_JayAd US004L 2026-02-21T14:04:31.998Z 2026-03-01T14:21:50.143Z
9345038 9345038 20260218080837_qbDHX US004L 2026-02-20T14:01:23.437Z 2026-02-27T14:34:33.044Z
9332199 9332199 20260216105213_rlVdh US004L 2026-02-17T14:10:25.094Z 2026-02-25T14:42:07.296Z
9317236 9317236 20260212083805_JQtXE US004L 2026-02-13T14:03:56.641Z 2026-02-21T14:36:53.049Z
9314830 9314830 20260211115242_Kcv4b US004L 2026-02-12T14:05:51.421Z 2026-02-20T14:05:05.644Z
9314696 9314696 20260211112349_tykpA US004L 2026-02-12T14:04:54.099Z 2026-02-20T14:05:05.253Z
9314441 9314441 20260211102700_KGbcz US004L 2026-02-12T14:03:34.448Z 2026-02-20T14:05:04.539Z
9314367 9314367 20260211101247_B6yX8 US004L 2026-02-12T14:03:03.688Z 2026-02-20T14:05:04.397Z
9307697 9307697 20260209072100_2xUBj US004L 2026-02-10T14:03:47.219Z 2026-02-18T14:58:53.299Z
9306946 9306946 20260208024810_qa3AT US004L 2026-02-09T14:25:47.420Z 2026-02-16T15:01:16.229Z
9304065 9304065 20260208093222_Sdhn8 US004L 2026-02-09T14:06:20.843Z 2026-02-16T14:50:11.247Z
9303379 9303379 20260208051504_HxP4u US004L 2026-02-09T14:02:41.953Z 2026-02-16T14:49:08.127Z
9303089 9303089 20260208033113_e4Q9z US004L 2026-02-09T14:00:24.803Z 2026-02-17T14:27:38.706Z
9300072 9300072 20260207120528_jsywA US004L 2026-02-08T14:07:44.819Z 2026-02-16T14:57:24.304Z
9299810 9299810 20260207112201_YPKtR US004L 2026-02-08T14:06:47.885Z 2026-02-16T14:57:03.011Z
9299120 9299120 20260207083714_3DRIb US004L 2026-02-08T14:03:40.599Z 2026-02-16T14:56:09.096Z
9298965 9298965 20260207064327_22H4d US004L 2026-02-08T14:02:43.506Z 2026-02-16T14:55:50.374Z
9295770 9295770 20260206103246_AhfRj US004L 2026-02-07T14:05:40.856Z 2026-02-15T14:56:57.635Z
9263857 9263857 20260127102255_9SyN0 US004L 2026-01-28T14:03:10.570Z 2026-02-05T14:44:55.233Z
9263107 9263107 20260126071821_3TIqa US004L 2026-01-27T14:17:04.292Z 2026-02-03T14:46:42.219Z
9250214 9250214 20260123110621_T83Pw US004L 2026-01-24T14:01:42.689Z 2026-02-01T14:48:19.926Z
9238268 9238268 20260120081238_mBAd2 US004L 2026-01-21T14:29:04.129Z 2026-01-28T15:02:16.740Z
9232305 9232305 20260120110203_v87i4 US004L 2026-01-21T14:01:16.174Z 2026-01-29T14:59:24.662Z
9231825 9231825 20260119095823_0mO6B US004L 2026-01-20T14:34:26.329Z 2026-01-27T15:07:01.169Z
9231445 9231445 20260119080610_GtnY5 US004L 2026-01-20T14:32:54.026Z 2026-01-27T15:06:30.121Z
9226344 9226344 20260119114850_W7281 US004L 2026-01-20T14:02:35.494Z 2026-01-28T14:54:55.793Z
9224254 9224254 20260118040347_jHPq7 US004L 2026-01-19T14:23:37.179Z 2026-01-26T15:03:10.843Z
9214467 9214467 20260116064000_iVNwy US004L 2026-01-17T14:21:37.882Z 2026-01-24T15:13:38.650Z
9214179 9214179 20260116054955_P037M US004L 2026-01-17T14:20:27.695Z 2026-01-24T15:13:20.145Z
9209103 9209103 20260115083105_QU7o7 US004L 2026-01-16T14:15:09.471Z 2026-01-22T15:04:48.986Z
9196220 9196220 20260113053116_Sggni US004L 2026-01-14T14:17:13.137Z 2026-01-21T15:05:29.867Z
9191273 9191273 20260112105119_HHvGU US004L 2026-01-13T14:24:56.618Z 2026-01-20T15:25:16.969Z
9184899 9184899 20260111123403_83GEB US004L 2026-01-12T14:21:56.031Z 2026-01-19T15:21:20.962Z
9184621 9184621 20260111115855_IiZ1h US004L 2026-01-12T14:21:09.248Z 2026-01-19T15:21:05.928Z
9184304 9184304 20260111110846_fo23k US004L 2026-01-12T14:20:14.136Z 2026-01-19T15:20:32.585Z
9183098 9183098 20260111082819_0rBG3 US004L 2026-01-12T14:16:46.764Z 2026-01-19T15:19:26.723Z
9182833 9182833 20260111065525_9rN6d US004L 2026-01-12T14:15:53.643Z 2026-01-19T15:19:01.303Z
9182799 9182799 20260111063741_u7nyg US004L 2026-01-12T14:15:49.123Z 2026-01-19T15:19:00.243Z
9122509 9122509 20260101083445_4GkoX US004L 2026-01-02T14:13:23.545Z 2026-01-09T14:53:30.066Z
9122297 9122297 20260101052428_M2Hlv US004L 2026-01-02T14:12:16.109Z 2026-01-09T14:53:13.116Z
9117760 9117760 20251231120138_24PfL US004L 2026-01-01T14:32:52.006Z 2026-01-08T15:13:26.630Z
9117652 9117652 20251231114107_6ITjN US004L 2026-01-01T14:32:29.244Z 2026-01-01T14:57:55.628Z
9105711 9105711 20251230122502_38eMK US004L 2025-12-31T14:26:13.186Z 2026-01-07T15:11:07.839Z
9105361 9105361 20251230104659_NRyje US004L 2025-12-31T14:24:54.531Z 2026-01-07T15:10:44.276Z
9105128 9105128 20251230094508_nfGl0 US004L 2025-12-31T14:23:56.244Z 2026-01-07T15:10:23.871Z
9082035 9082035 20251229112216_jVgio US004L 2025-12-30T14:27:40.559Z 2026-01-06T15:19:41.301Z
9082017 9082017 20251229111817_oIeOD US004L 2025-12-30T14:27:35.649Z 2025-12-31T14:38:39.080Z
9081683 9081683 20251229092532_wmjF2 US004L 2025-12-30T14:26:08.392Z 2026-01-06T15:19:26.172Z
9068138 9068138 20251226112558_AY4pG US004L 2025-12-29T14:43:36.925Z 2026-01-03T15:39:31.480Z
9066916 9066916 20251226071223_OxHwm US004L 2025-12-29T14:40:42.487Z 2026-01-03T15:38:17.275Z
9059220 9059220 20251227113736_X4sYS US004L 2025-12-29T14:26:27.126Z 2026-01-04T15:31:32.815Z
9045581 9045581 20251223103314_WZ1jw US004L 2025-12-28T14:53:50.618Z 2025-12-31T15:42:52.133Z
9044901 9044901 20251223063750_qQ8sz US004L 2025-12-28T14:52:37.658Z 2025-12-31T15:42:42.010Z
9025891 9025891 20251225003451_TRj23 US004L 2025-12-28T14:06:07.939Z 2026-01-02T15:42:45.056Z
9019953 9019953 20251220110230_ZF6ni US004L 2025-12-27T15:05:06.144Z 2025-12-29T15:24:40.117Z
9019303 9019303 20251220093412_5u8T2 US004L 2025-12-27T15:03:57.253Z 2025-12-29T15:24:31.809Z
9006457 9006457 20251221061355_NRamS US004L 2025-12-27T14:37:50.070Z 2025-12-27T14:37:50.070Z
8979542 8979542 20251219115628_y1ZaR US004L 2025-12-26T14:18:49.191Z 2025-12-28T15:19:33.426Z
8978972 8978972 20251219100957_wZYG7 US004L 2025-12-26T14:17:03.649Z 2025-12-28T15:17:44.598Z
8978950 8978950 20251219100509_NiFjo US004L 2025-12-26T14:16:59.547Z 2025-12-28T15:17:44.422Z
8978812 8978812 20251219093422_Z9CKL US004L 2025-12-26T14:16:31.389Z 2025-12-28T15:17:43.200Z
8928417 8928417 20251215050042_Kr3DV US004L 2025-12-24T14:11:31.874Z 2025-12-24T15:09:31.180Z
8928413 8928413 20251215050002_W2lm3 US004L 2025-12-24T14:11:31.114Z 2025-12-24T15:09:31.175Z
8927889 8927889 20251215042918_8O3RK US004L 2025-12-24T14:09:35.402Z 2025-12-24T15:09:30.835Z
8927730 8927730 20251215041747_TW3MH US004L 2025-12-24T14:09:03.430Z 2025-12-24T15:09:30.686Z
8927265 8927265 20251215034944_LFwPr US004L 2025-12-24T14:07:19.585Z 2025-12-24T15:09:30.074Z
8924541 8924541 20251214122834_7mafx US004L 2025-12-23T14:15:37.022Z 2025-12-24T14:41:43.994Z
8923000 8923000 20251214120116_EkxDS US004L 2025-12-23T14:14:41.329Z 2025-12-23T14:28:40.496Z
8922982 8922982 20251214120038_aEbVG US004L 2025-12-23T14:14:40.663Z 2025-12-23T14:28:40.483Z
8922034 8922034 20251214114433_j6t8s US004L 2025-12-23T14:14:09.617Z 2025-12-24T14:38:51.469Z
8922007 8922007 20251214114413_d2K1L US004L 2025-12-23T14:14:06.703Z 2025-12-24T14:38:50.664Z
8921593 8921593 20251214113614_iYZfZ US004L 2025-12-23T14:13:53.257Z 2025-12-24T14:38:40.237Z
8920978 8920978 20251214112341_lT2SJ US004L 2025-12-23T14:13:27.569Z 2025-12-24T14:37:32.107Z
8920269 8920269 20251214111206_Rc00H US004L 2025-12-23T14:13:08.261Z 2025-12-24T14:37:09.501Z
8920193 8920193 20251214111110_TXWD7 US004L 2025-12-23T14:13:07.440Z 2025-12-23T14:28:38.771Z
8920114 8920114 20251214111024_1JKkf US004L 2025-12-23T14:13:06.844Z 2025-12-23T14:28:38.726Z

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