participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,882 rows where station_code = "UK003J" 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 |
---|---|---|---|---|---|
1763924 | 1763924 | 20221013033923_KolGh | UK003J | 2024-01-05T23:51:01.851Z | 2024-01-05T23:51:01.851Z |
1760854 | 1760854 | 20221011194844_92PBL | UK003J | 2024-01-05T23:51:00.297Z | 2024-01-05T23:51:00.297Z |
1759658 | 1759658 | 20221011051133_WFtac | UK003J | 2024-01-05T23:50:58.933Z | 2024-01-05T23:50:58.933Z |
1759417 | 1759417 | 20221011040341_2wfRi | UK003J | 2024-01-05T23:50:58.913Z | 2024-01-05T23:50:58.913Z |
1759391 | 1759391 | 20221011040128_bDhVo | UK003J | 2024-01-05T23:50:58.910Z | 2024-01-05T23:50:58.910Z |
1758497 | 1758497 | 20221010220544_e9DBS | UK003J | 2024-01-05T23:50:58.824Z | 2024-01-05T23:50:58.824Z |
1758338 | 1758338 | 20221010192514_LLUFE | UK003J | 2024-01-05T23:50:58.808Z | 2024-01-05T23:50:58.808Z |
1758261 | 1758261 | 20221010183958_bOtCg | UK003J | 2024-01-05T23:50:58.802Z | 2024-01-05T23:50:58.802Z |
1756555 | 1756555 | 20221009051552_PvNnN | UK003J | 2024-01-05T23:50:55.377Z | 2024-01-05T23:50:55.377Z |
1756544 | 1756544 | 20221009051338_3oCof | UK003J | 2024-01-05T23:50:55.375Z | 2024-01-05T23:50:55.375Z |
1756478 | 1756478 | 20221009045830_tOUTn | UK003J | 2024-01-05T23:50:55.371Z | 2024-01-05T23:50:55.371Z |
1756442 | 1756442 | 20221009044825_wZ7Nc | UK003J | 2024-01-05T23:50:55.368Z | 2024-01-05T23:50:55.368Z |
1755978 | 1755978 | 20221009034148_Ypb0L | UK003J | 2024-01-05T23:50:55.332Z | 2024-01-05T23:50:55.332Z |
1755857 | 1755857 | 20221009031611_onC2C | UK003J | 2024-01-05T23:50:55.319Z | 2024-01-05T23:50:55.319Z |
1753371 | 1753371 | 20221008043703_bF3XF | UK003J | 2024-01-05T23:50:53.268Z | 2024-01-05T23:50:53.268Z |
1753212 | 1753212 | 20221008042836_qpSPz | UK003J | 2024-01-05T23:50:53.257Z | 2024-01-05T23:50:53.257Z |
1753086 | 1753086 | 20221008042005_tdePc | UK003J | 2024-01-05T23:50:53.249Z | 2024-01-05T23:50:53.249Z |
1753047 | 1753047 | 20221008041835_lbjYZ | UK003J | 2024-01-05T23:50:53.246Z | 2024-01-05T23:50:53.246Z |
1752929 | 1752929 | 20221008041125_EPwJC | UK003J | 2024-01-05T23:50:53.237Z | 2024-01-05T23:50:53.237Z |
1752907 | 1752907 | 20221008040918_XunFF | UK003J | 2024-01-05T23:50:53.235Z | 2024-01-05T23:50:53.235Z |
1752830 | 1752830 | 20221008040246_rd037 | UK003J | 2024-01-05T23:50:53.230Z | 2024-01-05T23:50:53.230Z |
1752406 | 1752406 | 20221008032330_DGnC3 | UK003J | 2024-01-05T23:50:53.195Z | 2024-01-05T23:50:53.195Z |
1752046 | 1752046 | 20221008025053_GA85y | UK003J | 2024-01-05T23:50:53.165Z | 2024-01-05T23:50:53.165Z |
1751665 | 1751665 | 20221008020838_LlbH9 | UK003J | 2024-01-05T23:50:53.134Z | 2024-01-05T23:50:53.134Z |
1751318 | 1751318 | 20221008010818_vcHXD | UK003J | 2024-01-05T23:50:53.104Z | 2024-01-05T23:50:53.104Z |
1751283 | 1751283 | 20221008010058_d8csS | UK003J | 2024-01-05T23:50:53.101Z | 2024-01-05T23:50:53.101Z |
1750626 | 1750626 | 20221007211237_Hh543 | UK003J | 2024-01-05T23:50:53.043Z | 2024-01-05T23:50:53.043Z |
1750527 | 1750527 | 20221007204302_56bEs | UK003J | 2024-01-05T23:50:53.034Z | 2024-01-05T23:50:53.034Z |
1749291 | 1749291 | 20221007044354_12tC5 | UK003J | 2024-01-05T23:50:51.326Z | 2024-01-05T23:50:51.326Z |
1749003 | 1749003 | 20221007040000_FC1Jn | UK003J | 2024-01-05T23:50:51.299Z | 2024-01-05T23:50:51.299Z |
1748728 | 1748728 | 20221007032033_5iBaN | UK003J | 2024-01-05T23:50:51.270Z | 2024-01-05T23:50:51.270Z |
1748481 | 1748481 | 20221007023603_239Sd | UK003J | 2024-01-05T23:50:51.246Z | 2024-01-05T23:50:51.246Z |
1748464 | 1748464 | 20221007023208_AwayG | UK003J | 2024-01-05T23:50:51.244Z | 2024-01-05T23:50:51.244Z |
1748438 | 1748438 | 20221007022911_ATAKR | UK003J | 2024-01-05T23:50:51.241Z | 2024-01-05T23:50:51.241Z |
1748348 | 1748348 | 20221007021656_3NZ2V | UK003J | 2024-01-05T23:50:51.232Z | 2024-01-05T23:50:51.232Z |
1748229 | 1748229 | 20221007015759_mv33H | UK003J | 2024-01-05T23:50:51.220Z | 2024-01-05T23:50:51.220Z |
1747938 | 1747938 | 20221007010101_Hmfag | UK003J | 2024-01-05T23:50:51.184Z | 2024-01-05T23:50:51.184Z |
1747910 | 1747910 | 20221007004612_eeELN | UK003J | 2024-01-05T23:50:51.181Z | 2024-01-05T23:50:51.181Z |
1747208 | 1747208 | 20221006202057_TSTdK | UK003J | 2024-01-05T23:50:51.098Z | 2024-01-05T23:50:51.098Z |
1747058 | 1747058 | 20221006184747_YpNWn | UK003J | 2024-01-05T23:50:51.081Z | 2024-01-05T23:50:51.081Z |
1745641 | 1745641 | 20221006044930_R9pmS | UK003J | 2024-01-05T23:50:49.493Z | 2024-01-05T23:50:49.493Z |
1745416 | 1745416 | 20221006043708_jpyzZ | UK003J | 2024-01-05T23:50:49.480Z | 2024-01-05T23:50:49.480Z |
1744946 | 1744946 | 20221006041409_3NW0B | UK003J | 2024-01-05T23:50:49.446Z | 2024-01-05T23:50:49.446Z |
1744825 | 1744825 | 20221006040754_6MEOD | UK003J | 2024-01-05T23:50:49.437Z | 2024-01-05T23:50:49.437Z |
1744810 | 1744810 | 20221006040500_A5IGK | UK003J | 2024-01-05T23:50:49.435Z | 2024-01-05T23:50:49.435Z |
1744595 | 1744595 | 20221006035635_33hQR | UK003J | 2024-01-05T23:50:49.422Z | 2024-01-05T23:50:49.422Z |
1744503 | 1744503 | 20221006035341_XtHOY | UK003J | 2024-01-05T23:50:49.417Z | 2024-01-05T23:50:49.417Z |
1744386 | 1744386 | 20221006034445_SEOAB | UK003J | 2024-01-05T23:50:49.409Z | 2024-01-05T23:50:49.409Z |
1744248 | 1744248 | 20221006033838_EuZ6M | UK003J | 2024-01-05T23:50:49.400Z | 2024-01-05T23:50:49.400Z |
1744170 | 1744170 | 20221006033628_27yTw | UK003J | 2024-01-05T23:50:49.395Z | 2024-01-05T23:50:49.395Z |
1744065 | 1744065 | 20221006033040_3M63p | UK003J | 2024-01-05T23:50:49.389Z | 2024-01-05T23:50:49.389Z |
1743846 | 1743846 | 20221006031449_b2mFh | UK003J | 2024-01-05T23:50:49.372Z | 2024-01-05T23:50:49.372Z |
1743576 | 1743576 | 20221006025709_2vQZ7 | UK003J | 2024-01-05T23:50:49.348Z | 2024-01-05T23:50:49.348Z |
1743254 | 1743254 | 20221006023816_FjYX2 | UK003J | 2024-01-05T23:50:49.323Z | 2024-01-05T23:50:49.323Z |
1743127 | 1743127 | 20221006023039_GJYLX | UK003J | 2024-01-05T23:50:49.313Z | 2024-01-05T23:50:49.313Z |
1742995 | 1742995 | 20221006022101_Ie2Vi | UK003J | 2024-01-05T23:50:49.304Z | 2024-01-05T23:50:49.304Z |
1742904 | 1742904 | 20221006021812_OXCro | UK003J | 2024-01-05T23:50:49.297Z | 2024-01-05T23:50:49.297Z |
1742520 | 1742520 | 20221006015530_l9WQV | UK003J | 2024-01-05T23:50:49.267Z | 2024-01-05T23:50:49.267Z |
1742479 | 1742479 | 20221006015246_LzbUn | UK003J | 2024-01-05T23:50:49.265Z | 2024-01-05T23:50:49.265Z |
1742406 | 1742406 | 20221006014921_dw0MS | UK003J | 2024-01-05T23:50:49.260Z | 2024-01-05T23:50:49.260Z |
1742221 | 1742221 | 20221006013831_2pTmp | UK003J | 2024-01-05T23:50:49.243Z | 2024-01-05T23:50:49.243Z |
1742192 | 1742192 | 20221006013631_z2Pbc | UK003J | 2024-01-05T23:50:49.240Z | 2024-01-05T23:50:49.240Z |
1742081 | 1742081 | 20221006013147_UwcRY | UK003J | 2024-01-05T23:50:49.233Z | 2024-01-05T23:50:49.233Z |
1741858 | 1741858 | 20221006011639_CDHWm | UK003J | 2024-01-05T23:50:49.217Z | 2024-01-05T23:50:49.217Z |
1741737 | 1741737 | 20221006010325_9pobe | UK003J | 2024-01-05T23:50:49.205Z | 2024-01-05T23:50:49.205Z |
1741693 | 1741693 | 20221006010005_e22FF | UK003J | 2024-01-05T23:50:49.202Z | 2024-01-05T23:50:49.202Z |
1741118 | 1741118 | 20221005234609_NSX4U | UK003J | 2024-01-05T23:50:49.149Z | 2024-01-05T23:50:49.149Z |
1740727 | 1740727 | 20221005224503_rVCfb | UK003J | 2024-01-05T23:50:49.114Z | 2024-01-05T23:50:49.114Z |
1740475 | 1740475 | 20221005221210_yL4Pi | UK003J | 2024-01-05T23:50:49.095Z | 2024-01-05T23:50:49.095Z |
1740405 | 1740405 | 20221005215813_itHC6 | UK003J | 2024-01-05T23:50:49.090Z | 2024-01-05T23:50:49.090Z |
1740137 | 1740137 | 20221005204726_7s8Cv | UK003J | 2024-01-05T23:50:49.064Z | 2024-01-05T23:50:49.064Z |
1732077 | 1732077 | 20221003033527_VRRFW | UK003J | 2024-01-05T23:50:42.873Z | 2024-01-05T23:50:42.873Z |
1731340 | 1731340 | 20221003013744_S0ikq | UK003J | 2024-01-05T23:50:42.790Z | 2024-01-05T23:50:42.790Z |
1731203 | 1731203 | 20221003011526_EFa3M | UK003J | 2024-01-05T23:50:42.776Z | 2024-01-05T23:50:42.776Z |
1730910 | 1730910 | 20221003003952_RDpSe | UK003J | 2024-01-05T23:50:42.745Z | 2024-01-05T23:50:42.745Z |
1730830 | 1730830 | 20221003003032_IQ78r | UK003J | 2024-01-05T23:50:42.738Z | 2024-01-05T23:50:42.738Z |
1730806 | 1730806 | 20221003002820_CySJH | UK003J | 2024-01-05T23:50:42.737Z | 2024-01-05T23:50:42.737Z |
1730629 | 1730629 | 20221003000253_8ZPhZ | UK003J | 2024-01-05T23:50:42.721Z | 2024-01-05T23:50:42.721Z |
1730547 | 1730547 | 20221002234448_Mk0ns | UK003J | 2024-01-05T23:50:42.713Z | 2024-01-05T23:50:42.713Z |
1730519 | 1730519 | 20221002234201_Hhnvb | UK003J | 2024-01-05T23:50:42.710Z | 2024-01-05T23:50:42.710Z |
1730446 | 1730446 | 20221002233241_uZm6m | UK003J | 2024-01-05T23:50:42.702Z | 2024-01-05T23:50:42.702Z |
1730117 | 1730117 | 20221002223738_73n3e | UK003J | 2024-01-05T23:50:42.672Z | 2024-01-05T23:50:42.672Z |
1730022 | 1730022 | 20221002222837_m1Eqe | UK003J | 2024-01-05T23:50:42.666Z | 2024-01-05T23:50:42.666Z |
1729857 | 1729857 | 20221002215637_t3Tiu | UK003J | 2024-01-05T23:50:42.651Z | 2024-01-05T23:50:42.651Z |
1729775 | 1729775 | 20221002213631_cD9vQ | UK003J | 2024-01-05T23:50:42.643Z | 2024-01-05T23:50:42.643Z |
1729637 | 1729637 | 20221002210819_f9JYJ | UK003J | 2024-01-05T23:50:42.630Z | 2024-01-05T23:50:42.630Z |
1729347 | 1729347 | 20221002195014_gDrkD | UK003J | 2024-01-05T23:50:42.600Z | 2024-01-05T23:50:42.600Z |
1729310 | 1729310 | 20221002193649_ADHoq | UK003J | 2024-01-05T23:50:42.596Z | 2024-01-05T23:50:42.596Z |
1721991 | 1721991 | 20221001030038_sLH5R | UK003J | 2024-01-05T23:50:39.163Z | 2024-01-05T23:50:39.163Z |
1721684 | 1721684 | 20221001021747_qW0ud | UK003J | 2024-01-05T23:50:39.133Z | 2024-01-05T23:50:39.133Z |
1721643 | 1721643 | 20221001021224_afEVH | UK003J | 2024-01-05T23:50:39.129Z | 2024-01-05T23:50:39.129Z |
1721389 | 1721389 | 20221001013930_I45A3 | UK003J | 2024-01-05T23:50:39.108Z | 2024-01-05T23:50:39.108Z |
1721009 | 1721009 | 20221001002501_xgWy9 | UK003J | 2024-01-05T23:50:39.074Z | 2024-01-05T23:50:39.074Z |
1720982 | 1720982 | 20221001001603_GBRqE | UK003J | 2024-01-05T23:50:39.071Z | 2024-01-05T23:50:39.071Z |
1720895 | 1720895 | 20221001000120_5YKYO | UK003J | 2024-01-05T23:50:39.064Z | 2024-01-05T23:50:39.064Z |
1720856 | 1720856 | 20220930235100_OFzsU | UK003J | 2024-01-05T23:50:39.060Z | 2024-01-05T23:50:39.060Z |
1720697 | 1720697 | 20220930231759_EWaJb | UK003J | 2024-01-05T23:50:39.045Z | 2024-01-05T23:50:39.045Z |
1720610 | 1720610 | 20220930225412_4euxd | UK003J | 2024-01-05T23:50:39.036Z | 2024-01-05T23:50:39.036Z |
1717523 | 1717523 | 20220930050232_AjGep | UK003J | 2024-01-05T23:50:37.482Z | 2024-01-05T23:50:37.482Z |
1717321 | 1717321 | 20220930043427_lNBF0 | UK003J | 2024-01-05T23:50:37.459Z | 2024-01-05T23:50:37.459Z |
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);