participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,406 rows where station_code = "USL010" 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 |
---|---|---|---|---|---|
6106003 | 6106003 | 20250216121701_Y5kLL | USL010 | 2025-02-17T14:06:59.054Z | 2025-02-17T14:10:28.864Z |
6103746 | 6103746 | 20250215130947_5x2km | USL010 | 2025-02-16T14:04:56.833Z | 2025-02-17T14:12:46.016Z |
6093573 | 6093573 | 20250209103553_7wMbt | USL010 | 2025-02-10T14:04:59.658Z | 2025-02-17T14:24:44.782Z |
6093483 | 6093483 | 20250209091903_JFyyc | USL010 | 2025-02-10T14:04:38.726Z | 2025-02-17T14:24:40.644Z |
6086472 | 6086472 | 20250207125836_EEp4f | USL010 | 2025-02-08T14:11:53.864Z | 2025-02-15T14:29:02.594Z |
6085816 | 6085816 | 20250207105157_fFzpy | USL010 | 2025-02-08T14:09:53.056Z | 2025-02-15T14:27:57.923Z |
6085708 | 6085708 | 20250207102352_Sn2pa | USL010 | 2025-02-08T14:09:29.447Z | 2025-02-15T14:27:47.248Z |
6085649 | 6085649 | 20250207100827_d2CHy | USL010 | 2025-02-08T14:09:15.548Z | 2025-02-15T14:27:43.679Z |
6085501 | 6085501 | 20250207091930_Kbih3 | USL010 | 2025-02-08T14:08:45.081Z | 2025-02-15T14:27:27.874Z |
6073075 | 6073075 | 20250205082445_nwtCz | USL010 | 2025-02-07T14:26:00.929Z | 2025-02-13T14:35:08.853Z |
6072751 | 6072751 | 20250205062453_Xomj9 | USL010 | 2025-02-07T14:25:20.007Z | 2025-02-13T14:34:57.969Z |
6066318 | 6066318 | 20250206123404_22vmw | USL010 | 2025-02-07T14:14:32.140Z | 2025-02-14T14:29:48.316Z |
6065609 | 6065609 | 20250206105139_6fxLg | USL010 | 2025-02-07T14:12:46.699Z | 2025-02-14T14:29:12.795Z |
6057864 | 6057864 | 20250204125217_DYVYn | USL010 | 2025-02-05T14:11:42.194Z | 2025-02-12T14:46:53.453Z |
6057852 | 6057852 | 20250204124820_xIEUL | USL010 | 2025-02-05T14:11:40.878Z | 2025-02-12T14:46:52.400Z |
6057756 | 6057756 | 20250204120314_kitdd | USL010 | 2025-02-05T14:11:23.071Z | 2025-02-12T14:46:38.419Z |
6057688 | 6057688 | 20250204113604_hQg55 | USL010 | 2025-02-05T14:11:14.362Z | 2025-02-12T14:46:28.710Z |
6057178 | 6057178 | 20250204083945_PJvSx | USL010 | 2025-02-05T14:09:59.638Z | 2025-02-12T14:45:30.164Z |
6050967 | 6050967 | 20250203122726_z6INQ | USL010 | 2025-02-04T14:15:15.287Z | 2025-02-11T14:40:33.691Z |
6050497 | 6050497 | 20250203113055_3YmD3 | USL010 | 2025-02-04T14:14:16.486Z | 2025-02-11T14:40:11.541Z |
6050116 | 6050116 | 20250203103521_GkxOz | USL010 | 2025-02-04T14:13:26.835Z | 2025-02-11T14:39:56.836Z |
6050114 | 6050114 | 20250203103520_bKDDP | USL010 | 2025-02-04T14:13:26.620Z | 2025-02-11T14:39:56.770Z |
6049820 | 6049820 | 20250203095753_FA505 | USL010 | 2025-02-04T14:12:48.342Z | 2025-02-11T14:39:41.782Z |
6048926 | 6048926 | 20250203053932_oatgr | USL010 | 2025-02-04T14:10:19.554Z | 2025-02-11T14:39:01.258Z |
6042898 | 6042898 | 20250202130032_YXtWf | USL010 | 2025-02-03T14:15:06.435Z | 2025-02-10T14:56:59.504Z |
6042508 | 6042508 | 20250202122120_IOZKK | USL010 | 2025-02-03T14:14:29.065Z | 2025-02-10T14:56:36.721Z |
6041809 | 6041809 | 20250202110225_XrAHk | USL010 | 2025-02-03T14:13:04.579Z | 2025-02-10T14:56:02.504Z |
6041398 | 6041398 | 20250202094432_xUuxi | USL010 | 2025-02-03T14:11:52.402Z | 2025-02-10T14:55:50.072Z |
6041375 | 6041375 | 20250202094110_QqIh4 | USL010 | 2025-02-03T14:11:49.896Z | 2025-02-10T14:55:48.910Z |
6041359 | 6041359 | 20250202093612_lC9sE | USL010 | 2025-02-03T14:11:48.036Z | 2025-02-10T14:55:46.878Z |
6040898 | 6040898 | 20250202064437_vwX34 | USL010 | 2025-02-03T14:10:30.373Z | 2025-02-10T14:55:03.860Z |
6026743 | 6026743 | 20250131074150_i2ycX | USL010 | 2025-02-01T14:07:41.854Z | 2025-02-02T14:16:28.576Z |
6022798 | 6022798 | 20250130115234_hcOtc | USL010 | 2025-01-31T14:11:03.886Z | 2025-02-08T15:10:33.786Z |
6022767 | 6022767 | 20250130114157_CtMYg | USL010 | 2025-01-31T14:10:59.627Z | 2025-02-08T15:10:31.935Z |
6022520 | 6022520 | 20250130100952_ZCjXK | USL010 | 2025-01-31T14:10:18.175Z | 2025-02-08T15:10:21.860Z |
6012057 | 6012057 | 20250129031217_7qxgG | USL010 | 2025-01-30T14:03:30.841Z | 2025-02-07T14:57:06.769Z |
6008853 | 6008853 | 20250128124427_27Qxf | USL010 | 2025-01-29T14:09:36.909Z | 2025-02-06T14:46:38.463Z |
6008610 | 6008610 | 20250128115352_x66xy | USL010 | 2025-01-29T14:08:47.923Z | 2025-02-06T14:46:28.951Z |
6008564 | 6008564 | 20250128114454_oS0XK | USL010 | 2025-01-29T14:08:36.192Z | 2025-02-06T14:46:27.107Z |
6008514 | 6008514 | 20250128113621_3Scr0 | USL010 | 2025-01-29T14:08:29.694Z | 2025-02-06T14:46:25.894Z |
6007972 | 6007972 | 20250128095258_SDq92 | USL010 | 2025-01-29T14:06:42.013Z | 2025-02-06T14:45:42.799Z |
6007482 | 6007482 | 20250128071743_bYmFz | USL010 | 2025-01-29T14:04:54.676Z | 2025-02-06T14:45:21.527Z |
6006807 | 6006807 | 20250128031556_QJyjR | USL010 | 2025-01-29T14:02:17.842Z | 2025-02-06T14:44:33.412Z |
6003663 | 6003663 | 20250127125950_r3G6h | USL010 | 2025-01-28T14:12:03.237Z | 2025-02-05T14:39:14.247Z |
6003420 | 6003420 | 20250127123556_Oz0yZ | USL010 | 2025-01-28T14:11:29.287Z | 2025-02-05T14:39:10.444Z |
6002787 | 6002787 | 20250127112810_RCTGe | USL010 | 2025-01-28T14:10:04.358Z | 2025-02-05T14:39:01.075Z |
5996263 | 5996263 | 20250126094202_Lgh9B | USL010 | 2025-01-27T14:06:47.610Z | 2025-02-04T14:33:31.033Z |
5995236 | 5995236 | 20250126040946_SXjSg | USL010 | 2025-01-27T14:03:19.452Z | 2025-02-04T14:33:26.866Z |
5993156 | 5993156 | 20250125115043_2q13T | USL010 | 2025-01-26T14:07:31.377Z | 2025-02-03T14:34:40.918Z |
5988802 | 5988802 | 20250124125104_7p5NQ | USL010 | 2025-01-25T14:09:52.904Z | 2025-02-02T14:37:06.436Z |
5988406 | 5988406 | 20250124120034_Z33zN | USL010 | 2025-01-25T14:08:37.039Z | 2025-02-02T14:37:01.401Z |
5988404 | 5988404 | 20250124120034_pqUsm | USL010 | 2025-01-25T14:08:36.816Z | 2025-02-02T14:37:01.388Z |
5987897 | 5987897 | 20250124103920_e3fPY | USL010 | 2025-01-25T14:06:29.205Z | 2025-02-02T14:36:54.270Z |
5987498 | 5987498 | 20250124093814_6tf4H | USL010 | 2025-01-25T14:05:11.805Z | 2025-02-02T14:36:48.263Z |
5987375 | 5987375 | 20250124091807_3goye | USL010 | 2025-01-25T14:04:39.337Z | 2025-02-02T14:36:46.323Z |
5986869 | 5986869 | 20250124065307_hFzo7 | USL010 | 2025-01-25T14:02:29.397Z | 2025-02-02T14:36:40.310Z |
5986366 | 5986366 | 20250124023229_VCASm | USL010 | 2025-01-25T14:00:11.373Z | 2025-02-02T14:36:29.074Z |
5981381 | 5981381 | 20250123092724_u0o1E | USL010 | 2025-01-24T14:04:43.532Z | 2025-02-01T14:39:53.699Z |
5980173 | 5980173 | 20250121021921_Ukr9H | USL010 | 2025-01-23T14:24:28.902Z | 2025-01-29T14:36:18.129Z |
5977408 | 5977408 | 20250121111213_3JJ2q | USL010 | 2025-01-23T14:16:27.515Z | 2025-01-30T14:33:23.267Z |
5976874 | 5976874 | 20250121093227_mOTc3 | USL010 | 2025-01-23T14:15:30.943Z | 2025-01-30T14:33:14.067Z |
5976694 | 5976694 | 20250121084445_Ccmba | USL010 | 2025-01-23T14:15:11.515Z | 2025-01-30T14:33:10.441Z |
5976325 | 5976325 | 20250121053538_wVjfu | USL010 | 2025-01-23T14:14:05.017Z | 2025-01-30T14:32:59.849Z |
5974032 | 5974032 | 20250122115945_7RUVx | USL010 | 2025-01-23T14:08:32.298Z | 2025-01-31T14:35:01.258Z |
5973763 | 5973763 | 20250122113138_BfZPC | USL010 | 2025-01-23T14:07:46.581Z | 2025-01-31T14:34:56.613Z |
5973528 | 5973528 | 20250122105944_EIgqe | USL010 | 2025-01-23T14:07:04.090Z | 2025-01-31T14:34:52.918Z |
5972543 | 5972543 | 20250122074751_X3h3b | USL010 | 2025-01-23T14:03:33.368Z | 2025-01-31T14:34:36.826Z |
5972460 | 5972460 | 20250122072211_5L9YE | USL010 | 2025-01-23T14:03:14.584Z | 2025-01-31T14:34:34.204Z |
5971570 | 5971570 | 20250115031449_3V2jj | USL010 | 2025-01-22T14:33:13.483Z | 2025-01-23T14:33:43.143Z |
5967258 | 5967258 | 20250116131224_UYSRl | USL010 | 2025-01-22T14:27:45.208Z | 2025-01-25T14:39:30.159Z |
5967160 | 5967160 | 20250116125358_1NQ0d | USL010 | 2025-01-22T14:27:39.465Z | 2025-01-25T14:39:28.098Z |
5966706 | 5966706 | 20250119032111_2OUfM | USL010 | 2025-01-22T14:24:50.270Z | 2025-01-27T14:47:18.216Z |
5964462 | 5964462 | 20250118082046_UHPMZ | USL010 | 2025-01-22T14:19:05.569Z | 2025-01-27T14:43:53.831Z |
5962571 | 5962571 | 20250120125748_J0rAZ | USL010 | 2025-01-22T14:08:02.971Z | 2025-01-29T14:35:58.334Z |
5961173 | 5961173 | 20250120072409_ofD1K | USL010 | 2025-01-22T14:03:14.968Z | 2025-01-29T14:35:25.987Z |
5961028 | 5961028 | 20250120055438_SvDnT | USL010 | 2025-01-22T14:02:38.163Z | 2025-01-29T14:35:23.121Z |
5958482 | 5958482 | 20250119130409_eGsdm | USL010 | 2025-01-20T14:05:10.590Z | 2025-01-28T14:35:38.808Z |
5957103 | 5957103 | 20250118042656_dwkr6 | USL010 | 2025-01-19T14:09:07.248Z | 2025-01-26T14:34:55.454Z |
5956369 | 5956369 | 20250118131600_gxseW | USL010 | 2025-01-19T14:04:55.273Z | 2025-01-27T14:44:46.582Z |
5955377 | 5955377 | 20250118091229_lLGmB | USL010 | 2025-01-19T14:01:35.788Z | 2025-01-27T14:43:55.363Z |
5955249 | 5955249 | 20250118071900_TZjJP | USL010 | 2025-01-19T14:01:03.998Z | 2025-01-27T14:43:52.109Z |
5955205 | 5955205 | 20250118065548_6suOj | USL010 | 2025-01-19T14:00:54.475Z | 2025-01-27T14:43:51.279Z |
5954019 | 5954019 | 20250117133030_selag | USL010 | 2025-01-18T14:03:16.428Z | 2025-01-26T14:34:15.657Z |
5950582 | 5950582 | 20250114115901_yleJU | USL010 | 2025-01-15T14:01:59.823Z | 2025-01-23T14:33:21.440Z |
5949734 | 5949734 | 20250113020958_ymSMe | USL010 | 2025-01-14T14:07:51.917Z | 2025-01-21T14:20:05.493Z |
5948762 | 5948762 | 20250113124953_7zBG6 | USL010 | 2025-01-14T14:02:15.901Z | 2025-01-22T14:33:41.261Z |
5948698 | 5948698 | 20250113122615_Vw9l8 | USL010 | 2025-01-14T14:02:00.900Z | 2025-01-22T14:33:40.358Z |
5946725 | 5946725 | 20250112114955_hocG6 | USL010 | 2025-01-13T14:02:25.771Z | 2025-01-21T14:18:28.336Z |
5946580 | 5946580 | 20250112111015_H5sfG | USL010 | 2025-01-13T14:01:50.381Z | 2025-01-21T14:18:22.484Z |
5943345 | 5943345 | 20250110111231_3ankK | USL010 | 2025-01-11T14:03:41.077Z | 2025-01-19T14:18:28.750Z |
5942793 | 5942793 | 20250110091508_Hs3Vu | USL010 | 2025-01-11T14:00:58.997Z | 2025-01-19T14:18:12.570Z |
5925216 | 5925216 | 20250105121451_4Qa3Z | USL010 | 2025-01-07T14:05:47.842Z | 2025-01-14T14:25:50.107Z |
5924945 | 5924945 | 20250105114003_NF3Jd | USL010 | 2025-01-07T14:04:57.907Z | 2025-01-14T14:25:45.337Z |
5924576 | 5924576 | 20250105104909_Akj44 | USL010 | 2025-01-07T14:03:35.986Z | 2025-01-14T14:25:37.760Z |
5924009 | 5924009 | 20250106115015_07QSH | USL010 | 2025-01-07T14:01:36.021Z | 2025-01-15T14:25:21.711Z |
5923849 | 5923849 | 20250106111254_eso5r | USL010 | 2025-01-07T14:01:00.323Z | 2025-01-15T14:25:13.916Z |
5923788 | 5923788 | 20250106105300_AiVHB | USL010 | 2025-01-07T14:00:45.601Z | 2025-01-15T14:25:10.925Z |
5912824 | 5912824 | 20250103113954_Nir6d | USL010 | 2025-01-06T14:04:58.788Z | 2025-01-12T14:22:49.886Z |
5911258 | 5911258 | 20250103113245_10yh0 | USL010 | 2025-01-05T14:32:35.350Z | 2025-01-11T14:45:44.794Z |
5911248 | 5911248 | 20250103113140_hhRD9 | USL010 | 2025-01-05T14:32:34.976Z | 2025-01-11T14:45:44.626Z |
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);