participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,470 rows where station_code = "US002L" 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 |
---|---|---|---|---|---|
5133943 | 5133943 | 20240916041931_oqhuM | US002L | 2024-09-19T12:17:13.838Z | 2024-09-19T12:17:13.838Z |
5132427 | 5132427 | 20240916010619_A8cHV | US002L | 2024-09-19T12:16:12.274Z | 2024-09-19T12:16:12.274Z |
5123139 | 5123139 | 20240914090121_vz8ZS | US002L | 2024-09-18T12:11:40.790Z | 2024-09-19T12:20:08.402Z |
5122917 | 5122917 | 20240914082311_TzVT6 | US002L | 2024-09-18T12:11:34.094Z | 2024-09-19T12:20:06.690Z |
5122232 | 5122232 | 20240914050533_LD3OI | US002L | 2024-09-18T12:11:11.065Z | 2024-09-19T12:20:03.354Z |
5122167 | 5122167 | 20240914044331_S2W4U | US002L | 2024-09-18T12:11:08.218Z | 2024-09-19T12:20:02.903Z |
5121995 | 5121995 | 20240914042517_7oA9Z | US002L | 2024-09-18T12:11:04.169Z | 2024-09-19T12:20:02.576Z |
5117882 | 5117882 | 20240915073548_Tfm5o | US002L | 2024-09-18T12:08:04.705Z | 2024-09-19T12:19:18.716Z |
5117567 | 5117567 | 20240915053249_0CG9R | US002L | 2024-09-18T12:07:47.393Z | 2024-09-19T12:19:16.052Z |
5117562 | 5117562 | 20240915053022_CQd8M | US002L | 2024-09-18T12:07:47.140Z | 2024-09-19T12:19:15.984Z |
5117559 | 5117559 | 20240915052826_UmByb | US002L | 2024-09-18T12:07:46.941Z | 2024-09-19T12:19:15.962Z |
5108838 | 5108838 | 20240913074232_8GqoY | US002L | 2024-09-17T12:14:09.374Z | 2024-09-19T12:20:50.913Z |
5108754 | 5108754 | 20240913072308_vM838 | US002L | 2024-09-17T12:14:04.613Z | 2024-09-19T12:20:50.642Z |
5108682 | 5108682 | 20240913065931_VH2gH | US002L | 2024-09-17T12:13:57.507Z | 2024-09-19T12:20:50.293Z |
5106059 | 5106059 | 20240913030741_YcrrH | US002L | 2024-09-17T12:12:39.846Z | 2024-09-19T12:20:45.402Z |
5095248 | 5095248 | 20240912065220_rguJb | US002L | 2024-09-16T12:15:27.843Z | 2024-09-19T12:21:17.750Z |
5095122 | 5095122 | 20240912060439_Q8LrU | US002L | 2024-09-16T12:15:16.793Z | 2024-09-19T12:21:17.304Z |
5095118 | 5095118 | 20240912060039_oeBjk | US002L | 2024-09-16T12:15:15.345Z | 2024-09-19T12:21:17.300Z |
5095046 | 5095046 | 20240912052623_23elU | US002L | 2024-09-16T12:15:10.975Z | 2024-09-19T12:21:17.065Z |
5094952 | 5094952 | 20240912045122_zutSW | US002L | 2024-09-16T12:15:03.081Z | 2024-09-19T12:21:16.626Z |
5094470 | 5094470 | 20240912040422_aolHa | US002L | 2024-09-16T12:14:47.347Z | 2024-09-19T12:21:16.134Z |
5094134 | 5094134 | 20240912034929_p3yAX | US002L | 2024-09-16T12:14:36.556Z | 2024-09-19T12:21:15.896Z |
5082092 | 5082092 | 20240911092052_PvwM0 | US002L | 2024-09-15T12:18:02.765Z | 2024-09-19T12:21:47.176Z |
5081660 | 5081660 | 20240911081825_MONss | US002L | 2024-09-15T12:17:40.166Z | 2024-09-19T12:21:45.985Z |
5081469 | 5081469 | 20240911074736_H6Yz3 | US002L | 2024-09-15T12:17:34.819Z | 2024-09-19T12:21:45.456Z |
5081433 | 5081433 | 20240911074403_IhhXI | US002L | 2024-09-15T12:17:33.181Z | 2024-09-19T12:21:45.373Z |
5081411 | 5081411 | 20240911073909_tSqAc | US002L | 2024-09-15T12:17:32.481Z | 2024-09-19T12:21:45.276Z |
5081390 | 5081390 | 20240911073404_2ftC5 | US002L | 2024-09-15T12:17:31.958Z | 2024-09-19T12:21:45.233Z |
5080806 | 5080806 | 20240911045343_LKheL | US002L | 2024-09-15T12:17:14.039Z | 2024-09-19T12:21:43.697Z |
5080684 | 5080684 | 20240911042428_cvjVt | US002L | 2024-09-15T12:17:10.166Z | 2024-09-19T12:21:43.387Z |
5078742 | 5078742 | 20240911021313_onGLA | US002L | 2024-09-15T12:15:50.671Z | 2024-09-19T12:21:40.687Z |
5067591 | 5067591 | 20240910094725_70din | US002L | 2024-09-14T12:18:50.174Z | 2024-09-18T12:15:24.488Z |
5067123 | 5067123 | 20240910085712_xmhwg | US002L | 2024-09-14T12:18:32.915Z | 2024-09-18T12:15:23.450Z |
5066632 | 5066632 | 20240910075807_bLvjM | US002L | 2024-09-14T12:18:05.144Z | 2024-09-18T12:15:22.353Z |
5066532 | 5066532 | 20240910074544_gPj1v | US002L | 2024-09-14T12:18:01.746Z | 2024-09-18T12:15:22.130Z |
5066531 | 5066531 | 20240910074543_K2oa2 | US002L | 2024-09-14T12:18:01.545Z | 2024-09-18T12:15:22.128Z |
5065789 | 5065789 | 20240910053414_yeclj | US002L | 2024-09-14T12:17:23.818Z | 2024-09-18T12:15:20.416Z |
5055713 | 5055713 | 20240908084810_jXS68 | US002L | 2024-09-13T12:17:20.812Z | 2024-09-16T12:21:21.677Z |
5055525 | 5055525 | 20240908081752_DIEyY | US002L | 2024-09-13T12:17:16.261Z | 2024-09-16T12:21:20.240Z |
5055348 | 5055348 | 20240908075314_s1Uim | US002L | 2024-09-13T12:17:10.203Z | 2024-09-16T12:21:18.859Z |
5055169 | 5055169 | 20240908071140_33OG6 | US002L | 2024-09-13T12:17:06.917Z | 2024-09-16T12:21:18.119Z |
5055165 | 5055165 | 20240908070954_Rmcex | US002L | 2024-09-13T12:17:06.866Z | 2024-09-16T12:21:18.102Z |
5055038 | 5055038 | 20240908061807_JsuR5 | US002L | 2024-09-13T12:17:03.989Z | 2024-09-16T12:21:17.766Z |
5054997 | 5054997 | 20240908055432_o8zTq | US002L | 2024-09-13T12:17:01.684Z | 2024-09-16T12:21:17.627Z |
5054959 | 5054959 | 20240908054449_6fIap | US002L | 2024-09-13T12:17:00.335Z | 2024-09-16T12:21:17.470Z |
5054937 | 5054937 | 20240908052954_XRV0S | US002L | 2024-09-13T12:16:59.946Z | 2024-09-16T12:21:17.344Z |
5054922 | 5054922 | 20240908051017_Up5Ax | US002L | 2024-09-13T12:16:59.278Z | 2024-09-16T12:21:17.222Z |
5054856 | 5054856 | 20240908043139_mlOik | US002L | 2024-09-13T12:16:57.170Z | 2024-09-16T12:21:17.016Z |
5053596 | 5053596 | 20240908010408_1zGfx | US002L | 2024-09-13T12:16:09.779Z | 2024-09-16T12:21:12.043Z |
5048882 | 5048882 | 20240909092420_dEyQZ | US002L | 2024-09-13T12:11:20.890Z | 2024-09-17T12:19:08.563Z |
5048876 | 5048876 | 20240909092304_cDW8b | US002L | 2024-09-13T12:11:20.434Z | 2024-09-17T12:19:08.560Z |
5048816 | 5048816 | 20240909091434_wLTHb | US002L | 2024-09-13T12:11:17.174Z | 2024-09-17T12:19:08.410Z |
5048687 | 5048687 | 20240909085355_A2s03 | US002L | 2024-09-13T12:11:09.913Z | 2024-09-17T12:19:07.986Z |
5048670 | 5048670 | 20240909085057_zomg9 | US002L | 2024-09-13T12:11:09.112Z | 2024-09-17T12:19:07.878Z |
5048668 | 5048668 | 20240909085031_6jlI4 | US002L | 2024-09-13T12:11:08.883Z | 2024-09-17T12:19:07.877Z |
5048559 | 5048559 | 20240909082950_0gc5F | US002L | 2024-09-13T12:10:50.515Z | 2024-09-17T12:19:07.503Z |
5048533 | 5048533 | 20240909082705_U9tWo | US002L | 2024-09-13T12:10:47.835Z | 2024-09-17T12:19:07.408Z |
5048088 | 5048088 | 20240909070113_35B9d | US002L | 2024-09-13T12:10:14.439Z | 2024-09-17T12:19:05.605Z |
5047984 | 5047984 | 20240909064647_UN3d7 | US002L | 2024-09-13T12:10:08.057Z | 2024-09-17T12:19:05.163Z |
5047976 | 5047976 | 20240909064343_hNnd5 | US002L | 2024-09-13T12:10:07.457Z | 2024-09-17T12:19:05.117Z |
5047970 | 5047970 | 20240909064323_gHJAY | US002L | 2024-09-13T12:10:06.616Z | 2024-09-17T12:19:05.114Z |
5047961 | 5047961 | 20240909064217_RGb3k | US002L | 2024-09-13T12:10:05.477Z | 2024-09-17T12:19:05.110Z |
5047899 | 5047899 | 20240909062152_3JA5r | US002L | 2024-09-13T12:09:56.143Z | 2024-09-17T12:19:04.926Z |
5047746 | 5047746 | 20240909054420_nCnl2 | US002L | 2024-09-13T12:09:37.949Z | 2024-09-17T12:19:04.163Z |
5047720 | 5047720 | 20240909053010_pT4t2 | US002L | 2024-09-13T12:09:35.609Z | 2024-09-17T12:19:04.103Z |
5047637 | 5047637 | 20240909050338_kpwj3 | US002L | 2024-09-13T12:09:29.992Z | 2024-09-17T12:19:03.790Z |
5047355 | 5047355 | 20240909033819_VzL3t | US002L | 2024-09-13T12:08:51.513Z | 2024-09-17T12:19:02.166Z |
5046930 | 5046930 | 20240909015023_Cu2vs | US002L | 2024-09-13T12:07:58.112Z | 2024-09-17T12:19:00.614Z |
5040548 | 5040548 | 20240906044558_plPVL | US002L | 2024-09-12T12:16:16.091Z | 2024-09-14T12:23:09.920Z |
5040483 | 5040483 | 20240906042336_2qZav | US002L | 2024-09-12T12:16:12.677Z | 2024-09-14T12:23:09.448Z |
5040210 | 5040210 | 20240906031839_1Kqo4 | US002L | 2024-09-12T12:16:02.985Z | 2024-09-14T12:23:08.275Z |
5013002 | 5013002 | 20240903080955_bGLQF | US002L | 2024-09-09T12:18:23.808Z | 2024-09-11T12:21:19.552Z |
5012894 | 5012894 | 20240903075214_mSV6O | US002L | 2024-09-09T12:18:20.158Z | 2024-09-11T12:21:19.192Z |
5012391 | 5012391 | 20240903062912_M83tH | US002L | 2024-09-09T12:17:50.395Z | 2024-09-11T12:21:17.548Z |
5011985 | 5011985 | 20240904082321_OY6aA | US002L | 2024-09-09T12:10:13.110Z | 2024-09-12T12:19:34.445Z |
5011780 | 5011780 | 20240904075129_87VZH | US002L | 2024-09-09T12:10:01.372Z | 2024-09-12T12:19:33.400Z |
5011565 | 5011565 | 20240904071312_OdFXU | US002L | 2024-09-09T12:09:51.998Z | 2024-09-12T12:19:32.545Z |
5011400 | 5011400 | 20240904062641_skU5f | US002L | 2024-09-09T12:09:39.222Z | 2024-09-12T12:19:31.601Z |
5011264 | 5011264 | 20240904055603_wAAwA | US002L | 2024-09-09T12:09:32.380Z | 2024-09-12T12:19:31.104Z |
5011125 | 5011125 | 20240904050058_zaTrM | US002L | 2024-09-09T12:09:25.952Z | 2024-09-12T12:19:30.499Z |
5010915 | 5010915 | 20240904040022_alueV | US002L | 2024-09-09T12:09:08.502Z | 2024-09-12T12:19:29.648Z |
5003655 | 5003655 | 20240903092918_dGi3P | US002L | 2024-09-09T12:01:56.319Z | 2024-09-12T12:18:58.351Z |
5003326 | 5003326 | 20240903083713_tf2Zn | US002L | 2024-09-09T12:01:36.322Z | 2024-09-12T12:18:55.828Z |
5002303 | 5002303 | 20240904093305_IQ3x3 | US002L | 2024-09-09T12:00:24.404Z | 2024-09-13T12:19:40.241Z |
5001100 | 5001100 | 20240902033222_ZP4CU | US002L | 2024-09-08T12:16:09.988Z | 2024-09-10T12:19:31.704Z |
4999224 | 4999224 | 20240903055323_56vvU | US002L | 2024-09-08T12:08:35.406Z | 2024-09-11T12:21:16.884Z |
4999142 | 4999142 | 20240903053040_SZXNL | US002L | 2024-09-08T12:08:31.222Z | 2024-09-11T12:21:16.588Z |
4955447 | 4955447 | 20240811050057_fGxWX | US002L | 2024-09-03T12:19:13.875Z | 2024-09-06T12:29:41.605Z |
4955331 | 4955331 | 20240811043128_fUC1w | US002L | 2024-09-03T12:19:09.109Z | 2024-09-06T12:29:33.930Z |
4955317 | 4955317 | 20240811042818_XIXTS | US002L | 2024-09-03T12:19:08.392Z | 2024-09-06T12:29:32.700Z |
4955284 | 4955284 | 20240811042226_4y7hY | US002L | 2024-09-03T12:19:04.372Z | 2024-09-06T12:29:30.494Z |
4930896 | 4930896 | 20240810091220_umD68 | US002L | 2024-08-31T12:24:01.796Z | 2024-09-02T12:30:30.755Z |
4930780 | 4930780 | 20240810085905_KJws6 | US002L | 2024-08-31T12:23:51.973Z | 2024-09-02T12:30:25.701Z |
4930770 | 4930770 | 20240810085846_illdN | US002L | 2024-08-31T12:23:51.753Z | 2024-09-02T12:30:25.487Z |
4930724 | 4930724 | 20240810085317_E2fRB | US002L | 2024-08-31T12:23:50.420Z | 2024-09-02T12:30:24.300Z |
4930631 | 4930631 | 20240810083958_3ArQp | US002L | 2024-08-31T12:23:45.202Z | 2024-09-02T12:30:21.132Z |
4930592 | 4930592 | 20240810083224_hC4Kv | US002L | 2024-08-31T12:23:42.099Z | 2024-09-02T12:30:20.313Z |
4930561 | 4930561 | 20240810082834_4GVMK | US002L | 2024-08-31T12:23:40.447Z | 2024-09-02T12:30:19.465Z |
4930544 | 4930544 | 20240810082624_XBqq3 | US002L | 2024-08-31T12:23:39.348Z | 2024-09-02T12:30:18.514Z |
4930541 | 4930541 | 20240810082624_Cud5h | US002L | 2024-08-31T12:23:39.211Z | 2024-09-02T12:30:18.391Z |
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);