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 = "USL01B" 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
9611735 9611735 20260405031942_JDQo7 USL01B 2026-04-06T12:15:50.788Z 2026-04-06T12:16:14.855Z
9610035 9610035 20260405120413_G9rA2 USL01B 2026-04-06T12:05:21.191Z 2026-04-06T12:05:21.191Z
9610028 9610028 20260405115919_LhB6k USL01B 2026-04-06T12:05:19.548Z 2026-04-06T12:05:19.548Z
9610013 9610013 20260405115148_lNKao USL01B 2026-04-06T12:05:16.097Z 2026-04-06T12:05:16.097Z
9609982 9609982 20260405113752_86CUv USL01B 2026-04-06T12:05:05.689Z 2026-04-06T12:05:05.689Z
9609853 9609853 20260405103531_Xlq24 USL01B 2026-04-06T12:04:20.045Z 2026-04-06T12:04:20.045Z
9609851 9609851 20260405103441_3o61p USL01B 2026-04-06T12:04:19.412Z 2026-04-06T12:04:19.412Z
9609825 9609825 20260405102206_MKjZy USL01B 2026-04-06T12:04:04.048Z 2026-04-06T12:04:04.048Z
9609787 9609787 20260405100003_Ktt7U USL01B 2026-04-06T12:03:52.256Z 2026-04-06T12:03:52.256Z
9609751 9609751 20260405094154_mj2Ev USL01B 2026-04-06T12:03:43.143Z 2026-04-06T12:03:43.143Z
9609676 9609676 20260405090336_25mWy USL01B 2026-04-06T12:03:16.711Z 2026-04-06T12:03:16.711Z
9609560 9609560 20260405081047_F8eFy USL01B 2026-04-06T12:02:33.753Z 2026-04-06T12:02:33.753Z
9609311 9609311 20260405042007_uMiTY USL01B 2026-04-06T12:01:08.767Z 2026-04-06T12:01:08.767Z
9609240 9609240 20260405040339_OrB12 USL01B 2026-04-06T12:00:47.792Z 2026-04-06T12:00:47.792Z
9609043 9609043 20260402063515_tyJZo USL01B 2026-04-05T12:13:38.946Z 2026-04-06T12:21:29.107Z
9607710 9607710 20260404115744_VaXyh USL01B 2026-04-05T12:03:38.425Z 2026-04-06T12:16:14.497Z
9607631 9607631 20260404112534_3XHOR USL01B 2026-04-05T12:03:16.375Z 2026-04-06T12:16:14.479Z
9607627 9607627 20260404112231_K853O USL01B 2026-04-05T12:03:15.340Z 2026-04-06T12:16:14.477Z
9607537 9607537 20260404103318_p0Wvh USL01B 2026-04-05T12:02:49.612Z 2026-04-06T12:16:14.459Z
9607528 9607528 20260404102724_gB2t4 USL01B 2026-04-05T12:02:46.964Z 2026-04-06T12:16:14.457Z
9607435 9607435 20260404090947_pswe8 USL01B 2026-04-05T12:02:16.421Z 2026-04-06T12:16:14.436Z
9607217 9607217 20260404054756_J8IhW USL01B 2026-04-05T12:00:57.682Z 2026-04-06T12:16:14.386Z
9605784 9605784 20260403120242_PYXFs USL01B 2026-04-04T12:03:54.673Z 2026-04-06T12:18:20.827Z
9605751 9605751 20260403115309_kSxIj USL01B 2026-04-04T12:03:42.191Z 2026-04-06T12:18:18.473Z
9605668 9605668 20260403112342_mXNnJ USL01B 2026-04-04T12:03:22.833Z 2026-04-06T12:18:11.166Z
9605604 9605604 20260403105611_bMa8v USL01B 2026-04-04T12:03:01.569Z 2026-04-04T12:03:01.569Z
9605415 9605415 20260403095058_3OoPa USL01B 2026-04-04T12:02:10.306Z 2026-04-06T12:17:48.706Z
9603118 9603118 20260402075729_22Oi9 USL01B 2026-04-03T12:01:53.030Z 2026-04-06T12:21:38.090Z
9596017 9596017 20260330104215_e1Xmo USL01B 2026-03-31T12:03:08.838Z 2026-04-06T12:30:46.483Z
9596006 9596006 20260330103525_9QLWe USL01B 2026-03-31T12:03:06.760Z 2026-04-06T12:30:45.028Z
9595999 9595999 20260330103329_B7nRy USL01B 2026-03-31T12:03:05.665Z 2026-04-06T12:30:44.673Z
9595922 9595922 20260330100553_ogGqn USL01B 2026-03-31T12:02:51.407Z 2026-04-06T12:30:40.857Z
9595846 9595846 20260330092220_MKKQz USL01B 2026-03-31T12:02:41.350Z 2026-04-06T12:30:37.201Z
9593621 9593621 20260329121606_QifH3 USL01B 2026-03-30T12:04:32.404Z 2026-04-06T12:35:30.428Z
9593589 9593589 20260329120158_GpVpl USL01B 2026-03-30T12:04:26.680Z 2026-04-06T12:35:27.156Z
9593584 9593584 20260329120044_E1knl USL01B 2026-03-30T12:04:26.313Z 2026-04-06T12:35:26.990Z
9593574 9593574 20260329115910_0lQ6t USL01B 2026-03-30T12:04:25.441Z 2026-04-06T12:35:26.617Z
9593486 9593486 20260329111335_WOJgZ USL01B 2026-03-30T12:04:08.138Z 2026-04-06T12:35:21.533Z
9593339 9593339 20260329093346_yLl3W USL01B 2026-03-30T12:03:40.247Z 2026-04-06T12:35:13.280Z
9593337 9593337 20260329093158_xKFXp USL01B 2026-03-30T12:03:39.670Z 2026-04-06T12:35:13.110Z
9593332 9593332 20260329092955_4mUKO USL01B 2026-03-30T12:03:39.171Z 2026-04-06T12:35:12.871Z
9593328 9593328 20260329092451_kiekb USL01B 2026-03-30T12:03:38.029Z 2026-04-06T12:35:12.598Z
9590821 9590821 20260328112712_pufvv USL01B 2026-03-29T12:03:20.291Z 2026-04-06T12:38:35.839Z
9590225 9590225 20260328073555_dgm4i USL01B 2026-03-29T12:02:15.206Z 2026-04-06T12:37:57.003Z
9590216 9590216 20260328073406_uHCpK USL01B 2026-03-29T12:02:14.128Z 2026-04-06T12:37:56.653Z
9590202 9590202 20260328073109_n3Zy4 USL01B 2026-03-29T12:02:12.754Z 2026-04-06T12:37:56.068Z
9590184 9590184 20260328072136_jGjnu USL01B 2026-03-29T12:02:10.134Z 2026-04-06T12:37:55.136Z
9586556 9586556 20260327081725_wRFi5 USL01B 2026-03-28T12:03:24.141Z 2026-04-05T12:33:30.251Z
9586552 9586552 20260327081446_eHELt USL01B 2026-03-28T12:03:23.776Z 2026-04-05T12:33:30.105Z
9586548 9586548 20260327081407_VFRP2 USL01B 2026-03-28T12:03:23.148Z 2026-04-05T12:33:29.911Z
9586524 9586524 20260327081044_AbY94 USL01B 2026-03-28T12:03:19.950Z 2026-04-05T12:33:29.027Z
9586518 9586518 20260327080736_TT9tP USL01B 2026-03-28T12:03:18.992Z 2026-04-05T12:33:28.797Z
9586516 9586516 20260327080731_422b6 USL01B 2026-03-28T12:03:18.584Z 2026-04-05T12:33:28.645Z
9586505 9586505 20260327080318_hSa39 USL01B 2026-03-28T12:03:17.701Z 2026-04-05T12:33:28.382Z
9586461 9586461 20260327074915_zwmuv USL01B 2026-03-28T12:03:10.865Z 2026-04-05T12:33:26.857Z
9586241 9586241 20260327051412_4zxGK USL01B 2026-03-28T12:02:35.474Z 2026-04-05T12:33:09.823Z
9586229 9586229 20260327050122_kEm6R USL01B 2026-03-28T12:02:33.686Z 2026-04-05T12:33:08.944Z
9583062 9583062 20260326104418_tDXZR USL01B 2026-03-27T12:07:33.513Z 2026-04-04T12:40:43.738Z
9583048 9583048 20260326104135_FS08T USL01B 2026-03-27T12:07:30.510Z 2026-04-04T12:40:43.140Z
9583000 9583000 20260326103329_7ISxA USL01B 2026-03-27T12:07:24.930Z 2026-04-04T12:40:39.370Z
9582996 9582996 20260326103321_ciFur USL01B 2026-03-27T12:07:24.558Z 2026-04-04T12:40:39.280Z
9582984 9582984 20260326103213_J5EUc USL01B 2026-03-27T12:07:23.189Z 2026-04-04T12:40:38.894Z
9582930 9582930 20260326100158_TSEg7 USL01B 2026-03-27T12:07:15.201Z 2026-04-04T12:40:36.693Z
9582924 9582924 20260326095957_lK9it USL01B 2026-03-27T12:07:12.947Z 2026-04-04T12:40:36.599Z
9582860 9582860 20260326095022_XxUyg USL01B 2026-03-27T12:07:02.064Z 2026-04-04T12:40:33.135Z
9582851 9582851 20260326094710_j0elS USL01B 2026-03-27T12:07:00.435Z 2026-04-04T12:40:32.447Z
9582783 9582783 20260326092411_8STVo USL01B 2026-03-27T12:06:45.258Z 2026-04-04T12:40:27.934Z
9582484 9582484 20260326075608_DoPiK USL01B 2026-03-27T12:05:55.345Z 2026-04-04T12:40:03.753Z
9582473 9582473 20260326075417_8IJ7X USL01B 2026-03-27T12:05:54.303Z 2026-04-04T12:40:03.151Z
9582438 9582438 20260326072457_0wwyy USL01B 2026-03-27T12:05:45.076Z 2026-04-04T12:40:00.755Z
9582361 9582361 20260326070244_EDWdA USL01B 2026-03-27T12:05:32.830Z 2026-04-04T12:39:57.918Z
9582257 9582257 20260326055253_irhFj USL01B 2026-03-27T12:05:07.920Z 2026-04-04T12:39:45.801Z
9582255 9582255 20260326055011_CZjKF USL01B 2026-03-27T12:05:07.398Z 2026-04-04T12:39:45.625Z
9582163 9582163 20260326044307_oZZsw USL01B 2026-03-27T12:04:45.250Z 2026-04-04T12:39:39.237Z
9582125 9582125 20260326044029_mmA93 USL01B 2026-03-27T12:04:41.476Z 2026-04-04T12:39:38.311Z
9582079 9582079 20260326043406_wqCM8 USL01B 2026-03-27T12:04:34.444Z 2026-04-04T12:39:37.060Z
9581160 9581160 20260326023051_O4gYK USL01B 2026-03-27T12:02:16.532Z 2026-04-04T12:38:44.389Z
9578567 9578567 20260325121608_DpCV5 USL01B 2026-03-26T12:07:56.252Z 2026-04-03T12:38:08.513Z
9578549 9578549 20260325121402_81ZV5 USL01B 2026-03-26T12:07:53.833Z 2026-04-03T12:38:07.796Z
9578513 9578513 20260325120929_0LTKO USL01B 2026-03-26T12:07:47.554Z 2026-04-03T12:38:06.359Z
9578495 9578495 20260325120124_FD7yf USL01B 2026-03-26T12:07:45.158Z 2026-04-03T12:38:05.620Z
9578438 9578438 20260325115056_4iO0Q USL01B 2026-03-26T12:07:38.022Z 2026-04-03T12:38:03.628Z
9578404 9578404 20260325114457_Mcv6W USL01B 2026-03-26T12:07:32.420Z 2026-04-03T12:38:02.051Z
9578351 9578351 20260325112441_6CU32 USL01B 2026-03-26T12:07:22.902Z 2026-04-03T12:37:59.583Z
9578317 9578317 20260325111811_a9mnJ USL01B 2026-03-26T12:07:17.826Z 2026-04-03T12:37:58.099Z
9578014 9578014 20260325093220_rb2mM USL01B 2026-03-26T12:06:32.787Z 2026-04-03T12:37:33.762Z
9577885 9577885 20260325090846_JeCp6 USL01B 2026-03-26T12:06:16.929Z 2026-04-03T12:37:29.913Z
9577870 9577870 20260325090656_1KihP USL01B 2026-03-26T12:06:15.909Z 2026-04-03T12:37:29.689Z
9577847 9577847 20260325085628_QMvQW USL01B 2026-03-26T12:06:12.835Z 2026-04-03T12:37:28.943Z
9577724 9577724 20260325081314_BQgBq USL01B 2026-03-26T12:05:55.606Z 2026-04-03T12:37:24.552Z
9577639 9577639 20260325075530_Mf2FP USL01B 2026-03-26T12:05:42.445Z 2026-04-03T12:37:11.636Z
9577583 9577583 20260325073417_LoIPp USL01B 2026-03-26T12:05:34.564Z 2026-04-03T12:37:09.271Z
9577559 9577559 20260325072345_TkW3r USL01B 2026-03-26T12:05:30.700Z 2026-04-03T12:37:06.507Z
9577330 9577330 20260325045739_x3yCS USL01B 2026-03-26T12:04:48.182Z 2026-04-03T12:36:57.006Z
9577131 9577131 20260325040042_gHP7J USL01B 2026-03-26T12:04:13.710Z 2026-04-03T12:36:35.899Z
9576997 9576997 20260325033713_kA6j6 USL01B 2026-03-26T12:03:51.408Z 2026-04-03T12:36:28.580Z
9576618 9576618 20260325024255_Ye8rn USL01B 2026-03-26T12:02:48.667Z 2026-04-03T12:36:14.804Z
9573126 9573126 20260324112310_ZmnUL USL01B 2026-03-25T12:07:14.003Z 2026-04-02T12:35:56.813Z
9573083 9573083 20260324111601_nGBn9 USL01B 2026-03-25T12:07:08.636Z 2026-04-02T12:35:55.038Z
9573066 9573066 20260324111310_FhzhU USL01B 2026-03-25T12:07:06.709Z 2026-04-02T12:35:54.510Z

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