participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,781 rows where station_code = "NZ002B" 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 |
---|---|---|---|---|---|
5433727 | 5433727 | 20241027161518_ra692 | NZ002B | 2024-10-31T12:23:48.947Z | 2024-11-03T14:25:42.652Z |
5433712 | 5433712 | 20241027091501_vjN1y | NZ002B | 2024-10-31T12:23:03.774Z | 2024-11-03T14:25:31.133Z |
5426837 | 5426837 | 20241028140318_IhvkJ | NZ002B | 2024-10-31T12:12:31.198Z | 2024-11-03T14:24:45.264Z |
5426557 | 5426557 | 20241028125541_BwujE | NZ002B | 2024-10-31T12:12:01.595Z | 2024-11-03T14:24:41.939Z |
5424509 | 5424509 | 20241029143839_XXF6O | NZ002B | 2024-10-31T12:05:15.980Z | 2024-11-03T14:23:37.922Z |
5424440 | 5424440 | 20241029142659_e6x5t | NZ002B | 2024-10-31T12:05:04.161Z | 2024-11-03T14:23:36.684Z |
5424164 | 5424164 | 20241029132554_Jgm3K | NZ002B | 2024-10-31T12:03:58.192Z | 2024-11-03T14:23:34.935Z |
5422500 | 5422500 | 20241028130854_uBzfG | NZ002B | 2024-10-30T12:20:27.268Z | 2024-11-03T14:24:42.528Z |
5422458 | 5422458 | 20241028130447_enVxK | NZ002B | 2024-10-30T12:20:26.976Z | 2024-11-03T14:24:42.375Z |
5421989 | 5421989 | 20241028120522_71jHM | NZ002B | 2024-10-30T12:20:19.622Z | 2024-11-03T14:24:40.022Z |
5421975 | 5421975 | 20241028120456_8YZL2 | NZ002B | 2024-10-30T12:20:19.417Z | 2024-11-03T14:24:39.981Z |
5421826 | 5421826 | 20241028114509_FPILs | NZ002B | 2024-10-30T12:20:15.823Z | 2024-11-03T14:24:39.393Z |
5421713 | 5421713 | 20241028112504_Wx8F8 | NZ002B | 2024-10-30T12:20:13.241Z | 2024-11-03T14:24:39.058Z |
5416475 | 5416475 | 20241027155813_pL3mM | NZ002B | 2024-10-30T12:11:39.570Z | 2024-11-03T14:25:42.266Z |
5416453 | 5416453 | 20241027155405_V2pK8 | NZ002B | 2024-10-30T12:11:37.181Z | 2024-11-03T14:25:42.225Z |
5415097 | 5415097 | 20241027130135_1tgDB | NZ002B | 2024-10-30T12:08:58.402Z | 2024-11-03T14:25:39.012Z |
5414816 | 5414816 | 20241027121601_5Uq5T | NZ002B | 2024-10-30T12:08:15.584Z | 2024-11-03T14:25:37.854Z |
5414348 | 5414348 | 20241027113141_0rRa3 | NZ002B | 2024-10-30T12:07:14.972Z | 2024-11-03T14:25:36.098Z |
5414119 | 5414119 | 20241027110821_vymAh | NZ002B | 2024-10-30T12:06:39.434Z | 2024-11-03T14:25:35.594Z |
5414097 | 5414097 | 20241027110509_3dKy3 | NZ002B | 2024-10-30T12:06:36.877Z | 2024-11-03T14:25:35.537Z |
5413716 | 5413716 | 20241028105135_RT34x | NZ002B | 2024-10-30T12:04:01.693Z | 2024-11-03T14:24:37.996Z |
5413435 | 5413435 | 20241028100008_vsH5D | NZ002B | 2024-10-30T12:03:01.684Z | 2024-11-03T14:24:35.423Z |
5413323 | 5413323 | 20241028093855_reCpP | NZ002B | 2024-10-30T12:02:43.289Z | 2024-11-03T14:24:34.293Z |
5413212 | 5413212 | 20241028091013_xe3UY | NZ002B | 2024-10-30T12:02:16.206Z | 2024-11-03T14:24:33.108Z |
5412205 | 5412205 | 20241027100957_dDXsx | NZ002B | 2024-10-29T12:19:33.815Z | 2024-11-03T14:25:33.614Z |
5412053 | 5412053 | 20241027095610_AEf2y | NZ002B | 2024-10-29T12:19:25.715Z | 2024-11-03T14:25:32.903Z |
5411757 | 5411757 | 20241027092129_BnpPe | NZ002B | 2024-10-29T12:19:11.205Z | 2024-11-03T14:25:31.308Z |
5411710 | 5411710 | 20241027091421_Uo3j7 | NZ002B | 2024-10-29T12:19:08.240Z | 2024-11-03T14:25:31.103Z |
5411584 | 5411584 | 20241027085728_Uz0qo | NZ002B | 2024-10-29T12:19:01.540Z | 2024-11-03T14:25:30.544Z |
5360423 | 5360423 | 20241023161536_l5zoU | NZ002B | 2024-10-25T12:10:49.168Z | 2024-11-01T12:26:47.439Z |
5336892 | 5336892 | 20241022091123_ctto1 | NZ002B | 2024-10-23T12:03:42.998Z | 2024-10-31T12:29:42.743Z |
5336741 | 5336741 | 20241022085103_hwqwd | NZ002B | 2024-10-23T12:03:08.769Z | 2024-10-31T12:29:42.304Z |
5330878 | 5330878 | 20241021125906_oQPs5 | NZ002B | 2024-10-22T12:08:03.918Z | 2024-10-30T12:26:38.627Z |
5330743 | 5330743 | 20241021123826_PTDay | NZ002B | 2024-10-22T12:07:33.157Z | 2024-10-30T12:26:38.336Z |
5330658 | 5330658 | 20241021122617_wFN28 | NZ002B | 2024-10-22T12:07:24.043Z | 2024-10-30T12:26:37.777Z |
5330089 | 5330089 | 20241021112451_7qyVo | NZ002B | 2024-10-22T12:05:59.004Z | 2024-10-30T12:26:36.119Z |
5329975 | 5329975 | 20241021111254_iwIbZ | NZ002B | 2024-10-22T12:05:43.339Z | 2024-10-30T12:26:35.931Z |
5329901 | 5329901 | 20241021110541_ENUjX | NZ002B | 2024-10-22T12:05:34.598Z | 2024-10-30T12:26:35.775Z |
5325370 | 5325370 | 20241020145112_0nHX0 | NZ002B | 2024-10-21T12:05:37.727Z | 2024-10-29T12:26:31.067Z |
5325306 | 5325306 | 20241020143158_5L5Bq | NZ002B | 2024-10-21T12:05:23.586Z | 2024-10-29T12:26:30.920Z |
5325232 | 5325232 | 20241020135922_VXsPs | NZ002B | 2024-10-21T12:05:14.226Z | 2024-10-29T12:26:30.803Z |
5325216 | 5325216 | 20241020135228_AewtC | NZ002B | 2024-10-21T12:05:12.583Z | 2024-10-29T12:26:30.763Z |
5325212 | 5325212 | 20241020135005_Qi4n0 | NZ002B | 2024-10-21T12:05:12.238Z | 2024-10-29T12:26:30.762Z |
5325189 | 5325189 | 20241020133919_tBVlW | NZ002B | 2024-10-21T12:05:09.404Z | 2024-10-29T12:26:30.732Z |
5325163 | 5325163 | 20241020133435_K7SID | NZ002B | 2024-10-21T12:05:07.253Z | 2024-10-29T12:26:30.715Z |
5325158 | 5325158 | 20241020133232_qhBqZ | NZ002B | 2024-10-21T12:05:06.865Z | 2024-10-29T12:26:30.714Z |
5325131 | 5325131 | 20241020132437_ZQQYY | NZ002B | 2024-10-21T12:05:04.066Z | 2024-10-29T12:26:30.688Z |
5325118 | 5325118 | 20241020131305_Bvvbx | NZ002B | 2024-10-21T12:05:02.381Z | 2024-10-29T12:26:30.678Z |
5325050 | 5325050 | 20241020124044_1ewws | NZ002B | 2024-10-21T12:04:44.762Z | 2024-10-29T12:26:30.599Z |
5325034 | 5325034 | 20241020123804_xI3t9 | NZ002B | 2024-10-21T12:04:40.200Z | 2024-10-29T12:26:30.567Z |
5324952 | 5324952 | 20241020115609_uN9OD | NZ002B | 2024-10-21T12:04:28.952Z | 2024-10-29T12:26:30.375Z |
5324909 | 5324909 | 20241020114337_zwut2 | NZ002B | 2024-10-21T12:04:22.774Z | 2024-10-29T12:26:30.269Z |
5324874 | 5324874 | 20241020113458_31cGz | NZ002B | 2024-10-21T12:04:17.994Z | 2024-10-29T12:26:30.226Z |
5324856 | 5324856 | 20241020113028_R5NzV | NZ002B | 2024-10-21T12:04:15.198Z | 2024-10-29T12:26:30.208Z |
5324797 | 5324797 | 20241020111918_fZa4Q | NZ002B | 2024-10-21T12:03:56.886Z | 2024-10-29T12:26:30.078Z |
5324787 | 5324787 | 20241020111450_bLD9I | NZ002B | 2024-10-21T12:03:55.624Z | 2024-10-29T12:26:30.067Z |
5324750 | 5324750 | 20241020110944_Lct49 | NZ002B | 2024-10-21T12:03:48.323Z | 2024-10-29T12:26:29.973Z |
5324587 | 5324587 | 20241020103731_9kabN | NZ002B | 2024-10-21T12:03:13.696Z | 2024-10-29T12:26:29.504Z |
5324089 | 5324089 | 20241020083755_6E2Hg | NZ002B | 2024-10-21T12:01:39.062Z | 2024-10-29T12:26:28.061Z |
5322755 | 5322755 | 20241019153930_REEZ3 | NZ002B | 2024-10-20T12:03:00.033Z | 2024-10-28T12:26:41.290Z |
5322607 | 5322607 | 20241019142917_flP2k | NZ002B | 2024-10-20T12:02:35.533Z | 2024-10-28T12:26:41.009Z |
5322550 | 5322550 | 20241019135015_3aHuE | NZ002B | 2024-10-20T12:02:23.326Z | 2024-10-28T12:26:40.958Z |
5322544 | 5322544 | 20241019134303_g73zA | NZ002B | 2024-10-20T12:02:21.660Z | 2024-10-28T12:26:40.946Z |
5322362 | 5322362 | 20241019113813_i0EcP | NZ002B | 2024-10-20T12:01:47.538Z | 2024-10-28T12:26:40.444Z |
5322333 | 5322333 | 20241019111856_YJvRa | NZ002B | 2024-10-20T12:01:43.572Z | 2024-10-28T12:26:40.388Z |
5322095 | 5322095 | 20241019090820_iiIWj | NZ002B | 2024-10-20T12:00:54.992Z | 2024-10-28T12:26:39.825Z |
5322007 | 5322007 | 20241019081714_lzf2q | NZ002B | 2024-10-20T12:00:40.120Z | 2024-10-28T12:26:39.519Z |
5319479 | 5319479 | 20241018143829_LJwJC | NZ002B | 2024-10-19T12:02:22.907Z | 2024-10-27T12:28:48.321Z |
5317635 | 5317635 | 20241017073905_9mzEL | NZ002B | 2024-10-18T12:00:23.901Z | 2024-10-26T12:27:50.712Z |
5315532 | 5315532 | 20241015135128_K6QlW | NZ002B | 2024-10-17T12:04:54.805Z | 2024-10-24T12:27:53.199Z |
5314850 | 5314850 | 20241016161754_coUQP | NZ002B | 2024-10-17T12:03:01.303Z | 2024-10-25T12:24:32.630Z |
5314141 | 5314141 | 20241016114008_Gesds | NZ002B | 2024-10-17T12:01:45.543Z | 2024-10-25T12:24:28.875Z |
5314005 | 5314005 | 20241016110201_6hzQ7 | NZ002B | 2024-10-17T12:01:33.212Z | 2024-10-25T12:24:28.307Z |
5313659 | 5313659 | 20241016092400_JG350 | NZ002B | 2024-10-17T12:00:47.181Z | 2024-10-25T12:24:26.340Z |
5298093 | 5298093 | 20241012152706_QWBrM | NZ002B | 2024-10-14T12:09:52.475Z | 2024-10-21T12:23:24.880Z |
5297781 | 5297781 | 20241012143455_kNKdN | NZ002B | 2024-10-14T12:09:08.578Z | 2024-10-21T12:23:22.700Z |
5297717 | 5297717 | 20241012142006_wlJW6 | NZ002B | 2024-10-14T12:09:02.497Z | 2024-10-21T12:23:22.167Z |
5297509 | 5297509 | 20241012133831_VWFkt | NZ002B | 2024-10-14T12:08:31.622Z | 2024-10-21T12:23:18.686Z |
5297481 | 5297481 | 20241012133151_eTDpO | NZ002B | 2024-10-14T12:08:29.288Z | 2024-10-21T12:23:18.630Z |
5297180 | 5297180 | 20241012120646_nVyNU | NZ002B | 2024-10-14T12:07:52.701Z | 2024-10-21T12:23:14.968Z |
5297156 | 5297156 | 20241012120055_ehCf4 | NZ002B | 2024-10-14T12:07:43.231Z | 2024-10-21T12:23:14.561Z |
5297066 | 5297066 | 20241012114722_3f28f | NZ002B | 2024-10-14T12:07:24.395Z | 2024-10-21T12:23:12.791Z |
5296423 | 5296423 | 20241012101645_5E0gz | NZ002B | 2024-10-14T12:06:09.795Z | 2024-10-21T12:23:03.457Z |
5290220 | 5290220 | 20241011164624_BeTPR | NZ002B | 2024-10-13T12:12:03.162Z | 2024-10-20T12:24:13.764Z |
5290195 | 5290195 | 20241011164253_nmevJ | NZ002B | 2024-10-13T12:12:01.758Z | 2024-10-20T12:24:13.412Z |
5290003 | 5290003 | 20241011162239_mdL73 | NZ002B | 2024-10-13T12:11:47.618Z | 2024-10-20T12:24:12.382Z |
5289896 | 5289896 | 20241011161538_N4bng | NZ002B | 2024-10-13T12:11:37.792Z | 2024-10-20T12:24:11.860Z |
5289792 | 5289792 | 20241011160428_Pgwxl | NZ002B | 2024-10-13T12:11:25.620Z | 2024-10-20T12:24:10.499Z |
5289789 | 5289789 | 20241011160324_JpxcP | NZ002B | 2024-10-13T12:11:25.358Z | 2024-10-20T12:24:10.463Z |
5289696 | 5289696 | 20241011155515_Jzxlo | NZ002B | 2024-10-13T12:11:15.394Z | 2024-10-20T12:24:09.785Z |
5289420 | 5289420 | 20241011152804_R34n7 | NZ002B | 2024-10-13T12:10:43.540Z | 2024-10-20T12:24:06.700Z |
5289263 | 5289263 | 20241011151353_erHgB | NZ002B | 2024-10-13T12:10:33.265Z | 2024-10-20T12:24:05.831Z |
5289236 | 5289236 | 20241011151156_BLhkJ | NZ002B | 2024-10-13T12:10:32.289Z | 2024-10-20T12:24:05.659Z |
5289083 | 5289083 | 20241011145734_c9VrG | NZ002B | 2024-10-13T12:10:23.312Z | 2024-10-20T12:24:04.424Z |
5288900 | 5288900 | 20241011144027_5Ki0D | NZ002B | 2024-10-13T12:10:09.206Z | 2024-10-20T12:24:03.279Z |
5288886 | 5288886 | 20241011143840_RlJI4 | NZ002B | 2024-10-13T12:10:07.653Z | 2024-10-20T12:24:03.184Z |
5288843 | 5288843 | 20241011143501_7kAMO | NZ002B | 2024-10-13T12:10:02.775Z | 2024-10-20T12:24:02.903Z |
5288696 | 5288696 | 20241011141932_32P0f | NZ002B | 2024-10-13T12:09:46.040Z | 2024-10-20T12:24:01.814Z |
5288624 | 5288624 | 20241011141405_T4Yl1 | NZ002B | 2024-10-13T12:09:36.520Z | 2024-10-20T12:24:00.640Z |
5288555 | 5288555 | 20241011140802_5z4tE | NZ002B | 2024-10-13T12:09:25.932Z | 2024-10-20T12:23:59.798Z |
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);