participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,479 rows where station_code = "CA000L" 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 |
---|---|---|---|---|---|
5134430 | 5134430 | 20240916090847_OpOj8 | CA000L | 2024-09-19T12:17:43.633Z | 2024-09-19T12:17:43.633Z |
5134278 | 5134278 | 20240916074713_xe4ER | CA000L | 2024-09-19T12:17:35.032Z | 2024-09-19T12:17:35.032Z |
5132445 | 5132445 | 20240916011005_PepsL | CA000L | 2024-09-19T12:16:13.409Z | 2024-09-19T12:16:13.409Z |
5125431 | 5125431 | 20240918023615_f2JiI | CA000L | 2024-09-19T12:03:13.853Z | 2024-09-19T12:06:42.032Z |
5123007 | 5123007 | 20240914083900_APi0P | CA000L | 2024-09-18T12:11:37.849Z | 2024-09-19T12:20:07.284Z |
5122705 | 5122705 | 20240914073331_yKU5i | CA000L | 2024-09-18T12:11:29.007Z | 2024-09-19T12:20:05.809Z |
5122428 | 5122428 | 20240914061911_nS1ew | CA000L | 2024-09-18T12:11:18.116Z | 2024-09-19T12:20:04.273Z |
5122358 | 5122358 | 20240914055311_j3k8o | CA000L | 2024-09-18T12:11:15.534Z | 2024-09-19T12:20:04.000Z |
5122252 | 5122252 | 20240914051446_ekNBE | CA000L | 2024-09-18T12:11:11.750Z | 2024-09-19T12:20:03.514Z |
5122230 | 5122230 | 20240914050512_L3sK2 | CA000L | 2024-09-18T12:11:11.032Z | 2024-09-19T12:20:03.338Z |
5122192 | 5122192 | 20240914045005_M8B5o | CA000L | 2024-09-18T12:11:09.258Z | 2024-09-19T12:20:02.969Z |
5117893 | 5117893 | 20240915073904_vjuqF | CA000L | 2024-09-18T12:08:05.422Z | 2024-09-19T12:19:18.791Z |
5117629 | 5117629 | 20240915055509_E52ek | CA000L | 2024-09-18T12:07:50.054Z | 2024-09-19T12:19:16.572Z |
5117609 | 5117609 | 20240915054717_NZRBB | CA000L | 2024-09-18T12:07:48.978Z | 2024-09-19T12:19:16.390Z |
5117253 | 5117253 | 20240915041521_222hN | CA000L | 2024-09-18T12:07:36.305Z | 2024-09-19T12:19:14.054Z |
5116210 | 5116210 | 20240915031623_LPF1p | CA000L | 2024-09-18T12:06:48.735Z | 2024-09-19T12:19:09.773Z |
5095032 | 5095032 | 20240912051649_ojYsR | CA000L | 2024-09-16T12:15:10.350Z | 2024-09-19T12:21:17.027Z |
5091995 | 5091995 | 20240912023444_2vg6x | CA000L | 2024-09-16T12:13:37.395Z | 2024-09-19T12:21:13.591Z |
5081700 | 5081700 | 20240911082814_nDMc9 | CA000L | 2024-09-15T12:17:42.596Z | 2024-09-19T12:21:46.227Z |
5081348 | 5081348 | 20240911072930_W3KFi | CA000L | 2024-09-15T12:17:30.950Z | 2024-09-19T12:21:45.165Z |
5080795 | 5080795 | 20240911044905_GNxvD | CA000L | 2024-09-15T12:17:13.527Z | 2024-09-19T12:21:43.688Z |
5079927 | 5079927 | 20240911032103_lkA7w | CA000L | 2024-09-15T12:16:42.233Z | 2024-09-19T12:21:42.862Z |
5077716 | 5077716 | 20240911011301_WPj8o | CA000L | 2024-09-15T12:15:01.859Z | 2024-09-19T12:21:39.573Z |
5067198 | 5067198 | 20240910090523_r46m3 | CA000L | 2024-09-14T12:18:35.255Z | 2024-09-18T12:15:23.562Z |
5067163 | 5067163 | 20240910090121_e1LqG | CA000L | 2024-09-14T12:18:34.351Z | 2024-09-18T12:15:23.506Z |
5067059 | 5067059 | 20240910085050_rjlpA | CA000L | 2024-09-14T12:18:28.718Z | 2024-09-18T12:15:23.281Z |
5067048 | 5067048 | 20240910084918_cTqcb | CA000L | 2024-09-14T12:18:28.323Z | 2024-09-18T12:15:23.261Z |
5066885 | 5066885 | 20240910082830_ELmBt | CA000L | 2024-09-14T12:18:18.046Z | 2024-09-18T12:15:22.929Z |
5066018 | 5066018 | 20240910062341_O3nBx | CA000L | 2024-09-14T12:17:35.504Z | 2024-09-18T12:15:20.999Z |
5065941 | 5065941 | 20240910060513_N6DbS | CA000L | 2024-09-14T12:17:29.460Z | 2024-09-18T12:15:20.825Z |
5065925 | 5065925 | 20240910060217_xaJDJ | CA000L | 2024-09-14T12:17:28.334Z | 2024-09-18T12:15:20.701Z |
5065904 | 5065904 | 20240910055911_8VqDP | CA000L | 2024-09-14T12:17:27.570Z | 2024-09-18T12:15:20.655Z |
5065749 | 5065749 | 20240910052609_Plm0u | CA000L | 2024-09-14T12:17:22.334Z | 2024-09-18T12:15:20.309Z |
5065545 | 5065545 | 20240910043836_qHKAr | CA000L | 2024-09-14T12:17:10.134Z | 2024-09-18T12:15:19.820Z |
5065439 | 5065439 | 20240910040959_9MFl0 | CA000L | 2024-09-14T12:17:05.683Z | 2024-09-18T12:15:19.435Z |
5065280 | 5065280 | 20240910033633_grNEC | CA000L | 2024-09-14T12:16:52.655Z | 2024-09-18T12:15:18.921Z |
5065236 | 5065236 | 20240910032419_9yEAI | CA000L | 2024-09-14T12:16:47.009Z | 2024-09-18T12:15:18.805Z |
5064899 | 5064899 | 20240910022419_hnb8R | CA000L | 2024-09-14T12:16:08.955Z | 2024-09-18T12:15:17.695Z |
5064888 | 5064888 | 20240910022309_JxnRf | CA000L | 2024-09-14T12:16:08.452Z | 2024-09-18T12:15:17.657Z |
5064823 | 5064823 | 20240910020914_k2NIx | CA000L | 2024-09-14T12:16:04.788Z | 2024-09-18T12:15:17.463Z |
5055365 | 5055365 | 20240908075412_TBfMB | CA000L | 2024-09-13T12:17:10.698Z | 2024-09-16T12:21:18.936Z |
5054633 | 5054633 | 20240908032518_JyyFR | CA000L | 2024-09-13T12:16:50.579Z | 2024-09-16T12:21:16.356Z |
5040302 | 5040302 | 20240906033800_sHZSB | CA000L | 2024-09-12T12:16:06.045Z | 2024-09-14T12:23:08.633Z |
5027533 | 5027533 | 20240905074942_O72qZ | CA000L | 2024-09-11T12:14:15.765Z | 2024-09-13T12:20:03.419Z |
5027442 | 5027442 | 20240905073937_BjTvZ | CA000L | 2024-09-11T12:14:11.178Z | 2024-09-13T12:20:03.142Z |
5027279 | 5027279 | 20240905071751_evtLg | CA000L | 2024-09-11T12:14:03.865Z | 2024-09-13T12:20:02.236Z |
5027274 | 5027274 | 20240905071705_CwabF | CA000L | 2024-09-11T12:14:03.502Z | 2024-09-13T12:20:02.225Z |
5026626 | 5026626 | 20240905043355_ajTM2 | CA000L | 2024-09-11T12:12:49.901Z | 2024-09-13T12:19:59.102Z |
5021983 | 5021983 | 20240905074942_YODdO | CA000L | 2024-09-10T12:15:59.143Z | 2024-09-10T12:16:55.471Z |
5021894 | 5021894 | 20240905073937_X2cKM | CA000L | 2024-09-10T12:15:55.926Z | 2024-09-13T12:20:03.143Z |
5021732 | 5021732 | 20240905071751_9Z2D7 | CA000L | 2024-09-10T12:15:50.077Z | 2024-09-10T12:16:55.430Z |
5021727 | 5021727 | 20240905071705_1Oh6l | CA000L | 2024-09-10T12:15:49.536Z | 2024-09-10T12:16:55.428Z |
5021084 | 5021084 | 20240905043355_C3F8t | CA000L | 2024-09-10T12:15:14.099Z | 2024-09-10T12:16:55.306Z |
5020603 | 5020603 | 20240905023011_Tcu3Z | CA000L | 2024-09-10T12:14:48.053Z | 2024-09-10T12:16:55.192Z |
5013092 | 5013092 | 20240903082001_bPXbI | CA000L | 2024-09-09T12:18:26.878Z | 2024-09-11T12:21:19.838Z |
5012954 | 5012954 | 20240903080138_N5ELs | CA000L | 2024-09-09T12:18:22.073Z | 2024-09-11T12:21:19.396Z |
5012852 | 5012852 | 20240903074722_d9gEz | CA000L | 2024-09-09T12:18:18.912Z | 2024-09-11T12:21:19.078Z |
5012835 | 5012835 | 20240903074156_PUKMo | CA000L | 2024-09-09T12:18:18.132Z | 2024-09-11T12:21:19.012Z |
5012704 | 5012704 | 20240903072112_grbrR | CA000L | 2024-09-09T12:18:07.371Z | 2024-09-11T12:21:18.605Z |
5012473 | 5012473 | 20240903064249_8pK3Y | CA000L | 2024-09-09T12:17:53.182Z | 2024-09-11T12:21:17.806Z |
5011219 | 5011219 | 20240904053853_u5Wgj | CA000L | 2024-09-09T12:09:30.384Z | 2024-09-12T12:19:30.849Z |
5010632 | 5010632 | 20240904032651_oNBxu | CA000L | 2024-09-09T12:08:55.093Z | 2024-09-12T12:19:28.381Z |
5010600 | 5010600 | 20240904032231_XuDSR | CA000L | 2024-09-09T12:08:53.214Z | 2024-09-12T12:19:28.131Z |
5001255 | 5001255 | 20240902040359_MeSoE | CA000L | 2024-09-08T12:16:16.879Z | 2024-09-10T12:19:32.534Z |
5001162 | 5001162 | 20240902034149_AWygB | CA000L | 2024-09-08T12:16:12.809Z | 2024-09-10T12:19:32.161Z |
4998953 | 4998953 | 20240903043615_QSIUD | CA000L | 2024-09-08T12:08:15.511Z | 2024-09-11T12:21:15.709Z |
4992876 | 4992876 | 20240902091002_t2NtX | CA000L | 2024-09-08T12:00:57.084Z | 2024-09-11T12:20:18.340Z |
4992301 | 4992301 | 20240901070151_mojGh | CA000L | 2024-09-07T12:13:11.870Z | 2024-09-09T12:27:58.873Z |
4992239 | 4992239 | 20240901064044_EPmpF | CA000L | 2024-09-07T12:13:05.955Z | 2024-09-09T12:27:57.353Z |
4992215 | 4992215 | 20240901063111_O7laf | CA000L | 2024-09-07T12:13:03.775Z | 2024-09-09T12:27:56.136Z |
4992036 | 4992036 | 20240901051303_FOJp6 | CA000L | 2024-09-07T12:12:52.100Z | 2024-09-09T12:27:43.223Z |
4991975 | 4991975 | 20240901042717_FSqL9 | CA000L | 2024-09-07T12:12:44.482Z | 2024-09-09T12:27:37.450Z |
4991952 | 4991952 | 20240901040017_8ei4O | CA000L | 2024-09-07T12:12:42.359Z | 2024-09-09T12:27:34.419Z |
4991929 | 4991929 | 20240901034350_b1jaq | CA000L | 2024-09-07T12:12:39.389Z | 2024-09-09T12:27:32.929Z |
4991536 | 4991536 | 20240901024452_Sluit | CA000L | 2024-09-07T12:12:08.985Z | 2024-09-09T12:27:12.076Z |
4991474 | 4991474 | 20240901023638_4eNx5 | CA000L | 2024-09-07T12:12:04.743Z | 2024-09-09T12:27:08.702Z |
4991290 | 4991290 | 20240901021610_e5Rfg | CA000L | 2024-09-07T12:11:50.299Z | 2024-09-09T12:27:04.453Z |
4983787 | 4983787 | 20240901080244_KOSYx | CA000L | 2024-09-07T12:00:47.168Z | 2024-09-10T12:19:03.416Z |
4983625 | 4983625 | 20240901071752_vMHiW | CA000L | 2024-09-07T12:00:26.935Z | 2024-09-10T12:19:02.137Z |
4957723 | 4957723 | 20240811091339_vXatb | CA000L | 2024-09-03T12:21:39.503Z | 2024-09-06T12:31:33.518Z |
4957672 | 4957672 | 20240811090820_8qCr2 | CA000L | 2024-09-03T12:21:36.218Z | 2024-09-06T12:31:30.877Z |
4957551 | 4957551 | 20240811085624_5uxoW | CA000L | 2024-09-03T12:21:27.137Z | 2024-09-06T12:31:25.559Z |
4957531 | 4957531 | 20240811085412_Bx29g | CA000L | 2024-09-03T12:21:26.011Z | 2024-09-06T12:31:24.736Z |
4957495 | 4957495 | 20240811084919_DaIEa | CA000L | 2024-09-03T12:21:21.631Z | 2024-09-06T12:31:21.457Z |
4957477 | 4957477 | 20240811084814_6t31X | CA000L | 2024-09-03T12:21:19.818Z | 2024-09-06T12:31:20.593Z |
4957462 | 4957462 | 20240811084642_u8uJv | CA000L | 2024-09-03T12:21:18.784Z | 2024-09-06T12:31:20.106Z |
4957279 | 4957279 | 20240811082715_gsnMB | CA000L | 2024-09-03T12:21:02.512Z | 2024-09-06T12:31:13.011Z |
4957236 | 4957236 | 20240811082252_e4L4I | CA000L | 2024-09-03T12:20:58.302Z | 2024-09-06T12:31:10.059Z |
4957196 | 4957196 | 20240811081911_nEGyE | CA000L | 2024-09-03T12:20:55.200Z | 2024-09-06T12:31:08.219Z |
4957028 | 4957028 | 20240811080912_A2U2q | CA000L | 2024-09-03T12:20:47.153Z | 2024-09-06T12:30:58.661Z |
4956945 | 4956945 | 20240811080236_hBDsW | CA000L | 2024-09-03T12:20:44.094Z | 2024-09-06T12:30:55.861Z |
4956608 | 4956608 | 20240811073522_q1Aue | CA000L | 2024-09-03T12:20:33.201Z | 2024-09-06T12:30:40.538Z |
4956348 | 4956348 | 20240811070931_sf2vq | CA000L | 2024-09-03T12:20:17.241Z | 2024-09-06T12:30:27.032Z |
4956235 | 4956235 | 20240811065914_gID4X | CA000L | 2024-09-03T12:20:06.896Z | 2024-09-06T12:30:22.194Z |
4956140 | 4956140 | 20240811064826_VUkvP | CA000L | 2024-09-03T12:19:57.387Z | 2024-09-06T12:30:17.028Z |
4955343 | 4955343 | 20240811043742_dEP0Z | CA000L | 2024-09-03T12:19:09.596Z | 2024-09-06T12:29:34.392Z |
4955340 | 4955340 | 20240811043658_IUt3e | CA000L | 2024-09-03T12:19:09.531Z | 2024-09-06T12:29:34.358Z |
4955269 | 4955269 | 20240811041652_LEDAD | CA000L | 2024-09-03T12:19:02.886Z | 2024-09-06T12:29:29.958Z |
4955217 | 4955217 | 20240811040400_D2kqY | CA000L | 2024-09-03T12:18:57.289Z | 2024-09-06T12:29:26.363Z |
4955038 | 4955038 | 20240811032626_ieidr | CA000L | 2024-09-03T12:18:37.158Z | 2024-09-06T12:29:15.564Z |
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);