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

1,037 rows where station_code = "US006B" 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
9612210 9612210 20260406081728_fjuxk US006B 2026-04-07T12:01:05.447Z 2026-04-07T12:01:05.447Z
9612111 9612111 20260406070815_noOrc US006B 2026-04-07T12:00:50.307Z 2026-04-07T12:00:50.307Z
9612101 9612101 20260406065411_gpPzy US006B 2026-04-07T12:00:46.904Z 2026-04-07T12:00:46.904Z
9609030 9609030 20260404030629_LPvcR US006B 2026-04-05T12:12:42.420Z 2026-04-07T12:18:36.890Z
9593202 9593202 20260329075424_Hick4 US006B 2026-03-30T12:03:15.951Z 2026-04-07T12:27:04.306Z
9593154 9593154 20260329065832_6ZBRC US006B 2026-03-30T12:03:08.462Z 2026-04-07T12:27:03.241Z
9593123 9593123 20260329064213_tGGkh US006B 2026-03-30T12:03:01.304Z 2026-04-07T12:27:02.401Z
9593115 9593115 20260329062246_fuaoc US006B 2026-03-30T12:02:59.357Z 2026-04-07T12:27:02.205Z
9592532 9592532 20260329022331_Q2eFV US006B 2026-03-30T12:01:12.864Z 2026-04-07T12:26:34.245Z
9590526 9590526 20260328095018_ePX3y US006B 2026-03-29T12:02:51.469Z 2026-04-06T12:38:22.320Z
9590470 9590470 20260328092038_kn0la US006B 2026-03-29T12:02:43.106Z 2026-04-06T12:38:11.128Z
9590442 9590442 20260328091328_M2WNe US006B 2026-03-29T12:02:40.570Z 2026-04-06T12:38:09.883Z
9590401 9590401 20260328085458_9DdxC US006B 2026-03-29T12:02:34.160Z 2026-04-06T12:38:05.858Z
9590352 9590352 20260328082504_pPb09 US006B 2026-03-29T12:02:27.873Z 2026-04-06T12:38:02.558Z
9590306 9590306 20260328080733_Uf6Uz US006B 2026-03-29T12:02:24.069Z 2026-04-06T12:38:00.656Z
9590260 9590260 20260328075547_jK6Vj US006B 2026-03-29T12:02:20.345Z 2026-04-06T12:37:58.841Z
9590245 9590245 20260328074626_r3cHo US006B 2026-03-29T12:02:19.278Z 2026-04-06T12:37:58.206Z
9590157 9590157 20260328071623_wSjd1 US006B 2026-03-29T12:02:07.871Z 2026-04-06T12:37:53.962Z
9590040 9590040 20260328043044_Rf85Y US006B 2026-03-29T12:01:54.102Z 2026-04-06T12:37:47.842Z
9589651 9589651 20260328035516_dfV02 US006B 2026-03-29T12:01:31.874Z 2026-04-06T12:37:30.361Z
9577622 9577622 20260325075015_Ouq3c US006B 2026-03-26T12:05:39.657Z 2026-04-03T12:37:10.982Z
9577501 9577501 20260325064821_ckWVm US006B 2026-03-26T12:05:17.779Z 2026-04-03T12:37:03.918Z
9577478 9577478 20260325062819_S40EF US006B 2026-03-26T12:05:14.777Z 2026-04-03T12:37:03.214Z
9577392 9577392 20260325053909_B8djr US006B 2026-03-26T12:05:00.383Z 2026-04-03T12:37:00.031Z
9572705 9572705 20260324095648_8BoY4 US006B 2026-03-25T12:06:03.259Z 2026-04-02T12:35:35.230Z
9572446 9572446 20260324090413_GG12J US006B 2026-03-25T12:05:11.153Z 2026-04-02T12:35:25.049Z
9571420 9571420 20260324015945_McPVa US006B 2026-03-25T12:01:23.440Z 2026-04-02T12:34:25.721Z
9536599 9536599 20260320100940_tVCyu US006B 2026-03-21T12:13:51.374Z 2026-03-28T12:35:04.364Z
9536131 9536131 20260320091607_HIEBw US006B 2026-03-21T12:12:40.383Z 2026-03-28T12:34:57.949Z
9535840 9535840 20260320083623_HIHdJ US006B 2026-03-21T12:11:59.844Z 2026-03-28T12:34:52.136Z
9535620 9535620 20260320080911_x4Upy US006B 2026-03-21T12:11:21.348Z 2026-03-28T12:34:47.786Z
9535390 9535390 20260320072101_ZBl3x US006B 2026-03-21T12:10:36.644Z 2026-03-28T12:34:34.113Z
9535335 9535335 20260320071012_XtILc US006B 2026-03-21T12:10:25.106Z 2026-03-28T12:34:33.110Z
9535307 9535307 20260320065922_Cdc4S US006B 2026-03-21T12:10:20.189Z 2026-03-28T12:34:32.560Z
9535199 9535199 20260320061157_Z3pMN US006B 2026-03-21T12:10:02.402Z 2026-03-28T12:34:29.225Z
9533220 9533220 20260320021555_9R1sP US006B 2026-03-21T12:04:50.746Z 2026-03-28T12:33:50.688Z
9513026 9513026 20260318082211_xd849 US006B 2026-03-19T12:14:12.213Z 2026-03-26T12:37:51.033Z
9512775 9512775 20260318074644_O5Kka US006B 2026-03-19T12:13:33.004Z 2026-03-26T12:37:48.847Z
9512716 9512716 20260318073908_NRSBI US006B 2026-03-19T12:13:24.204Z 2026-03-26T12:37:48.298Z
9512118 9512118 20260318044443_olsOL US006B 2026-03-19T12:11:44.814Z 2026-03-26T12:37:42.497Z
9511206 9511206 20260318034017_BRhWj US006B 2026-03-19T12:09:40.893Z 2026-03-26T12:37:26.982Z
9484692 9484692 20260315012829_k0PE3 US006B 2026-03-16T12:03:47.202Z 2026-03-23T12:21:47.934Z
9478742 9478742 20260314095827_ffMQv US006B 2026-03-15T12:11:53.015Z 2026-03-22T12:42:11.614Z
9478279 9478279 20260314090003_P4EpF US006B 2026-03-15T12:10:41.955Z 2026-03-22T12:42:09.392Z
9478226 9478226 20260314084915_JK3OI US006B 2026-03-15T12:10:34.657Z 2026-03-22T12:42:09.172Z
9478161 9478161 20260314083725_BHGCQ US006B 2026-03-15T12:10:23.576Z 2026-03-22T12:42:08.778Z
9478088 9478088 20260314082110_qFQY3 US006B 2026-03-15T12:10:12.261Z 2026-03-22T12:42:08.456Z
9478060 9478060 20260314081344_CXZi9 US006B 2026-03-15T12:10:07.070Z 2026-03-22T12:42:08.220Z
9477917 9477917 20260314073719_tEV34 US006B 2026-03-15T12:09:40.091Z 2026-03-22T12:42:06.436Z
9477776 9477776 20260314063905_109K2 US006B 2026-03-15T12:09:06.094Z 2026-03-22T12:42:05.159Z
9477663 9477663 20260314055024_z9rgy US006B 2026-03-15T12:08:45.200Z 2026-03-22T12:42:04.369Z
9476709 9476709 20260314033328_yM2PP US006B 2026-03-15T12:06:41.143Z 2026-03-22T12:41:58.682Z
9471417 9471417 20260313101246_YqR6Z US006B 2026-03-14T12:10:22.266Z 2026-03-21T12:49:21.410Z
9471371 9471371 20260313100305_oCtG0 US006B 2026-03-14T12:10:10.062Z 2026-03-21T12:49:20.779Z
9471277 9471277 20260313093807_vgGut US006B 2026-03-14T12:09:54.818Z 2026-03-21T12:49:19.472Z
9471092 9471092 20260313090052_2DA0i US006B 2026-03-14T12:09:25.153Z 2026-03-21T12:49:17.688Z
9470952 9470952 20260313082415_eMHW9 US006B 2026-03-14T12:08:58.947Z 2026-03-21T12:49:15.748Z
9470942 9470942 20260313082156_XSksB US006B 2026-03-14T12:08:57.413Z 2026-03-21T12:49:15.692Z
9470869 9470869 20260313080454_2HF4I US006B 2026-03-14T12:08:41.397Z 2026-03-21T12:49:14.952Z
9470700 9470700 20260313072354_Jm92F US006B 2026-03-14T12:08:08.581Z 2026-03-21T12:49:12.078Z
9470543 9470543 20260313061957_z8FSB US006B 2026-03-14T12:07:40.477Z 2026-03-21T12:49:10.758Z
9469973 9469973 20260313041244_JMstI US006B 2026-03-14T12:06:08.134Z 2026-03-21T12:49:04.679Z
9458474 9458474 20260311095745_xYDth US006B 2026-03-12T12:06:14.806Z 2026-03-19T12:44:59.025Z
9458203 9458203 20260311085849_rljag US006B 2026-03-12T12:05:36.605Z 2026-03-19T12:44:56.472Z
9452223 9452223 20260310090050_eLih0 US006B 2026-03-11T12:05:02.236Z 2026-03-18T12:39:11.021Z
9452059 9452059 20260310065531_colHV US006B 2026-03-11T12:04:36.489Z 2026-03-18T12:39:09.046Z
9451988 9451988 20260310052257_Uq2Oc US006B 2026-03-11T12:04:20.893Z 2026-03-18T12:39:07.946Z
9451957 9451957 20260310050804_LmtP1 US006B 2026-03-11T12:04:17.226Z 2026-03-18T12:39:07.524Z
9451917 9451917 20260310050142_h2uN6 US006B 2026-03-11T12:04:13.821Z 2026-03-18T12:39:06.973Z
9447955 9447955 20260309092730_h9qr1 US006B 2026-03-10T12:08:25.669Z 2026-03-17T12:41:58.611Z
9447714 9447714 20260309083825_SPhv0 US006B 2026-03-10T12:07:37.740Z 2026-03-17T12:41:55.926Z
9447510 9447510 20260309074903_oFoYd US006B 2026-03-10T12:06:46.806Z 2026-03-17T12:41:52.563Z
9447256 9447256 20260309061321_oX8vx US006B 2026-03-10T12:05:47.280Z 2026-03-17T12:41:49.623Z
9447186 9447186 20260309054505_yhdKh US006B 2026-03-10T12:05:29.035Z 2026-03-17T12:41:48.664Z
9447126 9447126 20260309045451_ocy0B US006B 2026-03-10T12:05:15.760Z 2026-03-17T12:41:47.891Z
9446651 9446651 20260309023052_pKCOf US006B 2026-03-10T12:03:17.275Z 2026-03-17T12:41:40.682Z
9446565 9446565 20260309021154_b8NUR US006B 2026-03-10T12:02:56.764Z 2026-03-17T12:41:39.724Z
9446558 9446558 20260309021050_Keh6q US006B 2026-03-10T12:02:54.650Z 2026-03-17T12:41:39.596Z
9416126 9416126 20260302084935_rC9L7 US006B 2026-03-03T14:02:47.745Z 2026-03-10T12:35:59.117Z
9415958 9415958 20260302053643_bvQGU US006B 2026-03-03T14:02:15.509Z 2026-03-10T12:35:54.541Z
9412847 9412847 20260301065628_sZZVF US006B 2026-03-02T14:02:14.311Z 2026-03-09T12:39:53.017Z
9412134 9412134 20260301004520_Eqr3b US006B 2026-03-02T14:00:37.179Z 2026-03-09T12:39:20.601Z
9412108 9412108 20260301002522_PIaQv US006B 2026-03-02T14:00:31.233Z 2026-03-09T12:39:19.524Z
9412064 9412064 20260228235533_98YzG US006B 2026-03-02T14:00:23.638Z 2026-03-09T12:39:17.876Z
9410173 9410173 20260228093634_Uyy49 US006B 2026-03-01T14:03:05.606Z 2026-03-08T12:41:53.341Z
9410146 9410146 20260228092657_4zA7A US006B 2026-03-01T14:03:02.950Z 2026-03-08T12:41:52.611Z
9409993 9409993 20260228082106_M3wrM US006B 2026-03-01T14:02:42.084Z 2026-03-08T12:41:47.639Z
9409472 9409472 20260228032636_MehI0 US006B 2026-03-01T14:01:32.746Z 2026-03-08T12:41:18.642Z
9403714 9403714 20260227103614_x0wIc US006B 2026-02-28T14:09:01.755Z 2026-03-07T14:48:10.629Z
9403449 9403449 20260227094646_9eqGP US006B 2026-02-28T14:08:20.844Z 2026-03-07T14:47:52.753Z
9403393 9403393 20260227093334_2mDOg US006B 2026-02-28T14:08:07.911Z 2026-03-07T14:47:50.020Z
9403125 9403125 20260227080858_qBR7I US006B 2026-02-28T14:07:16.600Z 2026-03-07T14:47:32.213Z
9403103 9403103 20260227080505_AK3Ys US006B 2026-02-28T14:07:13.993Z 2026-03-07T14:47:31.223Z
9403002 9403002 20260227063130_EQV7k US006B 2026-02-28T14:06:50.615Z 2026-03-07T14:47:21.589Z
9402725 9402725 20260227042702_TVaha US006B 2026-02-28T14:05:49.899Z 2026-03-07T14:47:01.365Z
9399844 9399844 20260226104335_6eKR3 US006B 2026-02-27T14:08:53.820Z 2026-03-06T14:44:36.600Z
9399503 9399503 20260226080058_FSULT US006B 2026-02-27T14:08:00.816Z 2026-03-06T14:44:21.253Z
9399421 9399421 20260226071823_MJpbm US006B 2026-02-27T14:07:46.563Z 2026-03-06T14:44:18.984Z
9399357 9399357 20260226061537_8SzuD US006B 2026-02-27T14:07:36.594Z 2026-03-06T14:44:16.871Z
9399326 9399326 20260226055825_BMeAA US006B 2026-02-27T14:07:31.682Z 2026-03-06T14:44:16.011Z

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