names

55 rows where place_id = 603900

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3656145 1912174 1912174 defendant Cathorst Lawrence clothman 603900 603900 Cathorst, Lawrence, of Cranbrook, Kent, clothman 0
3663345 1914459 1914459 defendant parker Thomas   603900 603900 parker, Thomas, of Cranbrook, kent, cloth maker 1
3934228 2001741 2001741 defendant Davy Gervase clothier 603900 603900 Davy, Gervase, of Cranbrook, Kent, clothier 3
3939067 2003394 2003394 defendant Thornton Thomas clothier 603900 603900 Thornton, Thomas, of Cranbrook, Kent, clothier 0
3970387 2014242 2014242 defendant Aware John clothier 603900 603900 Aware, John, of Cranbrook, Kent, clothier 0
4078745 2052694 2052694 plaintiff Thomas John clothier 603900 603900 Thomas, John, of Cranbrook, Kent, clothier 0
4604249 2232500 2232500 defendant Brokeherst Thomas   603900 603900 Brokeherst, Thomas, of Cranbrook, Kent 0
4641052 2243473 2243473 defendant Thomalyn John   603900 603900 Thomalyn, John, of Cranbrook, Kent 0
4649065 2245774 2245774 defendant Bukherst Thomas   603900 603900 Bukherst, Thomas, of Cranbrook, Kent 1
4717441 2270791 2270791 defendant Jan Stephen carpenter 603900 603900 Jan, Stephen, of Cranbrook, Kent, carpenter 1
4718469 2271118 2271118 defendant Beram Richard esq 603900 603900 Beram, Richard, of Cranbrook, Kent, esq 2
4721712 2272127 2272127 defendant Tilthe William gent 603900 603900 Tilthe, William, of Cranbrook, Kent, gent 3
4721714 2272128 2272128 defendant Tilthe William gent 603900 603900 Tilthe, William, of Cranbrook, Kent, gent 0
4736348 2276499 2276499 defendant Jolyf William yeoman 603900 603900 Jolyf, William, of Cranbrook, Kent, yeoman 0
4736355 2276500 2276500 defendant Jolyf William yeoman 603900 603900 Jolyf, William, of Cranbrook, Kent, yeoman 0
4738944 2277269 2277269 defendant Tylthe William husbandman 603900 603900 Tylthe, William, of Cranbrook, Kent, husbandman 2
4755681 2282161 2282161 defendant Salt William dyer 603900 603900 Salt, William, of Cranbrook, Kent, dyer 0
4756334 2282347 2282347 plaintiff Beek William   603900 603900 Beek, William, of Cranbrook, Kent 0
4756336 2282348 2282348 plaintiff Beek William   603900 603900 Beek, William, of Cranbrook, Kent 0
4762210 2284160 2284160 defendant Curtynden William   603900 603900 Curtynden, William, of Cranbrook, Kent, groom 1
4770208 2286655 2286655 defendant Badhurst William chapman 603900 603900 Badhurst, William, of Cranbrook, Kent, chapman 2
4775336 2288279 2288279 defendant Tylthe William   603900 603900 Tylthe, William, of Cranbrook, Kent, franklin 0
4778832 2289353 2289353 defendant Lynche William   603900 603900 Lynche, William, of Cranbrook, Kent, linen draper 0
4852585 2312230 2312230 defendant Salt William dyer 603900 603900 Salt, William, of Cranbrook, Kent, dyer 0
4987661 2353271 2353271 defendant Turk William husbandman 603900 603900 Turk, William, of Cranbrook, Kent, husbandman 0
4987663 2353272 2353272 defendant Turk William husbandman 603900 603900 Turk, William, of Cranbrook, Kent, husbandman 0
5004226 2358128 2358128 defendant Roberd John draper 603900 603900 Roberd, John, of Cranbrook, Kent, draper 0
5178614 2409459 2409459 defendant Turke John husbandman 603900 603900 Turke, John, of Cranbrook, Kent, husbandman 1
5201531 2416205 2416205 defendant Turke John husbandman 603900 603900 Turke, John, of Cranbrook, Kent, husbandman 1
5269860 2436291 2436291 defendant Broun John dyer 603900 603900 Broun, John, of Cranbrook, Kent, dyer 1
5275334 2437859 2437859 defendant Sondon John dyer 603900 603900 Sondon, John, of Cranbrook, Kent, dyer 0
5300950 2445236 2445236 defendant Hovyngden Edward dyer 603900 603900 Hovyngden, Edward, of Cranbrook, Kent, dyer 0
5309969 2448016 2448016 defendant Hamme Henry smith 603900 603900 Hamme, Henry, of Cranbrook, Kent, smith 4
5309976 2448017 2448017 defendant Hamme Henry smith 603900 603900 Hamme, Henry, of Cranbrook, Kent, smith 4
5376109 2468118 2468118 defendant Erle Alan laborer 603900 603900 Erle, Alan, of Cranbrook, Kent, laborer 4
5377994 2468697 2468697 defendant Bysshop Robert husbandman 603900 603900 Bysshop, Robert, of Cranbrook, Kent, husbandman 0
5395518 2473799 2473799 defendant Doule John butcher 603900 603900 Doule, John, of Cranbrook, Kent, butcher 0
5403291 2476018 2476018 defendant Chalcrofte Henry   603900 603900 Chalcrofte, Henry, of Cranbrook, Kent, cloth maker 1
5416310 2479798 2479798 defendant Chalcrofte Henry clothmaker 603900 603900 Chalcrofte, Henry, of Cranbrook, Kent, clothmaker 1
5420660 2481103 2481103 defendant Bettenham William gent 603900 603900 Bettenham, William, of Cranbrook, Kent, gent 0
5433047 2484850 2484850 defendant Chalcrofte Henry clothmaker 603900 603900 Chalcrofte, Henry, of Cranbrook, Kent, clothmaker 1
5433053 2484851 2484851 defendant Chalcrofte Henry clothmaker 603900 603900 Chalcrofte, Henry, of Cranbrook, Kent, clothmaker 1
5441014 2487221 2487221 defendant Boxle John butcher 603900 603900 Boxle, John, of Cranbrook, Kent, butcher 0
5442827 2487767 2487767 defendant Seynden (illegible)   603900 603900 Seynden, _, of Cranbrook, Kent, cloth maker 1
5447907 2489257 2489257 defendant Ddyer Robert dyer 603900 603900 Ddyer, Robert, of Cranbrook, Kent, dyer 2
5449454 2489726 2489726 defendant Lynch Robert clothmaker 603900 603900 Lynch, Robert, of Cranbrook, Kent, clothmaker 0
5449459 2489727 2489727 defendant Lynche Ralph clothmaker 603900 603900 Lynche, Ralph, of Cranbrook, Kent, clothmaker 0
5449461 2489727 2489727 defendant Mapesden John yeoman 603900 603900 Mapesden, John, of Cranbrook, Kent, yeoman 2
5452170 2490523 2490523 defendant Bogas Robert clothmaker 603900 603900 Bogas, Robert, of Cranbrook, Kent, clothmaker 1
5466483 2494912 2494912 defendant Doule John butcher 603900 603900 Doule, John, of Cranbrook, Kent, butcher 0
5466485 2494913 2494913 defendant Doule John butcher 603900 603900 Doule, John, of Cranbrook, Kent, butcher 0
5475643 2497711 2497711 defendant Bogas Robert clothmaker 603900 603900 Bogas, Robert, of Cranbrook, Kent, clothmaker 1
5475973 2497824 2497824 defendant Dole John butcher 603900 603900 Dole, John, of Cranbrook, Kent, butcher 1
5475979 2497826 2497826 defendant Hert John butcher 603900 603900 Hert, John, of Cranbrook, Kent, butcher 0
5476716 2498034 2498034 defendant Bettenham William gent 603900 603900 Bettenham, William, of Cranbrook, Kent, gent 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);