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

111 rows where station_code = "US003B" 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
4224130 4224130 20240420112240_3lvjG US003B 2024-04-22T12:05:27.483Z 2024-04-28T12:21:45.095Z
4223765 4223765 20240420063201_B848i US003B 2024-04-22T12:04:23.148Z 2024-04-28T12:21:32.276Z
4220851 4220851 20240419110949_8ScDL US003B 2024-04-21T12:05:13.939Z 2024-04-27T12:20:31.415Z
4220547 4220547 20240419083053_zhEsc US003B 2024-04-21T12:04:25.267Z 2024-04-27T12:20:23.194Z
4220507 4220507 20240419080832_mLcD7 US003B 2024-04-21T12:04:20.421Z 2024-04-27T12:20:22.137Z
4220369 4220369 20240419050658_AggPR US003B 2024-04-21T12:03:50.655Z 2024-04-27T12:20:17.414Z
4214588 4214588 20240418085628_ZlgD9 US003B 2024-04-20T12:06:12.659Z 2024-04-26T12:17:08.114Z
4207324 4207324 20240417093528_LkRgO US003B 2024-04-19T12:03:59.919Z 2024-04-25T12:21:46.231Z
4206908 4206908 20240417073847_L0NxW US003B 2024-04-19T12:03:03.047Z 2024-04-25T12:21:37.760Z
4206884 4206884 20240417073624_krEuk US003B 2024-04-19T12:03:00.355Z 2024-04-25T12:21:37.459Z
4177303 4177303 20240411090536_wZ2uw US003B 2024-04-13T12:11:33.939Z 2024-04-19T12:13:23.159Z
4177235 4177235 20240411082034_AZlk9 US003B 2024-04-13T12:11:27.303Z 2024-04-19T12:13:22.348Z
4177233 4177233 20240411081917_v3aaJ US003B 2024-04-13T12:11:27.072Z 2024-04-19T12:13:22.347Z
4177208 4177208 20240411081249_8C7X0 US003B 2024-04-13T12:11:25.157Z 2024-04-19T12:13:21.577Z
4173090 4173090 20240410110745_K3B4w US003B 2024-04-12T12:10:54.932Z 2024-04-18T12:21:33.489Z
4173025 4173025 20240410105213_lI25x US003B 2024-04-12T12:10:44.365Z 2024-04-18T12:21:32.891Z
4172180 4172180 20240410041251_QxUQf US003B 2024-04-12T12:08:54.858Z 2024-04-18T12:21:22.758Z
4133611 4133611 20240401110047_62Z0a US003B 2024-04-02T12:05:30.392Z 2024-04-09T12:21:19.919Z
4133482 4133482 20240401080255_J34El US003B 2024-04-02T12:05:15.782Z 2024-04-09T12:21:18.201Z
4133279 4133279 20240401041342_Q3X5Y US003B 2024-04-02T12:04:40.556Z 2024-04-09T12:21:15.740Z
4131088 4131088 20240331105843_sgKOE US003B 2024-04-01T12:09:16.907Z 2024-04-08T12:19:00.706Z
4131009 4131009 20240331102425_C7XgM US003B 2024-04-01T12:09:08.563Z 2024-04-08T12:19:00.274Z
4130991 4130991 20240331101931_moZ41 US003B 2024-04-01T12:09:06.767Z 2024-04-08T12:19:00.109Z
4130905 4130905 20240331093313_C2YKi US003B 2024-04-01T12:08:59.602Z 2024-04-08T12:18:59.160Z
4125667 4125667 20240330102633_513Nz US003B 2024-03-31T12:10:10.313Z 2024-04-07T12:24:31.783Z
4125442 4125442 20240330092505_tyx7m US003B 2024-03-31T12:09:42.770Z 2024-04-07T12:24:30.641Z
3944786 3944786 20240210122542_GIZZS US003B 2024-02-11T14:08:44.765Z 2024-02-18T14:22:20.644Z
3759365 3759365 20240105103956_VlUmo US003B 2024-01-08T14:09:14.302Z 2024-01-14T14:23:06.409Z
3758887 3758887 20240105074550_kuXIe US003B 2024-01-08T14:08:05.454Z 2024-01-14T14:23:00.101Z
3711278 3711278 20231223122521_AWpIe US003B 2024-01-06T00:05:55.078Z 2024-01-06T00:05:55.078Z
3711264 3711264 20231223120544_QZjW9 US003B 2024-01-06T00:05:55.076Z 2024-01-06T00:05:55.076Z
3711141 3711141 20231223083225_DzIfY US003B 2024-01-06T00:05:53.916Z 2024-01-06T00:05:53.916Z
3535240 3535240 20231207131030_bh7jx US003B 2024-01-06T00:05:03.800Z 2024-01-06T00:05:03.800Z
3482969 3482969 20231126140259_emqRq US003B 2024-01-06T00:04:44.832Z 2024-01-06T00:04:44.832Z
3482965 3482965 20231126140006_kg3Xf US003B 2024-01-06T00:04:44.831Z 2024-01-06T00:04:44.831Z
3482794 3482794 20231126123606_GNLp0 US003B 2024-01-06T00:04:44.810Z 2024-01-06T00:04:44.810Z
3482592 3482592 20231126113443_IRHrx US003B 2024-01-06T00:04:44.788Z 2024-01-06T00:04:44.788Z
3482484 3482484 20231126110844_Xsy3l US003B 2024-01-06T00:04:44.776Z 2024-01-06T00:04:44.776Z
3480935 3480935 20231125130557_3dzb1 US003B 2024-01-06T00:04:43.411Z 2024-01-06T00:04:43.411Z
3470461 3470461 20231124121306_LN9ko US003B 2024-01-06T00:04:41.374Z 2024-01-06T00:04:41.374Z
3469831 3469831 20231124102212_Uu3KN US003B 2024-01-06T00:04:41.310Z 2024-01-06T00:04:41.310Z
3469522 3469522 20231124091622_9cdr3 US003B 2024-01-06T00:04:41.277Z 2024-01-06T00:04:41.277Z
3469418 3469418 20231124084235_9Y8MU US003B 2024-01-06T00:04:41.264Z 2024-01-06T00:04:41.264Z
3343770 3343770 20231108082444_Hhk4K US003B 2024-01-06T00:04:05.766Z 2024-01-06T00:04:05.766Z
3223356 3223356 20231021070934_3VEpi US003B 2024-01-06T00:03:09.794Z 2024-01-06T00:03:09.794Z
3222894 3222894 20231021054044_vj4Uo US003B 2024-01-06T00:03:09.539Z 2024-01-06T00:03:09.539Z
3222675 3222675 20231021050058_lSl23 US003B 2024-01-06T00:03:09.428Z 2024-01-06T00:03:09.428Z
3216265 3216265 20231020105852_14vxo US003B 2024-01-06T00:03:05.745Z 2024-01-06T00:03:05.745Z
3215842 3215842 20231020100448_jdxT8 US003B 2024-01-06T00:03:05.598Z 2024-01-06T00:03:05.598Z
3215640 3215640 20231020093759_EG2rc US003B 2024-01-06T00:03:05.531Z 2024-01-06T00:03:05.531Z
3215313 3215313 20231020085754_R13y9 US003B 2024-01-06T00:03:05.406Z 2024-01-06T00:03:05.406Z
3215124 3215124 20231020083457_2iOc3 US003B 2024-01-06T00:03:05.367Z 2024-01-06T00:03:05.367Z
3214356 3214356 20231020064301_4jslz US003B 2024-01-06T00:03:05.102Z 2024-01-06T00:03:05.102Z
3213845 3213845 20231020042001_n35PT US003B 2024-01-06T00:03:04.886Z 2024-01-06T00:03:04.886Z
3213836 3213836 20231020041305_qkYtQ US003B 2024-01-06T00:03:04.882Z 2024-01-06T00:03:04.882Z
3204712 3204712 20231018124150_YZuLB US003B 2024-01-06T00:02:58.729Z 2024-01-06T00:02:58.729Z
3204598 3204598 20231018122657_k9jo5 US003B 2024-01-06T00:02:58.691Z 2024-01-06T00:02:58.691Z
3204556 3204556 20231018122350_oRHlI US003B 2024-01-06T00:02:58.679Z 2024-01-06T00:02:58.679Z
3202823 3202823 20231018091646_e27cr US003B 2024-01-06T00:02:58.200Z 2024-01-06T00:02:58.200Z
3202073 3202073 20231018072545_cz2C1 US003B 2024-01-06T00:02:57.915Z 2024-01-06T00:02:57.915Z
3202053 3202053 20231018072313_yF0Ih US003B 2024-01-06T00:02:57.907Z 2024-01-06T00:02:57.907Z
3201767 3201767 20231018061918_bDTca US003B 2024-01-06T00:02:57.795Z 2024-01-06T00:02:57.795Z
3194572 3194572 20231017092003_XTFDo US003B 2024-01-06T00:02:54.460Z 2024-01-06T00:02:54.460Z
3194515 3194515 20231017091354_SkgI5 US003B 2024-01-06T00:02:54.455Z 2024-01-06T00:02:54.455Z
3116368 3116368 20231009091239_63fKG US003B 2024-01-06T00:02:34.257Z 2024-01-06T00:02:34.257Z
3116330 3116330 20231009090615_ZsOTO US003B 2024-01-06T00:02:34.253Z 2024-01-06T00:02:34.253Z
3097969 3097969 20231006093054_63gNO US003B 2024-01-06T00:02:28.373Z 2024-01-06T00:02:28.373Z
3097906 3097906 20231006091843_CsY15 US003B 2024-01-06T00:02:28.367Z 2024-01-06T00:02:28.367Z
3096498 3096498 20231006024756_XzeOA US003B 2024-01-06T00:02:28.200Z 2024-01-06T00:02:28.200Z
3094389 3094389 20231005120840_35jdM US003B 2024-01-06T00:02:26.458Z 2024-01-06T00:02:26.458Z
3093516 3093516 20231005094422_YNCvF US003B 2024-01-06T00:02:26.372Z 2024-01-06T00:02:26.372Z
3093336 3093336 20231005091309_Ye43O US003B 2024-01-06T00:02:26.354Z 2024-01-06T00:02:26.354Z
3091838 3091838 20231005040141_1CpsO US003B 2024-01-06T00:02:26.183Z 2024-01-06T00:02:26.183Z
3089714 3089714 20231004130442_3UdGZ US003B 2024-01-06T00:02:24.358Z 2024-01-06T00:02:24.358Z
3078307 3078307 20231001054048_q6Ezg US003B 2024-01-06T00:02:19.272Z 2024-01-06T00:02:19.272Z
3055078 3055078 20230924123023_OT4w8 US003B 2024-01-06T00:02:07.960Z 2024-01-06T00:02:07.960Z
3040788 3040788 20230922085430_XEKM0 US003B 2024-01-06T00:02:03.988Z 2024-01-06T00:02:03.988Z
3040560 3040560 20230922080609_Ue9Et US003B 2024-01-06T00:02:03.965Z 2024-01-06T00:02:03.965Z
3040457 3040457 20230922073634_BDSeg US003B 2024-01-06T00:02:03.954Z 2024-01-06T00:02:03.954Z
3040397 3040397 20230922071345_XIeOq US003B 2024-01-06T00:02:03.947Z 2024-01-06T00:02:03.947Z
3034871 3034871 20230921123057_Yc5qW US003B 2024-01-06T00:02:02.143Z 2024-01-06T00:02:02.143Z
3012907 3012907 20230917083943_5Ws1N US003B 2024-01-06T00:01:54.690Z 2024-01-06T00:01:54.690Z
3009604 3009604 20230916113246_i5Vdx US003B 2024-01-06T00:01:54.255Z 2024-01-06T00:01:54.255Z
3009582 3009582 20230916112805_Sa0gq US003B 2024-01-06T00:01:54.252Z 2024-01-06T00:01:54.252Z
3009134 3009134 20230916100656_GmZl2 US003B 2024-01-06T00:01:52.930Z 2024-01-06T00:01:52.930Z
3009010 3009010 20230916094602_ghNv7 US003B 2024-01-06T00:01:52.918Z 2024-01-06T00:01:52.918Z
3008924 3008924 20230916092813_gDMQf US003B 2024-01-06T00:01:52.909Z 2024-01-06T00:01:52.909Z
3008503 3008503 20230916081536_3nLQ0 US003B 2024-01-06T00:01:52.868Z 2024-01-06T00:01:52.868Z
3008129 3008129 20230916065846_TIw10 US003B 2024-01-06T00:01:52.831Z 2024-01-06T00:01:52.831Z
3007546 3007546 20230916040112_BovzT US003B 2024-01-06T00:01:52.764Z 2024-01-06T00:01:52.764Z
3000391 3000391 20230915100849_L3Agg US003B 2024-01-06T00:01:50.802Z 2024-01-06T00:01:50.802Z
2999056 2999056 20230915061012_sFcP6 US003B 2024-01-06T00:01:50.656Z 2024-01-06T00:01:50.656Z
2998669 2998669 20230915040240_eH2Et US003B 2024-01-06T00:01:50.607Z 2024-01-06T00:01:50.607Z
2987499 2987499 20230913113523_kqZVy US003B 2024-01-06T00:01:48.237Z 2024-01-06T00:01:48.237Z
2987128 2987128 20230913085750_yKo0b US003B 2024-01-06T00:01:48.190Z 2024-01-06T00:01:48.190Z
2987110 2987110 20230913084545_GYkz3 US003B 2024-01-06T00:01:46.952Z 2024-01-06T00:01:46.952Z
2986954 2986954 20230913065326_7pWe1 US003B 2024-01-06T00:01:46.931Z 2024-01-06T00:01:46.931Z
2978591 2978591 20230911055943_tN2sv US003B 2024-01-06T00:01:43.460Z 2024-01-06T00:01:43.460Z
2964754 2964754 20230909075626_K0abY US003B 2024-01-06T00:01:40.351Z 2024-01-06T00:01:40.351Z
2964402 2964402 20230909062022_BA1g3 US003B 2024-01-06T00:01:40.246Z 2024-01-06T00:01:40.246Z

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