participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,737 rows where station_code = "US0039" sorted by created_at descending
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 |
---|---|---|---|---|---|
5567644 | 5567644 | 20241121104802_5FygO | US0039 | 2024-11-22T14:06:43.330Z | 2024-11-22T14:06:43.330Z |
5567642 | 5567642 | 20241121104747_7BSy3 | US0039 | 2024-11-22T14:06:42.993Z | 2024-11-22T14:06:42.993Z |
5566954 | 5566954 | 20241121084743_Huze2 | US0039 | 2024-11-22T14:04:44.984Z | 2024-11-22T14:04:44.984Z |
5566866 | 5566866 | 20241121081942_2rJ6F | US0039 | 2024-11-22T14:04:19.219Z | 2024-11-22T14:04:19.219Z |
5566726 | 5566726 | 20241121073254_YuWuF | US0039 | 2024-11-22T14:03:45.690Z | 2024-11-22T14:03:45.690Z |
5566686 | 5566686 | 20241121072131_6jB5b | US0039 | 2024-11-22T14:03:39.235Z | 2024-11-22T14:03:39.235Z |
5566592 | 5566592 | 20241121065459_I43Lq | US0039 | 2024-11-22T14:03:18.795Z | 2024-11-22T14:03:18.795Z |
5566529 | 5566529 | 20241121062949_hm381 | US0039 | 2024-11-22T14:03:05.848Z | 2024-11-22T14:03:05.848Z |
5566398 | 5566398 | 20241121060810_ciO4K | US0039 | 2024-11-22T14:02:44.082Z | 2024-11-22T14:02:44.082Z |
5559659 | 5559659 | 20241120105446_OK2Bn | US0039 | 2024-11-21T14:06:54.981Z | 2024-11-22T14:19:21.496Z |
5559424 | 5559424 | 20241120102130_lCaUH | US0039 | 2024-11-21T14:06:18.049Z | 2024-11-22T14:19:21.444Z |
5559241 | 5559241 | 20241120094334_Ol5gI | US0039 | 2024-11-21T14:05:41.708Z | 2024-11-22T14:19:21.395Z |
5554884 | 5554884 | 20241119105518_siQqg | US0039 | 2024-11-20T14:03:43.034Z | 2024-11-22T14:19:53.250Z |
5554824 | 5554824 | 20241119104510_xJb9L | US0039 | 2024-11-20T14:03:24.268Z | 2024-11-22T14:19:52.133Z |
5554692 | 5554692 | 20241119100814_M42iq | US0039 | 2024-11-20T14:03:01.526Z | 2024-11-22T14:19:49.018Z |
5548866 | 5548866 | 20241117020242_Sf6DG | US0039 | 2024-11-18T14:10:21.583Z | 2024-11-22T14:23:16.503Z |
5548591 | 5548591 | 20241117002930_e7U21 | US0039 | 2024-11-18T14:09:33.100Z | 2024-11-22T14:23:14.489Z |
5546385 | 5546385 | 20241117103857_Dpfk1 | US0039 | 2024-11-18T14:02:58.617Z | 2024-11-22T14:22:31.642Z |
5546287 | 5546287 | 20241117101221_tgV3q | US0039 | 2024-11-18T14:02:42.288Z | 2024-11-22T14:22:30.817Z |
5546281 | 5546281 | 20241117101044_msJt3 | US0039 | 2024-11-18T14:02:40.720Z | 2024-11-22T14:22:30.770Z |
5546231 | 5546231 | 20241117095816_2FoFt | US0039 | 2024-11-18T14:02:30.961Z | 2024-11-22T14:22:30.412Z |
5546184 | 5546184 | 20241117093646_vX9bC | US0039 | 2024-11-18T14:02:24.041Z | 2024-11-22T14:22:29.920Z |
5546106 | 5546106 | 20241117091453_P1M76 | US0039 | 2024-11-18T14:02:04.842Z | 2024-11-22T14:22:29.076Z |
5545980 | 5545980 | 20241117083122_lUyWA | US0039 | 2024-11-18T14:01:37.837Z | 2024-11-22T14:22:27.771Z |
5545952 | 5545952 | 20241117081517_XgE5c | US0039 | 2024-11-18T14:01:33.061Z | 2024-11-22T14:22:27.512Z |
5545816 | 5545816 | 20241117071035_i26p0 | US0039 | 2024-11-18T14:01:02.062Z | 2024-11-22T14:22:26.405Z |
5539079 | 5539079 | 20241113054107_9tPKy | US0039 | 2024-11-14T14:14:11.342Z | 2024-11-21T14:26:31.568Z |
5538982 | 5538982 | 20241113052817_267rO | US0039 | 2024-11-14T14:14:06.959Z | 2024-11-21T14:26:30.748Z |
5538781 | 5538781 | 20241113045642_OLcwR | US0039 | 2024-11-14T14:13:57.228Z | 2024-11-21T14:26:28.717Z |
5538704 | 5538704 | 20241113044005_I0oWc | US0039 | 2024-11-14T14:13:52.046Z | 2024-11-21T14:26:28.568Z |
5538542 | 5538542 | 20241113040705_GNlDM | US0039 | 2024-11-14T14:13:36.572Z | 2024-11-21T14:26:27.037Z |
5538182 | 5538182 | 20241113023045_2m4if | US0039 | 2024-11-14T14:13:01.091Z | 2024-11-21T14:26:21.562Z |
5538115 | 5538115 | 20241113021427_mZgvq | US0039 | 2024-11-14T14:12:52.032Z | 2024-11-21T14:26:20.828Z |
5538072 | 5538072 | 20241113020629_feTRl | US0039 | 2024-11-14T14:12:49.377Z | 2024-11-21T14:26:20.314Z |
5538035 | 5538035 | 20241113015900_vTiVU | US0039 | 2024-11-14T14:12:45.202Z | 2024-11-21T14:26:19.444Z |
5537947 | 5537947 | 20241113013926_MIvqp | US0039 | 2024-11-14T14:12:39.357Z | 2024-11-21T14:26:17.454Z |
5537819 | 5537819 | 20241113004554_unYeX | US0039 | 2024-11-14T14:12:31.729Z | 2024-11-21T14:26:16.373Z |
5533945 | 5533945 | 20241113103004_shs7M | US0039 | 2024-11-14T14:03:19.528Z | 2024-11-22T14:24:11.793Z |
5533926 | 5533926 | 20241113102749_4Gqon | US0039 | 2024-11-14T14:03:17.751Z | 2024-11-22T14:24:11.742Z |
5533830 | 5533830 | 20241113101637_3fmMC | US0039 | 2024-11-14T14:02:58.097Z | 2024-11-22T14:24:11.445Z |
5533717 | 5533717 | 20241113095426_4FWQL | US0039 | 2024-11-14T14:02:41.710Z | 2024-11-22T14:24:10.887Z |
5533652 | 5533652 | 20241113094046_X63wV | US0039 | 2024-11-14T14:02:34.171Z | 2024-11-22T14:24:10.615Z |
5533565 | 5533565 | 20241113092136_0khM3 | US0039 | 2024-11-14T14:02:25.241Z | 2024-11-22T14:24:10.215Z |
5533419 | 5533419 | 20241113085202_1vnpk | US0039 | 2024-11-14T14:01:55.677Z | 2024-11-22T14:24:09.211Z |
5533387 | 5533387 | 20241113084637_hQXDL | US0039 | 2024-11-14T14:01:50.062Z | 2024-11-22T14:24:08.908Z |
5533380 | 5533380 | 20241113084507_94Huu | US0039 | 2024-11-14T14:01:49.544Z | 2024-11-22T14:24:08.895Z |
5533220 | 5533220 | 20241113074807_Tyqw3 | US0039 | 2024-11-14T14:01:27.163Z | 2024-11-22T14:24:07.664Z |
5533100 | 5533100 | 20241113071412_T2kr9 | US0039 | 2024-11-14T14:01:08.195Z | 2024-11-22T14:24:07.074Z |
5533056 | 5533056 | 20241113065912_oe4DR | US0039 | 2024-11-14T14:01:00.936Z | 2024-11-22T14:24:06.840Z |
5532923 | 5532923 | 20241113061758_b2Axp | US0039 | 2024-11-14T14:00:33.134Z | 2024-11-22T14:24:06.076Z |
5529188 | 5529188 | 20241111234500_IIo2G | US0039 | 2024-11-13T14:12:12.628Z | 2024-11-20T14:25:41.686Z |
5527043 | 5527043 | 20241112105212_Ke6Dz | US0039 | 2024-11-13T14:04:55.130Z | 2024-11-21T14:25:40.782Z |
5526743 | 5526743 | 20241112100901_NfMWZ | US0039 | 2024-11-13T14:04:03.817Z | 2024-11-21T14:25:37.546Z |
5526631 | 5526631 | 20241112095656_3Bcvn | US0039 | 2024-11-13T14:03:40.521Z | 2024-11-21T14:25:36.875Z |
5526518 | 5526518 | 20241112093755_kTYbu | US0039 | 2024-11-13T14:03:23.199Z | 2024-11-21T14:25:36.080Z |
5516947 | 5516947 | 20241110022456_nns85 | US0039 | 2024-11-11T14:13:36.234Z | 2024-11-18T14:26:33.961Z |
5511369 | 5511369 | 20241109055747_oAL4P | US0039 | 2024-11-10T14:16:43.757Z | 2024-11-17T14:24:08.321Z |
5511132 | 5511132 | 20241109043645_eql0k | US0039 | 2024-11-10T14:16:19.158Z | 2024-11-17T14:24:05.482Z |
5510929 | 5510929 | 20241109035621_znGE9 | US0039 | 2024-11-10T14:15:57.291Z | 2024-11-17T14:24:02.666Z |
5510853 | 5510853 | 20241109034438_LUBp6 | US0039 | 2024-11-10T14:15:46.500Z | 2024-11-17T14:24:01.821Z |
5510645 | 5510645 | 20241109031844_08nF1 | US0039 | 2024-11-10T14:15:31.267Z | 2024-11-17T14:23:59.941Z |
5510574 | 5510574 | 20241109030242_fWeUj | US0039 | 2024-11-10T14:15:27.473Z | 2024-11-17T14:23:59.203Z |
5510124 | 5510124 | 20241109014538_HCWdu | US0039 | 2024-11-10T14:14:37.993Z | 2024-11-17T14:23:53.144Z |
5510037 | 5510037 | 20241109013230_bQlFl | US0039 | 2024-11-10T14:14:29.746Z | 2024-11-17T14:23:52.266Z |
5510004 | 5510004 | 20241109012558_QqfLV | US0039 | 2024-11-10T14:14:25.998Z | 2024-11-17T14:23:51.727Z |
5509940 | 5509940 | 20241109011302_IwZ0Q | US0039 | 2024-11-10T14:14:18.106Z | 2024-11-17T14:23:51.304Z |
5509926 | 5509926 | 20241109011021_z23W7 | US0039 | 2024-11-10T14:14:16.736Z | 2024-11-17T14:23:51.238Z |
5509718 | 5509718 | 20241109001836_ZDS6e | US0039 | 2024-11-10T14:13:53.588Z | 2024-11-17T14:23:48.528Z |
5509549 | 5509549 | 20241108234357_wy2Wx | US0039 | 2024-11-10T14:13:33.921Z | 2024-11-17T14:23:46.752Z |
5509460 | 5509460 | 20241108232102_iutDI | US0039 | 2024-11-10T14:13:24.673Z | 2024-11-17T14:23:44.777Z |
5509408 | 5509408 | 20241108231328_hgmoy | US0039 | 2024-11-10T14:13:20.042Z | 2024-11-17T14:23:44.105Z |
5507075 | 5507075 | 20241109102549_N2IeO | US0039 | 2024-11-10T14:04:12.758Z | 2024-11-18T14:26:06.755Z |
5507030 | 5507030 | 20241109101722_X7EU3 | US0039 | 2024-11-10T14:04:05.605Z | 2024-11-18T14:26:06.038Z |
5506738 | 5506738 | 20241109093007_Rz8Lm | US0039 | 2024-11-10T14:03:13.793Z | 2024-11-18T14:26:01.972Z |
5506602 | 5506602 | 20241109090758_DZARY | US0039 | 2024-11-10T14:02:41.064Z | 2024-11-18T14:26:00.949Z |
5506491 | 5506491 | 20241109084706_ISeCU | US0039 | 2024-11-10T14:02:24.366Z | 2024-11-18T14:25:59.926Z |
5506218 | 5506218 | 20241109075755_YnEDE | US0039 | 2024-11-10T14:01:35.608Z | 2024-11-18T14:25:57.646Z |
5506109 | 5506109 | 20241109074127_E8KTr | US0039 | 2024-11-10T14:01:14.857Z | 2024-11-18T14:25:56.557Z |
5506070 | 5506070 | 20241109073342_ewWEh | US0039 | 2024-11-10T14:01:09.876Z | 2024-11-18T14:25:56.269Z |
5506038 | 5506038 | 20241109073006_3zme0 | US0039 | 2024-11-10T14:01:05.689Z | 2024-11-18T14:25:55.883Z |
5505984 | 5505984 | 20241109071550_Ql8lj | US0039 | 2024-11-10T14:00:58.437Z | 2024-11-18T14:25:55.319Z |
5505857 | 5505857 | 20241109065121_I7VPO | US0039 | 2024-11-10T14:00:36.155Z | 2024-11-18T14:25:53.333Z |
5505840 | 5505840 | 20241109064744_g2zQK | US0039 | 2024-11-10T14:00:32.976Z | 2024-11-18T14:25:53.127Z |
5505771 | 5505771 | 20241109063451_jznGk | US0039 | 2024-11-10T14:00:21.883Z | 2024-11-18T14:25:52.456Z |
5505766 | 5505766 | 20241109063406_vTm2w | US0039 | 2024-11-10T14:00:20.826Z | 2024-11-18T14:25:52.328Z |
5505553 | 5505553 | 20241108060634_1pLan | US0039 | 2024-11-09T14:16:23.112Z | 2024-11-16T14:28:33.473Z |
5505489 | 5505489 | 20241108054051_K3W8l | US0039 | 2024-11-09T14:16:20.548Z | 2024-11-16T14:28:32.913Z |
5504712 | 5504712 | 20241108024255_W4E3n | US0039 | 2024-11-09T14:15:05.476Z | 2024-11-16T14:28:22.759Z |
5504706 | 5504706 | 20241108024210_n5fyK | US0039 | 2024-11-09T14:15:05.201Z | 2024-11-16T14:28:22.736Z |
5504488 | 5504488 | 20241108020609_3Okou | US0039 | 2024-11-09T14:14:44.729Z | 2024-11-16T14:28:20.580Z |
5504202 | 5504202 | 20241108011327_aHH6l | US0039 | 2024-11-09T14:14:13.451Z | 2024-11-16T14:28:17.687Z |
5504010 | 5504010 | 20241108003914_3ssYn | US0039 | 2024-11-09T14:13:58.372Z | 2024-11-16T14:28:14.967Z |
5503746 | 5503746 | 20241107234327_oAUsC | US0039 | 2024-11-09T14:13:42.318Z | 2024-11-16T14:28:12.139Z |
5498900 | 5498900 | 20241108102216_4zOjw | US0039 | 2024-11-09T14:02:44.671Z | 2024-11-17T14:23:01.244Z |
5498701 | 5498701 | 20241108093822_MJxMM | US0039 | 2024-11-09T14:02:13.553Z | 2024-11-17T14:22:59.126Z |
5498661 | 5498661 | 20241108093301_0H0ao | US0039 | 2024-11-09T14:02:07.557Z | 2024-11-17T14:22:58.746Z |
5498588 | 5498588 | 20241108091418_UGthZ | US0039 | 2024-11-09T14:01:53.114Z | 2024-11-17T14:22:58.139Z |
5498567 | 5498567 | 20241108090925_bM31H | US0039 | 2024-11-09T14:01:48.050Z | 2024-11-17T14:22:57.849Z |
5498557 | 5498557 | 20241108090641_rbnlE | US0039 | 2024-11-09T14:01:46.839Z | 2024-11-17T14:22:57.758Z |
5498512 | 5498512 | 20241108085320_UK4R4 | US0039 | 2024-11-09T14:01:40.839Z | 2024-11-17T14:22:56.672Z |
Advanced export
JSON shape: default, array, newline-delimited
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);