participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,230 rows where station_code = "NZ001L" 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 |
---|---|---|---|---|---|
5130960 | 5130960 | 20240917170316_KLK2D | NZ001L | 2024-09-19T12:14:01.555Z | 2024-09-19T12:14:01.555Z |
5130790 | 5130790 | 20240917152235_2xJEw | NZ001L | 2024-09-19T12:13:50.233Z | 2024-09-19T12:13:50.233Z |
5130786 | 5130786 | 20240917152225_GE81T | NZ001L | 2024-09-19T12:13:50.043Z | 2024-09-19T12:13:50.043Z |
5083638 | 5083638 | 20240911140255_lcEbS | NZ001L | 2024-09-15T12:18:44.975Z | 2024-09-19T12:21:49.744Z |
5083458 | 5083458 | 20240911132553_fsly3 | NZ001L | 2024-09-15T12:18:42.281Z | 2024-09-19T12:21:49.591Z |
5083315 | 5083315 | 20240911125427_d33Iy | NZ001L | 2024-09-15T12:18:38.829Z | 2024-09-19T12:21:49.479Z |
5071286 | 5071286 | 20240911162937_6MTs2 | NZ001L | 2024-09-15T12:02:10.539Z | 2024-09-19T12:21:01.379Z |
5071125 | 5071125 | 20240911160219_pZ5b4 | NZ001L | 2024-09-15T12:01:45.231Z | 2024-09-19T12:21:01.050Z |
5070759 | 5070759 | 20240911150745_HZ24e | NZ001L | 2024-09-15T12:00:46.815Z | 2024-09-19T12:21:00.210Z |
5070541 | 5070541 | 20240911143057_Rnhrh | NZ001L | 2024-09-15T12:00:17.102Z | 2024-09-19T12:20:59.227Z |
5062179 | 5062179 | 20240909165509_3e6Ei | NZ001L | 2024-09-14T12:11:54.434Z | 2024-09-18T12:15:10.519Z |
5057058 | 5057058 | 20240908120637_4Bw5n | NZ001L | 2024-09-13T12:17:44.387Z | 2024-09-16T12:21:28.727Z |
5056842 | 5056842 | 20240908113110_2YM0F | NZ001L | 2024-09-13T12:17:39.929Z | 2024-09-16T12:21:27.549Z |
5055827 | 5055827 | 20240908090809_WK0Zg | NZ001L | 2024-09-13T12:17:23.683Z | 2024-09-16T12:21:22.159Z |
5051184 | 5051184 | 20240907165750_OGFdd | NZ001L | 2024-09-13T12:14:05.231Z | 2024-09-16T12:20:59.785Z |
5045627 | 5045627 | 20240908173316_p0AqQ | NZ001L | 2024-09-13T12:04:29.423Z | 2024-09-17T12:18:56.881Z |
5045520 | 5045520 | 20240908171714_btH4V | NZ001L | 2024-09-13T12:04:16.312Z | 2024-09-17T12:18:56.686Z |
5045376 | 5045376 | 20240908165924_vKZc3 | NZ001L | 2024-09-13T12:04:04.460Z | 2024-09-17T12:18:56.448Z |
5045326 | 5045326 | 20240908165244_h53xL | NZ001L | 2024-09-13T12:04:00.201Z | 2024-09-17T12:18:56.378Z |
5045315 | 5045315 | 20240908165232_jLT7r | NZ001L | 2024-09-13T12:03:58.456Z | 2024-09-17T12:18:56.375Z |
5045274 | 5045274 | 20240908164852_Za6bf | NZ001L | 2024-09-13T12:03:50.182Z | 2024-09-17T12:18:56.328Z |
5045126 | 5045126 | 20240908162500_ijJym | NZ001L | 2024-09-13T12:03:35.205Z | 2024-09-17T12:18:55.949Z |
5044883 | 5044883 | 20240908155250_LUNbY | NZ001L | 2024-09-13T12:03:06.981Z | 2024-09-17T12:18:55.346Z |
5044118 | 5044118 | 20240908141545_wR0iB | NZ001L | 2024-09-13T12:01:30.673Z | 2024-09-17T12:18:53.565Z |
5043908 | 5043908 | 20240908133452_Mtsmx | NZ001L | 2024-09-13T12:00:57.207Z | 2024-09-17T12:18:53.035Z |
5043903 | 5043903 | 20240908133451_dSxhX | NZ001L | 2024-09-13T12:00:57.032Z | 2024-09-17T12:18:53.034Z |
5042363 | 5042363 | 20240906104336_XCDnG | NZ001L | 2024-09-12T12:17:01.550Z | 2024-09-14T12:23:17.124Z |
5042324 | 5042324 | 20240906103239_ad8mT | NZ001L | 2024-09-12T12:17:00.905Z | 2024-09-14T12:23:16.902Z |
5041575 | 5041575 | 20240906083306_DRN89 | NZ001L | 2024-09-12T12:16:44.587Z | 2024-09-14T12:23:13.958Z |
5041489 | 5041489 | 20240906082440_25fFz | NZ001L | 2024-09-12T12:16:43.062Z | 2024-09-14T12:23:13.752Z |
5037852 | 5037852 | 20240905165721_20ZSV | NZ001L | 2024-09-12T12:14:16.256Z | 2024-09-14T12:22:54.743Z |
5037540 | 5037540 | 20240905160356_RKtlY | NZ001L | 2024-09-12T12:14:08.410Z | 2024-09-14T12:22:54.294Z |
5037208 | 5037208 | 20240905152100_5HZqb | NZ001L | 2024-09-12T12:14:02.951Z | 2024-09-14T12:22:53.960Z |
5037131 | 5037131 | 20240905151325_G6GIt | NZ001L | 2024-09-12T12:14:01.400Z | 2024-09-14T12:22:53.778Z |
5037113 | 5037113 | 20240905151048_O3unG | NZ001L | 2024-09-12T12:14:01.144Z | 2024-09-14T12:22:53.770Z |
5036590 | 5036590 | 20240905135746_G87cy | NZ001L | 2024-09-12T12:13:49.645Z | 2024-09-14T12:22:52.607Z |
5036092 | 5036092 | 20240905123917_OyZpG | NZ001L | 2024-09-12T12:13:23.393Z | 2024-09-14T12:22:51.852Z |
5035981 | 5035981 | 20240905122123_g4rl7 | NZ001L | 2024-09-12T12:13:15.774Z | 2024-09-14T12:22:51.696Z |
5029284 | 5029284 | 20240905115239_tJq2K | NZ001L | 2024-09-11T12:16:25.022Z | 2024-09-14T12:22:51.360Z |
5029010 | 5029010 | 20240905111915_aB2yq | NZ001L | 2024-09-11T12:16:06.371Z | 2024-09-14T12:22:50.403Z |
5028040 | 5028040 | 20240905085603_2nGl0 | NZ001L | 2024-09-11T12:14:45.866Z | 2024-09-13T12:20:05.211Z |
5027217 | 5027217 | 20240905070634_jci4b | NZ001L | 2024-09-11T12:13:54.681Z | 2024-09-13T12:20:02.119Z |
5023697 | 5023697 | 20240905165721_D2CqD | NZ001L | 2024-09-10T12:16:49.333Z | 2024-09-11T12:16:31.749Z |
5023415 | 5023415 | 20240905160356_2Y8f0 | NZ001L | 2024-09-10T12:16:44.687Z | 2024-09-14T12:22:54.289Z |
5023095 | 5023095 | 20240905152100_CQA2C | NZ001L | 2024-09-10T12:16:38.936Z | 2024-09-11T12:16:31.529Z |
5022480 | 5022480 | 20240905085602_n33Jy | NZ001L | 2024-09-10T12:16:20.174Z | 2024-09-13T12:20:05.189Z |
5021675 | 5021675 | 20240905070634_42ydn | NZ001L | 2024-09-10T12:15:46.227Z | 2024-09-13T12:20:02.138Z |
5018274 | 5018274 | 20240904173505_6iVQt | NZ001L | 2024-09-10T12:10:18.590Z | 2024-09-13T12:19:47.506Z |
5018131 | 5018131 | 20240904171327_tSHMV | NZ001L | 2024-09-10T12:10:02.825Z | 2024-09-13T12:19:47.248Z |
5018013 | 5018013 | 20240904170544_rVudu | NZ001L | 2024-09-10T12:09:53.475Z | 2024-09-13T12:19:47.161Z |
5017936 | 5017936 | 20240904165621_9UfoB | NZ001L | 2024-09-10T12:09:46.225Z | 2024-09-13T12:19:47.136Z |
5017819 | 5017819 | 20240904164414_QZhI7 | NZ001L | 2024-09-10T12:09:36.564Z | 2024-09-13T12:19:47.094Z |
5017653 | 5017653 | 20240904162822_E7co6 | NZ001L | 2024-09-10T12:09:21.689Z | 2024-09-13T12:19:47.032Z |
5017544 | 5017544 | 20240904161734_mIM0p | NZ001L | 2024-09-10T12:09:14.735Z | 2024-09-13T12:19:46.918Z |
5017480 | 5017480 | 20240904161139_FQi1U | NZ001L | 2024-09-10T12:09:12.015Z | 2024-09-13T12:19:46.892Z |
5017457 | 5017457 | 20240904161104_nsPN2 | NZ001L | 2024-09-10T12:09:11.523Z | 2024-09-13T12:19:46.889Z |
5017383 | 5017383 | 20240904160357_v3QaE | NZ001L | 2024-09-10T12:09:07.279Z | 2024-09-13T12:19:46.840Z |
5017291 | 5017291 | 20240904155332_sWDRw | NZ001L | 2024-09-10T12:09:02.161Z | 2024-09-13T12:19:46.758Z |
5017140 | 5017140 | 20240904153316_jZbjJ | NZ001L | 2024-09-10T12:08:52.185Z | 2024-09-13T12:19:46.613Z |
5017063 | 5017063 | 20240904152624_zcKae | NZ001L | 2024-09-10T12:08:43.693Z | 2024-09-13T12:19:46.553Z |
5016995 | 5016995 | 20240904152046_I1ds3 | NZ001L | 2024-09-10T12:08:37.961Z | 2024-09-13T12:19:46.491Z |
5016962 | 5016962 | 20240904151503_wm3pT | NZ001L | 2024-09-10T12:08:35.269Z | 2024-09-13T12:19:46.478Z |
5016891 | 5016891 | 20240904150831_kvSEu | NZ001L | 2024-09-10T12:08:29.074Z | 2024-09-13T12:19:46.411Z |
5016728 | 5016728 | 20240904144622_g9ofB | NZ001L | 2024-09-10T12:08:12.695Z | 2024-09-13T12:19:46.204Z |
5016513 | 5016513 | 20240904142217_G86GE | NZ001L | 2024-09-10T12:07:55.236Z | 2024-09-13T12:19:45.829Z |
5015833 | 5015833 | 20240904124231_W6RPY | NZ001L | 2024-09-10T12:06:49.779Z | 2024-09-13T12:19:44.728Z |
5015679 | 5015679 | 20240904121248_m3hUl | NZ001L | 2024-09-10T12:06:37.927Z | 2024-09-13T12:19:44.595Z |
5015418 | 5015418 | 20240905151325_1voWP | NZ001L | 2024-09-10T12:05:15.746Z | 2024-09-14T12:22:53.781Z |
5015401 | 5015401 | 20240905151048_WtTQR | NZ001L | 2024-09-10T12:05:14.299Z | 2024-09-14T12:22:53.771Z |
5014899 | 5014899 | 20240905135747_t76Qz | NZ001L | 2024-09-10T12:04:13.122Z | 2024-09-14T12:22:52.610Z |
5014412 | 5014412 | 20240905123917_Sra8y | NZ001L | 2024-09-10T12:03:05.638Z | 2024-09-11T12:16:31.151Z |
5014309 | 5014309 | 20240905122123_XCgzs | NZ001L | 2024-09-10T12:02:45.270Z | 2024-09-14T12:22:51.697Z |
5014095 | 5014095 | 20240905115239_XG4Bo | NZ001L | 2024-09-10T12:02:20.860Z | 2024-09-14T12:22:51.364Z |
5013813 | 5013813 | 20240905111915_h1ujB | NZ001L | 2024-09-10T12:01:39.032Z | 2024-09-11T12:00:36.527Z |
5011927 | 5011927 | 20240904081640_7X13g | NZ001L | 2024-09-09T12:10:09.923Z | 2024-09-12T12:19:34.331Z |
5011872 | 5011872 | 20240904080954_5Ouz2 | NZ001L | 2024-09-09T12:10:06.946Z | 2024-09-12T12:19:33.943Z |
5005986 | 5005986 | 20240903164004_cTaXw | NZ001L | 2024-09-09T12:04:15.433Z | 2024-09-12T12:19:07.167Z |
5005755 | 5005755 | 20240903160512_i7kT7 | NZ001L | 2024-09-09T12:04:02.394Z | 2024-09-12T12:19:06.557Z |
5005296 | 5005296 | 20240903144903_q4Qr7 | NZ001L | 2024-09-09T12:03:34.571Z | 2024-09-12T12:19:05.654Z |
5005292 | 5005292 | 20240903144902_ucgDz | NZ001L | 2024-09-09T12:03:34.440Z | 2024-09-12T12:19:05.651Z |
5004498 | 5004498 | 20240903113905_A9TNa | NZ001L | 2024-09-09T12:02:45.672Z | 2024-09-12T12:19:02.475Z |
5002838 | 5002838 | 20240904104904_PmaRd | NZ001L | 2024-09-09T12:01:05.490Z | 2024-09-13T12:19:42.247Z |
5002222 | 5002222 | 20240904092456_QF3je | NZ001L | 2024-09-09T12:00:14.780Z | 2024-09-13T12:19:40.064Z |
5002091 | 5002091 | 20240902073904_FPLOh | NZ001L | 2024-09-08T12:17:09.949Z | 2024-09-10T12:19:36.022Z |
4993168 | 4993168 | 20240902100003_ssV5P | NZ001L | 2024-09-08T12:01:15.426Z | 2024-09-11T12:20:20.709Z |
4992407 | 4992407 | 20240902080216_YU5Nh | NZ001L | 2024-09-08T12:00:18.932Z | 2024-09-11T12:20:12.430Z |
4984654 | 4984654 | 20240901103518_OpLmx | NZ001L | 2024-09-07T12:02:12.823Z | 2024-09-10T12:19:05.726Z |
4984198 | 4984198 | 20240901092440_0PLGI | NZ001L | 2024-09-07T12:01:33.407Z | 2024-09-10T12:19:04.759Z |
4983671 | 4983671 | 20240901073622_hoB3P | NZ001L | 2024-09-07T12:00:35.647Z | 2024-09-10T12:19:02.332Z |
4957233 | 4957233 | 20240811082230_eg4Eq | NZ001L | 2024-09-03T12:20:58.091Z | 2024-09-06T12:31:10.038Z |
4934276 | 4934276 | 20240810180154_L6eU3 | NZ001L | 2024-09-01T12:05:07.110Z | 2024-09-06T12:20:07.775Z |
4934039 | 4934039 | 20240810174009_0VWzh | NZ001L | 2024-09-01T12:04:53.880Z | 2024-09-06T12:19:52.507Z |
4933951 | 4933951 | 20240810173552_PmYSD | NZ001L | 2024-09-01T12:04:48.068Z | 2024-09-06T12:19:44.290Z |
4933813 | 4933813 | 20240810172832_2OZLB | NZ001L | 2024-09-01T12:04:39.695Z | 2024-09-06T12:19:37.536Z |
4933773 | 4933773 | 20240810172524_8IRMe | NZ001L | 2024-09-01T12:04:37.444Z | 2024-09-06T12:19:34.086Z |
4933616 | 4933616 | 20240810171644_AvP7C | NZ001L | 2024-09-01T12:04:29.542Z | 2024-09-06T12:19:25.667Z |
4933593 | 4933593 | 20240810171450_mPYOa | NZ001L | 2024-09-01T12:04:28.575Z | 2024-09-06T12:19:24.553Z |
4933385 | 4933385 | 20240810170047_8fl0O | NZ001L | 2024-09-01T12:04:16.798Z | 2024-09-06T12:19:09.869Z |
4933179 | 4933179 | 20240810164800_anAZt | NZ001L | 2024-09-01T12:04:01.782Z | 2024-09-06T12:19:01.143Z |
4933081 | 4933081 | 20240810164057_5ylFo | NZ001L | 2024-09-01T12:03:55.694Z | 2024-09-06T12:18:56.213Z |
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);