participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,786 rows where station_code = "USL00K" 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 |
---|---|---|---|---|---|
5563761 | 5563761 | 20241120020215_PB9BV | USL00K | 2024-11-21T14:16:41.152Z | 2024-11-21T14:18:53.911Z |
5563693 | 5563693 | 20241120015741_F0P43 | USL00K | 2024-11-21T14:16:34.782Z | 2024-11-21T14:18:53.902Z |
5563637 | 5563637 | 20241120015356_ynYuk | USL00K | 2024-11-21T14:16:31.051Z | 2024-11-21T14:18:53.894Z |
5558885 | 5558885 | 20241120084330_RyIyo | USL00K | 2024-11-21T14:04:43.608Z | 2024-11-21T14:04:43.608Z |
5558310 | 5558310 | 20241120055457_C3ypp | USL00K | 2024-11-21T14:02:59.607Z | 2024-11-21T14:02:59.607Z |
5558247 | 5558247 | 20241120054822_p2f8n | USL00K | 2024-11-21T14:02:51.775Z | 2024-11-21T14:02:51.775Z |
5558001 | 5558001 | 20241120052940_yOY7c | USL00K | 2024-11-21T14:02:14.873Z | 2024-11-21T14:02:14.873Z |
5557547 | 5557547 | 20241120045457_XbkLN | USL00K | 2024-11-21T14:01:08.682Z | 2024-11-21T14:01:08.682Z |
5557516 | 5557516 | 20241120045251_73VMa | USL00K | 2024-11-21T14:01:04.114Z | 2024-11-21T14:01:04.114Z |
5557230 | 5557230 | 20241119044148_NHT0z | USL00K | 2024-11-20T14:12:29.466Z | 2024-11-21T14:20:50.589Z |
5556725 | 5556725 | 20241119013103_Zzg03 | USL00K | 2024-11-20T14:11:22.429Z | 2024-11-21T14:20:33.371Z |
5553986 | 5553986 | 20241119050836_QVKv7 | USL00K | 2024-11-20T14:00:18.423Z | 2024-11-21T14:18:52.949Z |
5553625 | 5553625 | 20241118033358_8zUBv | USL00K | 2024-11-19T14:11:05.746Z | 2024-11-21T14:22:18.004Z |
5541034 | 5541034 | 20241114125404_BZ5sZ | USL00K | 2024-11-15T14:04:57.750Z | 2024-11-21T14:24:18.501Z |
5540746 | 5540746 | 20241114120139_uTFA3 | USL00K | 2024-11-15T14:04:23.910Z | 2024-11-21T14:24:15.398Z |
5540742 | 5540742 | 20241114115905_3jiaR | USL00K | 2024-11-15T14:04:23.211Z | 2024-11-21T14:24:15.268Z |
5540733 | 5540733 | 20241114115709_ekxyI | USL00K | 2024-11-15T14:04:21.760Z | 2024-11-21T14:24:15.159Z |
5540724 | 5540724 | 20241114115520_U2v5h | USL00K | 2024-11-15T14:04:20.726Z | 2024-11-21T14:24:15.064Z |
5540717 | 5540717 | 20241114115501_Y5uQE | USL00K | 2024-11-15T14:04:20.255Z | 2024-11-21T14:24:14.830Z |
5540657 | 5540657 | 20241114114803_rUVdi | USL00K | 2024-11-15T14:04:14.332Z | 2024-11-21T14:24:14.394Z |
5540262 | 5540262 | 20241114103047_cPBrJ | USL00K | 2024-11-15T14:03:12.196Z | 2024-11-21T14:24:09.527Z |
5535601 | 5535601 | 20241112125751_lRisR | USL00K | 2024-11-14T14:08:09.748Z | 2024-11-21T14:25:50.425Z |
5535560 | 5535560 | 20241112124931_VzKlO | USL00K | 2024-11-14T14:08:05.158Z | 2024-11-21T14:25:50.094Z |
5535551 | 5535551 | 20241112124756_FI2yx | USL00K | 2024-11-14T14:08:04.455Z | 2024-11-21T14:25:49.995Z |
5535546 | 5535546 | 20241112124736_WUBsm | USL00K | 2024-11-14T14:08:04.030Z | 2024-11-21T14:25:49.851Z |
5535422 | 5535422 | 20241112122503_eZLG0 | USL00K | 2024-11-14T14:07:54.939Z | 2024-11-21T14:25:47.979Z |
5535218 | 5535218 | 20241112115744_gHY3C | USL00K | 2024-11-14T14:07:32.526Z | 2024-11-21T14:25:45.132Z |
5534228 | 5534228 | 20241113112251_qiD58 | USL00K | 2024-11-14T14:03:52.037Z | 2024-11-21T14:25:00.103Z |
5534156 | 5534156 | 20241113110951_dH51b | USL00K | 2024-11-14T14:03:40.833Z | 2024-11-21T14:24:59.495Z |
5534103 | 5534103 | 20241113110101_u4O9p | USL00K | 2024-11-14T14:03:34.271Z | 2024-11-21T14:24:58.759Z |
5534037 | 5534037 | 20241113104728_SDyUK | USL00K | 2024-11-14T14:03:28.651Z | 2024-11-21T14:24:58.350Z |
5533824 | 5533824 | 20241113101551_XEzMC | USL00K | 2024-11-14T14:02:56.366Z | 2024-11-21T14:24:55.730Z |
5533780 | 5533780 | 20241113100701_Ed2DC | USL00K | 2024-11-14T14:02:47.534Z | 2024-11-21T14:24:55.134Z |
5530472 | 5530472 | 20241112022112_LjJKs | USL00K | 2024-11-13T14:14:17.516Z | 2024-11-20T14:26:00.640Z |
5530281 | 5530281 | 20241112020507_a3yf1 | USL00K | 2024-11-13T14:14:06.860Z | 2024-11-20T14:25:56.504Z |
5527075 | 5527075 | 20241112105824_ut16G | USL00K | 2024-11-13T14:04:59.236Z | 2024-11-21T14:25:41.008Z |
5527034 | 5527034 | 20241112105002_w5NIn | USL00K | 2024-11-13T14:04:53.786Z | 2024-11-21T14:25:40.757Z |
5526120 | 5526120 | 20241112080918_yDf2S | USL00K | 2024-11-13T14:01:57.420Z | 2024-11-21T14:25:30.569Z |
5524521 | 5524521 | 20241111042527_LLSos | USL00K | 2024-11-12T14:17:33.817Z | 2024-11-19T14:22:21.937Z |
5524384 | 5524384 | 20241111040446_M3zAC | USL00K | 2024-11-12T14:17:12.972Z | 2024-11-19T14:22:20.884Z |
5523848 | 5523848 | 20241111023818_2tLIX | USL00K | 2024-11-12T14:16:16.956Z | 2024-11-19T14:22:15.545Z |
5519506 | 5519506 | 20241111114126_COrSu | USL00K | 2024-11-12T14:04:18.141Z | 2024-11-20T14:24:51.371Z |
5519481 | 5519481 | 20241111113503_VbDqz | USL00K | 2024-11-12T14:04:09.169Z | 2024-11-20T14:24:50.966Z |
5519444 | 5519444 | 20241111112457_DJl7W | USL00K | 2024-11-12T14:04:02.168Z | 2024-11-20T14:24:50.409Z |
5519310 | 5519310 | 20241111105709_ngopu | USL00K | 2024-11-12T14:03:43.410Z | 2024-11-20T14:24:47.298Z |
5519164 | 5519164 | 20241111102852_OztkJ | USL00K | 2024-11-12T14:03:14.040Z | 2024-11-20T14:24:46.045Z |
5519020 | 5519020 | 20241111095653_wEmwI | USL00K | 2024-11-12T14:02:41.861Z | 2024-11-20T14:24:44.028Z |
5518899 | 5518899 | 20241111092901_G68nK | USL00K | 2024-11-12T14:02:18.141Z | 2024-11-20T14:24:42.599Z |
5518811 | 5518811 | 20241111091602_3clIH | USL00K | 2024-11-12T14:02:08.668Z | 2024-11-20T14:24:41.567Z |
5518731 | 5518731 | 20241111090146_NoO5V | USL00K | 2024-11-12T14:01:48.137Z | 2024-11-20T14:24:40.625Z |
5518724 | 5518724 | 20241111085957_aFDPE | USL00K | 2024-11-12T14:01:47.241Z | 2024-11-20T14:24:40.541Z |
5518613 | 5518613 | 20241111083749_3Pqlw | USL00K | 2024-11-12T14:01:30.891Z | 2024-11-20T14:24:37.888Z |
5518532 | 5518532 | 20241111081205_SMXYq | USL00K | 2024-11-12T14:01:13.678Z | 2024-11-20T14:24:35.926Z |
5518441 | 5518441 | 20241111075012_0oIoS | USL00K | 2024-11-12T14:00:57.131Z | 2024-11-20T14:24:34.425Z |
5518428 | 5518428 | 20241111074711_TwzHV | USL00K | 2024-11-12T14:00:54.779Z | 2024-11-20T14:24:34.155Z |
5518234 | 5518234 | 20241111062643_wLIp8 | USL00K | 2024-11-12T14:00:19.613Z | 2024-11-20T14:24:30.377Z |
5517220 | 5517220 | 20241110030642_Y64hg | USL00K | 2024-11-11T14:14:06.710Z | 2024-11-18T14:26:35.422Z |
5513787 | 5513787 | 20241110122102_YqWvx | USL00K | 2024-11-11T14:05:27.951Z | 2024-11-19T14:21:37.715Z |
5513427 | 5513427 | 20241110113030_vv6T9 | USL00K | 2024-11-11T14:04:38.136Z | 2024-11-19T14:21:34.161Z |
5513149 | 5513149 | 20241110104450_WFasq | USL00K | 2024-11-11T14:03:59.313Z | 2024-11-19T14:21:31.614Z |
5512870 | 5512870 | 20241110100306_kdvHz | USL00K | 2024-11-11T14:03:22.583Z | 2024-11-19T14:21:29.085Z |
5512803 | 5512803 | 20241110094939_DnA1N | USL00K | 2024-11-11T14:03:10.040Z | 2024-11-19T14:21:28.525Z |
5512651 | 5512651 | 20241110092344_I0IcQ | USL00K | 2024-11-11T14:02:53.872Z | 2024-11-19T14:21:26.987Z |
5512453 | 5512453 | 20241110085235_DEfql | USL00K | 2024-11-11T14:02:21.287Z | 2024-11-19T14:21:24.808Z |
5512273 | 5512273 | 20241110082503_N0Mut | USL00K | 2024-11-11T14:02:00.054Z | 2024-11-19T14:21:22.373Z |
5512259 | 5512259 | 20241110082231_RSrUy | USL00K | 2024-11-11T14:01:57.955Z | 2024-11-19T14:21:22.270Z |
5512210 | 5512210 | 20241110081500_SGe3P | USL00K | 2024-11-11T14:01:43.160Z | 2024-11-19T14:21:21.730Z |
5512164 | 5512164 | 20241110080728_R8aWp | USL00K | 2024-11-11T14:01:38.900Z | 2024-11-19T14:21:21.071Z |
5511955 | 5511955 | 20241110073111_nHi2Q | USL00K | 2024-11-11T14:01:12.293Z | 2024-11-19T14:21:17.941Z |
5511925 | 5511925 | 20241110072251_9vzKR | USL00K | 2024-11-11T14:01:06.651Z | 2024-11-19T14:21:17.609Z |
5511303 | 5511303 | 20241109053613_qtmyL | USL00K | 2024-11-10T14:16:38.754Z | 2024-11-17T14:24:07.775Z |
5511276 | 5511276 | 20241109052957_2v8iM | USL00K | 2024-11-10T14:16:37.404Z | 2024-11-17T14:24:07.672Z |
5511218 | 5511218 | 20241109050840_hVQx3 | USL00K | 2024-11-10T14:16:31.009Z | 2024-11-17T14:24:06.940Z |
5511184 | 5511184 | 20241109045713_2tRUa | USL00K | 2024-11-10T14:16:26.478Z | 2024-11-17T14:24:06.303Z |
5510623 | 5510623 | 20241109031449_2dYOA | USL00K | 2024-11-10T14:15:30.269Z | 2024-11-17T14:23:59.811Z |
5510498 | 5510498 | 20241109024756_maQR7 | USL00K | 2024-11-10T14:15:22.922Z | 2024-11-17T14:23:58.412Z |
5510377 | 5510377 | 20241109022915_mIHF7 | USL00K | 2024-11-10T14:15:06.934Z | 2024-11-17T14:23:56.692Z |
5507916 | 5507916 | 20241109125441_MBhfy | USL00K | 2024-11-10T14:06:27.147Z | 2024-11-18T14:26:16.369Z |
5507890 | 5507890 | 20241109124648_IA33u | USL00K | 2024-11-10T14:06:23.743Z | 2024-11-18T14:26:15.871Z |
5507861 | 5507861 | 20241109124054_3jxuq | USL00K | 2024-11-10T14:06:20.643Z | 2024-11-18T14:26:15.542Z |
5507825 | 5507825 | 20241109123335_I4tmE | USL00K | 2024-11-10T14:06:16.740Z | 2024-11-18T14:26:15.085Z |
5507740 | 5507740 | 20241109121813_k8Isn | USL00K | 2024-11-10T14:05:57.999Z | 2024-11-18T14:26:13.965Z |
5507608 | 5507608 | 20241109115756_1XquI | USL00K | 2024-11-10T14:05:36.852Z | 2024-11-18T14:26:12.387Z |
5507583 | 5507583 | 20241109115600_37VcT | USL00K | 2024-11-10T14:05:35.312Z | 2024-11-18T14:26:12.178Z |
5507565 | 5507565 | 20241109115334_QmyPN | USL00K | 2024-11-10T14:05:33.591Z | 2024-11-18T14:26:12.037Z |
5507478 | 5507478 | 20241109113526_LxsxH | USL00K | 2024-11-10T14:05:23.437Z | 2024-11-18T14:26:11.163Z |
5507303 | 5507303 | 20241109110923_Mmhqz | USL00K | 2024-11-10T14:04:47.755Z | 2024-11-18T14:26:09.452Z |
5507132 | 5507132 | 20241109103452_eOFZ1 | USL00K | 2024-11-10T14:04:21.942Z | 2024-11-18T14:26:07.392Z |
5506838 | 5506838 | 20241109094553_pcnsx | USL00K | 2024-11-10T14:03:28.454Z | 2024-11-18T14:26:02.821Z |
5506555 | 5506555 | 20241109085906_KRu99 | USL00K | 2024-11-10T14:02:33.269Z | 2024-11-18T14:26:00.558Z |
5506510 | 5506510 | 20241109085046_nm2M5 | USL00K | 2024-11-10T14:02:26.388Z | 2024-11-18T14:26:00.103Z |
5506481 | 5506481 | 20241109084441_XWkkO | USL00K | 2024-11-10T14:02:22.911Z | 2024-11-18T14:25:59.839Z |
5506474 | 5506474 | 20241109084403_jy308 | USL00K | 2024-11-10T14:02:21.545Z | 2024-11-18T14:25:59.706Z |
5506437 | 5506437 | 20241109083915_dtJTD | USL00K | 2024-11-10T14:02:16.731Z | 2024-11-18T14:25:59.339Z |
5506325 | 5506325 | 20241109082036_nRp5X | USL00K | 2024-11-10T14:01:49.767Z | 2024-11-18T14:25:58.522Z |
5506267 | 5506267 | 20241109080754_axFmc | USL00K | 2024-11-10T14:01:42.633Z | 2024-11-18T14:25:58.059Z |
5506209 | 5506209 | 20241109075620_XQDba | USL00K | 2024-11-10T14:01:34.439Z | 2024-11-18T14:25:57.502Z |
5506143 | 5506143 | 20241109074420_z35eW | USL00K | 2024-11-10T14:01:19.461Z | 2024-11-18T14:25:56.832Z |
5506090 | 5506090 | 20241109073614_ryiKr | USL00K | 2024-11-10T14:01:11.641Z | 2024-11-18T14:25:56.398Z |
5505938 | 5505938 | 20241109070747_9AEzm | USL00K | 2024-11-10T14:00:50.318Z | 2024-11-18T14:25:54.823Z |
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);