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

4,185 rows where station_code = "US002N" 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
9272278 9272278 20260128011002_q3jyQ US002N 2026-01-29T14:26:10.515Z 2026-01-29T14:30:25.320Z
9268007 9268007 20260128074203_DkMvS US002N 2026-01-29T14:00:23.842Z 2026-01-29T14:00:23.842Z
9264296 9264296 20260127115746_KgbMM US002N 2026-01-28T14:05:21.025Z 2026-01-29T14:30:20.845Z
9263776 9263776 20260127101004_ug91z US002N 2026-01-28T14:02:43.218Z 2026-01-29T14:30:18.933Z
9263619 9263619 20260127092559_o1Vmy US002N 2026-01-28T14:01:45.550Z 2026-01-29T14:30:16.598Z
9263564 9263564 20260127091342_3ZgLt US002N 2026-01-28T14:01:27.955Z 2026-01-29T14:30:16.571Z
9261268 9261268 20260126105414_EKvXU US002N 2026-01-27T14:02:54.143Z 2026-01-29T14:32:09.028Z
9261153 9261153 20260126100405_zUTh3 US002N 2026-01-27T14:02:15.490Z 2026-01-29T14:31:59.974Z
9249719 9249719 20260122074104_x28I4 US002N 2026-01-23T14:16:00.379Z 2026-01-29T14:58:51.440Z
9245189 9245189 20260122110539_a3dj2 US002N 2026-01-23T14:00:57.364Z 2026-01-29T14:49:13.103Z
9226410 9226410 20260119115755_e1Xyt US002N 2026-01-20T14:03:02.887Z 2026-01-28T14:54:58.827Z
9226038 9226038 20260119105258_sbmN6 US002N 2026-01-20T14:00:36.775Z 2026-01-28T14:54:29.990Z
9225998 9225998 20260119104458_58nRw US002N 2026-01-20T14:00:18.735Z 2026-01-28T14:54:28.234Z
9219080 9219080 20260117073512_DG2Au US002N 2026-01-18T14:14:53.845Z 2026-01-25T14:59:01.115Z
9210103 9210103 20260115120709_p1GQ0 US002N 2026-01-16T14:18:42.986Z 2026-01-22T15:05:48.047Z
9189978 9189978 20260112071622_Csku2 US002N 2026-01-13T14:20:10.920Z 2026-01-20T15:24:00.573Z
9009065 9009065 20251221120554_yl96W US002N 2025-12-27T14:44:02.841Z 2025-12-27T14:44:02.841Z
9006958 9006958 20251221081905_090zP US002N 2025-12-27T14:39:03.994Z 2025-12-27T14:39:03.994Z
8965000 8965000 20251216094844_uDe1y US002N 2025-12-25T14:42:52.298Z 2025-12-25T14:42:52.298Z
8964664 8964664 20251216091014_6IRB6 US002N 2025-12-25T14:42:03.784Z 2025-12-25T14:42:03.784Z
8963416 8963416 20251216052840_s3AcT US002N 2025-12-25T14:39:05.788Z 2025-12-25T14:39:05.788Z
8956333 8956333 20251217113744_Vc1rL US002N 2025-12-25T14:18:13.469Z 2025-12-26T15:00:23.660Z
8690715 8690715 20251205012734_b05NV US002N 2025-12-06T14:15:15.121Z 2025-12-13T16:04:31.499Z
8638003 8638003 20251128075650_OpV6Z US002N 2025-11-29T14:28:23.883Z 2025-12-06T15:04:06.763Z
8637916 8637916 20251128073040_DTMjd US002N 2025-11-29T14:28:09.559Z 2025-12-06T15:04:05.640Z
8637204 8637204 20251128051503_9ZJ3L US002N 2025-11-29T14:26:58.025Z 2025-12-06T15:03:57.661Z
8626399 8626399 20251128083203_52qQE US002N 2025-11-29T14:00:14.270Z 2025-12-07T14:52:12.959Z
8501486 8501486 20251116110635_Zn2BC US002N 2025-11-18T14:47:26.477Z 2025-11-24T15:06:37.346Z
8501350 8501350 20251116104944_I2L2i US002N 2025-11-18T14:47:20.952Z 2025-11-24T15:06:28.815Z
8500656 8500656 20251116093103_w6aA3 US002N 2025-11-18T14:46:27.764Z 2025-11-24T15:05:54.885Z
8500370 8500370 20251116084621_HNrfw US002N 2025-11-18T14:46:09.106Z 2025-11-24T15:05:40.341Z
8500343 8500343 20251116083449_doozz US002N 2025-11-18T14:46:05.129Z 2025-11-24T15:05:39.533Z
8500279 8500279 20251116082538_JT00g US002N 2025-11-18T14:45:49.672Z 2025-11-24T15:05:37.521Z
8500216 8500216 20251116081333_35EXK US002N 2025-11-18T14:45:39.472Z 2025-11-24T15:05:36.259Z
8500203 8500203 20251116080637_wCaVH US002N 2025-11-18T14:45:37.723Z 2025-11-24T15:05:35.693Z
8500125 8500125 20251116074503_3li9X US002N 2025-11-18T14:45:33.258Z 2025-11-24T15:05:32.679Z
8500052 8500052 20251116072518_fYxy3 US002N 2025-11-18T14:45:28.895Z 2025-11-24T15:05:30.723Z
8500028 8500028 20251116071115_vKLin US002N 2025-11-18T14:45:27.280Z 2025-11-24T15:05:30.263Z
8486678 8486678 20251116112950_cPyCT US002N 2025-11-18T14:00:29.263Z 2025-11-25T15:06:00.017Z
8486341 8486341 20251115112718_hXrlS US002N 2025-11-17T14:34:17.156Z 2025-11-23T15:20:30.658Z
8482230 8482230 20251116055049_fn2wv US002N 2025-11-17T14:22:55.638Z 2025-11-24T15:05:22.422Z
8482082 8482082 20251116051034_3POOG US002N 2025-11-17T14:22:25.553Z 2025-11-24T15:05:19.135Z
8480927 8480927 20251116005129_3YL2J US002N 2025-11-17T14:19:27.813Z 2025-11-24T15:04:57.282Z
8469022 8469022 20251115015155_8tLzZ US002N 2025-11-16T14:19:14.031Z 2025-11-23T15:17:33.517Z
8461896 8461896 20251114101503_QPADJ US002N 2025-11-15T14:25:02.326Z 2025-11-22T15:23:44.609Z
8461476 8461476 20251114092430_CQ0gb US002N 2025-11-15T14:24:19.740Z 2025-11-22T15:23:27.086Z
8461037 8461037 20251114083017_7JMp8 US002N 2025-11-15T14:23:30.473Z 2025-11-22T15:23:01.895Z
8460429 8460429 20251114070052_kBHRq US002N 2025-11-15T14:22:05.900Z 2025-11-22T15:22:37.011Z
8458927 8458927 20251114021639_pXX3d US002N 2025-11-15T14:18:16.832Z 2025-11-22T15:21:28.591Z
8386026 8386026 20251106021826_ESXNn US002N 2025-11-07T14:09:19.179Z 2025-11-14T15:08:32.121Z
8376580 8376580 20251103112100_DIIYS US002N 2025-11-05T14:36:51.491Z 2025-11-11T15:08:46.376Z
8376314 8376314 20251103103355_JYvPH US002N 2025-11-05T14:36:32.685Z 2025-11-11T15:08:29.239Z
8375811 8375811 20251103090636_6Puj5 US002N 2025-11-05T14:35:33.343Z 2025-11-11T15:08:19.717Z
8366183 8366183 20251102101904_9mR6z US002N 2025-11-04T14:34:47.893Z 2025-11-10T15:10:29.779Z
8358574 8358574 20251102085415_abtME US002N 2025-11-03T14:45:37.236Z 2025-11-10T15:10:21.835Z
8339779 8339779 20251031105219_qEOY3 US002N 2025-11-02T14:34:27.542Z 2025-11-08T15:17:46.928Z
8339065 8339065 20251031095406_SNPP0 US002N 2025-11-02T14:33:26.754Z 2025-11-08T15:17:27.115Z
8338672 8338672 20251031090944_hyQSS US002N 2025-11-02T14:32:55.530Z 2025-11-08T15:17:08.560Z
8327202 8327202 20251030105110_mpjxc US002N 2025-11-01T12:37:05.173Z 2025-11-07T15:18:49.769Z
8326902 8326902 20251030102151_3ELDI US002N 2025-11-01T12:36:29.280Z 2025-11-07T15:18:32.290Z
8326397 8326397 20251030093830_9TeWn US002N 2025-11-01T12:35:30.022Z 2025-11-07T15:17:59.381Z
8326161 8326161 20251030091535_sfm28 US002N 2025-11-01T12:35:18.218Z 2025-11-07T15:17:44.473Z
8326012 8326012 20251030085621_pv7rP US002N 2025-11-01T12:35:11.032Z 2025-11-07T15:17:37.948Z
8324034 8324034 20251030051917_5qKcv US002N 2025-11-01T12:31:38.831Z 2025-11-07T15:16:53.835Z
8284357 8284357 20251028043736_UYnso US002N 2025-10-29T12:45:30.574Z 2025-11-05T15:22:44.910Z
8275663 8275663 20251027071803_dXBU5 US002N 2025-10-29T12:28:16.839Z 2025-11-04T15:46:10.665Z
8227815 8227815 20251024111138_83IEO US002N 2025-10-26T12:46:38.798Z 2025-11-01T13:11:30.675Z
8227088 8227088 20251024101605_mG23A US002N 2025-10-26T12:45:21.978Z 2025-11-01T13:11:28.368Z
8226528 8226528 20251024093319_8H2D8 US002N 2025-10-26T12:45:03.924Z 2025-11-01T13:11:26.392Z
8226421 8226421 20251024092631_Nw8C6 US002N 2025-10-26T12:45:01.339Z 2025-11-01T13:11:25.607Z
8225411 8225411 20251024080341_lo4n8 US002N 2025-10-26T12:43:16.181Z 2025-11-01T13:11:21.823Z
8225237 8225237 20251024074914_p5b85 US002N 2025-10-26T12:43:08.147Z 2025-11-01T13:11:21.388Z
8217803 8217803 20251024024520_pv6r1 US002N 2025-10-26T12:34:17.393Z 2025-11-01T13:10:46.093Z
8204394 8204394 20251023104000_4ncpL US002N 2025-10-25T12:27:19.990Z 2025-10-31T13:09:06.598Z
8204335 8204335 20251023103501_r6ILq US002N 2025-10-25T12:27:15.295Z 2025-10-31T13:09:06.409Z
8203624 8203624 20251023092309_vLq2O US002N 2025-10-25T12:25:09.710Z 2025-10-31T13:09:01.384Z
8203612 8203612 20251023092110_6LTr9 US002N 2025-10-25T12:25:08.402Z 2025-10-31T13:09:01.369Z
8203489 8203489 20251023091025_YbnqP US002N 2025-10-25T12:24:42.881Z 2025-10-31T13:08:59.918Z
8203100 8203100 20251023082303_7ubuJ US002N 2025-10-25T12:23:24.317Z 2025-10-31T13:08:58.963Z
8203039 8203039 20251023081740_t0ITi US002N 2025-10-25T12:23:14.764Z 2025-10-31T13:08:58.428Z
8202784 8202784 20251023073403_g4mFe US002N 2025-10-25T12:22:30.497Z 2025-10-31T13:08:57.592Z
8202713 8202713 20251023072237_OYzVg US002N 2025-10-25T12:22:22.135Z 2025-10-31T13:08:56.556Z
8202693 8202693 20251023072047_SmOsN US002N 2025-10-25T12:22:19.392Z 2025-10-31T13:08:56.490Z
8202610 8202610 20251023070817_GSHjO US002N 2025-10-25T12:21:50.484Z 2025-10-31T13:08:56.153Z
8202384 8202384 20251023062933_kUjBy US002N 2025-10-25T12:21:02.780Z 2025-10-31T13:08:55.121Z
8202243 8202243 20251023055901_BoxFr US002N 2025-10-25T12:20:40.296Z 2025-10-31T13:08:54.645Z
8202067 8202067 20251023052850_0hg9p US002N 2025-10-25T12:20:01.132Z 2025-10-31T13:08:54.047Z
8099629 8099629 20251014061152_MIotj US002N 2025-10-15T12:19:32.472Z 2025-10-22T13:10:16.308Z
8089007 8089007 20251012095737_426Bs US002N 2025-10-13T12:15:13.006Z 2025-10-20T13:04:09.085Z
8088911 8088911 20251012093340_VnX1p US002N 2025-10-13T12:15:06.749Z 2025-10-20T13:04:07.635Z
8088793 8088793 20251012090313_63n13 US002N 2025-10-13T12:14:51.662Z 2025-10-20T13:04:06.116Z
8088459 8088459 20251012072520_RDGMf US002N 2025-10-13T12:13:52.204Z 2025-10-20T13:04:00.990Z
8088087 8088087 20251012045836_OeMeV US002N 2025-10-13T12:12:52.892Z 2025-10-20T13:03:54.038Z
8087811 8087811 20251012035120_C886e US002N 2025-10-13T12:12:05.289Z 2025-10-20T13:03:47.512Z
8083166 8083166 20251011051036_NflJU US002N 2025-10-12T12:09:43.797Z 2025-10-19T12:50:09.301Z
8075852 8075852 20251009045416_cpftw US002N 2025-10-10T12:10:34.952Z 2025-10-17T12:38:00.347Z
8059017 8059017 20251005103201_Y7tbj US002N 2025-10-07T12:04:02.278Z 2025-10-14T12:33:11.147Z
8053566 8053566 20251003105448_mETix US002N 2025-10-05T12:06:03.133Z 2025-10-12T12:30:41.116Z
8053411 8053411 20251003103325_vAzVx US002N 2025-10-05T12:05:20.602Z 2025-10-12T12:30:28.286Z
8053357 8053357 20251003102548_20cm3 US002N 2025-10-05T12:05:05.193Z 2025-10-12T12:30:24.091Z

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