participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,069 rows where station_code = "NL0006" 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 |
---|---|---|---|---|---|
5561989 | 5561989 | 20241119224103_ZCS1n | NL0006 | 2024-11-21T14:14:18.322Z | 2024-11-26T14:27:34.340Z |
5485238 | 5485238 | 20241105042707_nDcCO | NL0006 | 2024-11-06T14:17:58.035Z | 2024-11-13T14:27:41.077Z |
5484991 | 5484991 | 20241105035148_3IKnX | NL0006 | 2024-11-06T14:17:36.972Z | 2024-11-13T14:27:40.437Z |
5484986 | 5484986 | 20241105035109_6OQJe | NL0006 | 2024-11-06T14:17:36.550Z | 2024-11-13T14:27:40.433Z |
5484689 | 5484689 | 20241105032016_3TrUk | NL0006 | 2024-11-06T14:17:10.142Z | 2024-11-13T14:27:39.344Z |
5484556 | 5484556 | 20241105030403_bxu2g | NL0006 | 2024-11-06T14:17:00.662Z | 2024-11-13T14:27:38.619Z |
5484531 | 5484531 | 20241105030229_ngi8s | NL0006 | 2024-11-06T14:16:59.868Z | 2024-11-13T14:27:38.570Z |
5484516 | 5484516 | 20241105025952_402q6 | NL0006 | 2024-11-06T14:16:59.279Z | 2024-11-13T14:27:38.501Z |
5484092 | 5484092 | 20241105020911_3s7s7 | NL0006 | 2024-11-06T14:16:12.940Z | 2024-11-13T14:27:37.271Z |
5483660 | 5483660 | 20241105011634_vblCJ | NL0006 | 2024-11-06T14:15:34.048Z | 2024-11-13T14:27:36.572Z |
5483353 | 5483353 | 20241105003005_zvjy0 | NL0006 | 2024-11-06T14:15:01.451Z | 2024-11-13T14:27:36.071Z |
5483325 | 5483325 | 20241105002658_uD5dv | NL0006 | 2024-11-06T14:14:59.746Z | 2024-11-13T14:27:36.038Z |
5482564 | 5482564 | 20241104223958_bdyu8 | NL0006 | 2024-11-06T14:13:21.791Z | 2024-11-13T14:27:34.827Z |
5482398 | 5482398 | 20241104220659_CvDq7 | NL0006 | 2024-11-06T14:13:07.672Z | 2024-11-13T14:27:34.474Z |
5482270 | 5482270 | 20241104214124_J393V | NL0006 | 2024-11-06T14:12:45.674Z | 2024-11-13T14:27:34.245Z |
5481831 | 5481831 | 20241104195458_9z64b | NL0006 | 2024-11-06T14:11:39.143Z | 2024-11-13T14:27:33.218Z |
5481781 | 5481781 | 20241104193945_yj9n9 | NL0006 | 2024-11-06T14:11:34.198Z | 2024-11-13T14:27:32.688Z |
5478708 | 5478708 | 20241104051421_0sTuk | NL0006 | 2024-11-05T14:18:43.590Z | 2024-11-12T14:28:16.614Z |
5478237 | 5478237 | 20241104034005_G6DSq | NL0006 | 2024-11-05T14:18:05.740Z | 2024-11-12T14:28:14.638Z |
5477903 | 5477903 | 20241104025220_Y5Nnr | NL0006 | 2024-11-05T14:17:35.668Z | 2024-11-12T14:28:13.205Z |
5477771 | 5477771 | 20241104023325_7H8Nz | NL0006 | 2024-11-05T14:17:23.854Z | 2024-11-12T14:28:12.870Z |
5477723 | 5477723 | 20241104022644_6oS2u | NL0006 | 2024-11-05T14:17:19.533Z | 2024-11-12T14:28:12.540Z |
5477642 | 5477642 | 20241104021634_2hWCD | NL0006 | 2024-11-05T14:17:11.486Z | 2024-11-12T14:28:12.206Z |
5476820 | 5476820 | 20241104002939_CjiZH | NL0006 | 2024-11-05T14:16:06.345Z | 2024-11-12T14:28:07.582Z |
5476573 | 5476573 | 20241103234737_x17OU | NL0006 | 2024-11-05T14:15:41.035Z | 2024-11-12T14:28:06.544Z |
5475861 | 5475861 | 20241103214220_XWEIr | NL0006 | 2024-11-05T14:14:23.903Z | 2024-11-12T14:28:01.680Z |
5475363 | 5475363 | 20241103195318_m8Vn5 | NL0006 | 2024-11-05T14:13:19.407Z | 2024-11-12T14:27:58.105Z |
5470015 | 5470015 | 20241103050919_RrNJ2 | NL0006 | 2024-11-04T14:17:34.340Z | 2024-11-11T14:23:03.510Z |
5469962 | 5469962 | 20241103045138_kQhng | NL0006 | 2024-11-04T14:17:27.147Z | 2024-11-11T14:23:03.188Z |
5469933 | 5469933 | 20241103044829_pGdQ2 | NL0006 | 2024-11-04T14:17:23.232Z | 2024-11-11T14:23:03.078Z |
5469781 | 5469781 | 20241103041815_4PPQw | NL0006 | 2024-11-04T14:17:02.822Z | 2024-11-11T14:23:02.240Z |
5469742 | 5469742 | 20241103040912_3ksmv | NL0006 | 2024-11-04T14:16:58.527Z | 2024-11-11T14:23:02.166Z |
5469590 | 5469590 | 20241103035023_1BMTM | NL0006 | 2024-11-04T14:16:39.317Z | 2024-11-11T14:23:01.293Z |
5469551 | 5469551 | 20241103034333_T32Al | NL0006 | 2024-11-04T14:16:35.697Z | 2024-11-11T14:23:01.050Z |
5469399 | 5469399 | 20241103032154_dDa6Y | NL0006 | 2024-11-04T14:16:24.713Z | 2024-11-11T14:23:00.104Z |
5468942 | 5468942 | 20241103021334_zyYfb | NL0006 | 2024-11-04T14:15:17.552Z | 2024-11-11T14:22:57.085Z |
5468762 | 5468762 | 20241103014226_BNFKt | NL0006 | 2024-11-04T14:15:01.454Z | 2024-11-11T14:22:55.530Z |
5467656 | 5467656 | 20241102221032_9tufv | NL0006 | 2024-11-04T14:12:18.135Z | 2024-11-11T14:22:48.787Z |
5467524 | 5467524 | 20241102213507_HNLMr | NL0006 | 2024-11-04T14:11:50.900Z | 2024-11-11T14:22:47.439Z |
5467213 | 5467213 | 20241102202448_z3A31 | NL0006 | 2024-11-04T14:11:06.511Z | 2024-11-11T14:22:45.640Z |
5467010 | 5467010 | 20241102194527_UNBIs | NL0006 | 2024-11-04T14:10:28.110Z | 2024-11-11T14:22:44.850Z |
5466626 | 5466626 | 20241102182052_pWK0M | NL0006 | 2024-11-04T14:09:26.913Z | 2024-11-11T14:22:42.067Z |
5466619 | 5466619 | 20241102181739_bOB8v | NL0006 | 2024-11-04T14:09:25.840Z | 2024-11-11T14:22:41.901Z |
5418546 | 5418546 | 20241027211006_KVV4G | NL0006 | 2024-10-30T12:15:49.323Z | 2024-11-05T14:27:10.545Z |
5417587 | 5417587 | 20241027184905_BjlGy | NL0006 | 2024-10-30T12:13:54.829Z | 2024-11-05T14:27:07.685Z |
5417336 | 5417336 | 20241027181644_yKpcI | NL0006 | 2024-10-30T12:13:32.490Z | 2024-11-05T14:27:06.976Z |
5404344 | 5404344 | 20241026231844_4YASn | NL0006 | 2024-10-29T12:11:11.540Z | 2024-11-04T14:28:50.732Z |
5403604 | 5403604 | 20241026221535_uwUAS | NL0006 | 2024-10-29T12:10:01.527Z | 2024-11-04T14:28:49.318Z |
5403601 | 5403601 | 20241026221532_sk6QB | NL0006 | 2024-10-29T12:10:01.201Z | 2024-11-04T14:28:49.313Z |
5402145 | 5402145 | 20241026184923_cCS9h | NL0006 | 2024-10-29T12:06:30.670Z | 2024-11-04T14:28:42.482Z |
5398325 | 5398325 | 20241026024422_xsIQ0 | NL0006 | 2024-10-28T12:19:10.659Z | 2024-11-03T14:27:35.894Z |
5398318 | 5398318 | 20241026024422_J9KFR | NL0006 | 2024-10-28T12:19:10.596Z | 2024-11-03T14:27:35.889Z |
5395184 | 5395184 | 20241025221855_Wq6bB | NL0006 | 2024-10-28T12:16:00.471Z | 2024-11-03T14:27:24.182Z |
5395010 | 5395010 | 20241025220000_y45VI | NL0006 | 2024-10-28T12:15:52.690Z | 2024-11-03T14:27:23.641Z |
5393698 | 5393698 | 20241025183028_o1Ynr | NL0006 | 2024-10-28T12:13:02.125Z | 2024-11-03T14:27:17.441Z |
5393539 | 5393539 | 20241025180555_7qwxz | NL0006 | 2024-10-28T12:12:44.604Z | 2024-11-03T14:27:16.014Z |
5377318 | 5377318 | 20241024044429_xup8c | NL0006 | 2024-10-26T12:22:33.910Z | 2024-11-01T12:27:02.377Z |
5377301 | 5377301 | 20241024044215_2h25L | NL0006 | 2024-10-26T12:22:33.323Z | 2024-11-01T12:27:02.354Z |
5377027 | 5377027 | 20241024042936_nCsoH | NL0006 | 2024-10-26T12:22:23.445Z | 2024-11-01T12:27:02.128Z |
5376971 | 5376971 | 20241024042710_5q2Ru | NL0006 | 2024-10-26T12:22:20.550Z | 2024-11-01T12:27:02.110Z |
5374938 | 5374938 | 20241024025021_4gDEW | NL0006 | 2024-10-26T12:21:06.458Z | 2024-11-01T12:27:00.046Z |
5374873 | 5374873 | 20241024024758_2ciCq | NL0006 | 2024-10-26T12:21:04.494Z | 2024-11-01T12:27:00.022Z |
5373519 | 5373519 | 20241024014127_Hs2xo | NL0006 | 2024-10-26T12:20:15.080Z | 2024-11-01T12:26:58.312Z |
5372837 | 5372837 | 20241024011113_XkBWx | NL0006 | 2024-10-26T12:19:45.477Z | 2024-11-01T12:26:58.000Z |
5364414 | 5364414 | 20241023222637_kyL8K | NL0006 | 2024-10-25T12:17:20.128Z | 2024-11-01T12:26:55.045Z |
5363833 | 5363833 | 20241023214933_5mDpk | NL0006 | 2024-10-25T12:16:52.442Z | 2024-11-01T12:26:53.888Z |
5363727 | 5363727 | 20241023213852_I7NhT | NL0006 | 2024-10-25T12:16:38.239Z | 2024-11-01T12:26:53.585Z |
5363311 | 5363311 | 20241023204420_ZtdeT | NL0006 | 2024-10-25T12:15:53.680Z | 2024-11-01T12:26:53.065Z |
5351984 | 5351984 | 20241023000349_Em4d7 | NL0006 | 2024-10-24T12:18:12.522Z | 2024-10-31T12:30:01.470Z |
5351865 | 5351865 | 20241022235634_MLIr0 | NL0006 | 2024-10-24T12:18:05.929Z | 2024-10-31T12:30:01.127Z |
5351588 | 5351588 | 20241022233911_oaywY | NL0006 | 2024-10-24T12:17:40.805Z | 2024-10-31T12:30:00.568Z |
5351465 | 5351465 | 20241022232938_YN8nR | NL0006 | 2024-10-24T12:17:33.504Z | 2024-10-31T12:30:00.426Z |
5351217 | 5351217 | 20241022230824_YSeEG | NL0006 | 2024-10-24T12:17:20.846Z | 2024-10-31T12:29:59.618Z |
5351062 | 5351062 | 20241022225204_VhLx5 | NL0006 | 2024-10-24T12:17:07.534Z | 2024-10-31T12:29:59.320Z |
5351046 | 5351046 | 20241022225028_F01EX | NL0006 | 2024-10-24T12:17:05.428Z | 2024-10-31T12:29:59.303Z |
5350233 | 5350233 | 20241022212442_XAn22 | NL0006 | 2024-10-24T12:15:30.172Z | 2024-10-31T12:29:57.588Z |
5350022 | 5350022 | 20241022210250_a54wG | NL0006 | 2024-10-24T12:15:06.922Z | 2024-10-31T12:29:57.170Z |
5349998 | 5349998 | 20241022210125_222Jj | NL0006 | 2024-10-24T12:15:03.021Z | 2024-10-31T12:29:57.108Z |
5349247 | 5349247 | 20241022193622_rr5gb | NL0006 | 2024-10-24T12:13:21.158Z | 2024-10-31T12:29:54.931Z |
5349239 | 5349239 | 20241022193605_dY5dX | NL0006 | 2024-10-24T12:13:20.838Z | 2024-10-31T12:29:54.928Z |
5348782 | 5348782 | 20241022185805_K0nTt | NL0006 | 2024-10-24T12:12:19.281Z | 2024-10-31T12:29:53.787Z |
5348391 | 5348391 | 20241022181415_JBdTl | NL0006 | 2024-10-24T12:11:20.102Z | 2024-10-31T12:29:52.335Z |
5326893 | 5326893 | 20241019221925_4D3Wt | NL0006 | 2024-10-21T12:10:45.199Z | 2024-10-28T12:26:42.877Z |
5326463 | 5326463 | 20241019183543_fmhPM | NL0006 | 2024-10-21T12:09:28.419Z | 2024-10-28T12:26:41.729Z |
5312515 | 5312515 | 20241015034836_nFmbt | NL0006 | 2024-10-16T12:10:45.281Z | 2024-10-23T12:24:51.476Z |
5312391 | 5312391 | 20241015032747_2Gs6q | NL0006 | 2024-10-16T12:10:34.067Z | 2024-10-23T12:24:50.800Z |
5312033 | 5312033 | 20241015023736_oLdJE | NL0006 | 2024-10-16T12:09:54.144Z | 2024-10-23T12:24:47.584Z |
5312001 | 5312001 | 20241015023437_1Y4CZ | NL0006 | 2024-10-16T12:09:52.259Z | 2024-10-23T12:24:47.338Z |
5310862 | 5310862 | 20241014210423_fwspi | NL0006 | 2024-10-16T12:07:55.346Z | 2024-10-23T12:24:39.449Z |
5310823 | 5310823 | 20241014204128_sLFxB | NL0006 | 2024-10-16T12:07:51.708Z | 2024-10-23T12:24:39.080Z |
5310524 | 5310524 | 20241014184338_v2EfD | NL0006 | 2024-10-16T12:07:11.064Z | 2024-10-23T12:24:34.555Z |
5306732 | 5306732 | 20241014034610_2ZAk1 | NL0006 | 2024-10-15T12:08:18.138Z | 2024-10-22T12:24:42.885Z |
5306716 | 5306716 | 20241014034209_V4A7K | NL0006 | 2024-10-15T12:08:16.359Z | 2024-10-22T12:24:42.335Z |
5303843 | 5303843 | 20241013034022_ahN3o | NL0006 | 2024-10-14T12:17:35.313Z | 2024-10-21T12:24:20.716Z |
5303269 | 5303269 | 20241013024410_Wnybl | NL0006 | 2024-10-14T12:17:17.748Z | 2024-10-21T12:24:16.475Z |
5293649 | 5293649 | 20241012020339_eGwi4 | NL0006 | 2024-10-13T12:17:43.549Z | 2024-10-20T12:25:02.722Z |
5293431 | 5293431 | 20241012013242_DcqG6 | NL0006 | 2024-10-13T12:17:28.653Z | 2024-10-20T12:24:59.637Z |
5293327 | 5293327 | 20241012011918_2Pvwe | NL0006 | 2024-10-13T12:17:19.984Z | 2024-10-20T12:24:57.815Z |
5292979 | 5292979 | 20241012004017_3wKNF | NL0006 | 2024-10-13T12:16:50.904Z | 2024-10-20T12:24:54.047Z |
5292764 | 5292764 | 20241012001811_ndc2X | NL0006 | 2024-10-13T12:16:29.973Z | 2024-10-20T12:24:50.267Z |
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);