names

42 rows where place_id = 590644

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601872 1868239 1868239 defendant Halsnoth Walter husbandman 590644 590644 Halsnoth, Walter, of Frethynden, husbandman 0
3620803 1874076 1874076 defendant Halsnothe Walter husbandman 590644 590644 Halsnothe, Walter, of Frethynden, husbandman 1
4702790 2266272 2266272 defendant Jolyf John latcher or latch maker 590644 590644 Jolyf, John, of Frethynden, latcher or latch maker 0
4764074 2284752 2284752 defendant Jolyf John   590644 590644 Jolyf, John, of Frethynden, lathe worker 0
5159191 2403803 2403803 defendant Hoigge Stephen gent 590644 590644 Hoigge, Stephen, of Frethynden, gent 0
5199494 2415599 2415599 defendant Colyar John husbandman 590644 590644 Colyar, John, of Frethynden, husbandman 0
5207602 2417963 2417963 defendant Colier John husbandman 590644 590644 Colier, John, of Frethynden, husbandman 0
5209039 2418375 2418375 defendant Paytewyn John carpenter 590644 590644 Paytewyn, John, of Frethynden, carpenter 3
5211128 2418982 2418982 defendant Colyar John husbandman 590644 590644 Colyar, John, of Frethynden, husbandman 0
5211129 2418982 2418982 defendant Colyar Thomasine widow 590644 590644 Colyar, Thomasine, of Frethynden, widow 1
5230030 2424396 2424396 defendant Paytewyn William carpenter 590644 590644 Paytewyn, William, of Frethynden, carpenter 1
5242580 2428036 2428036 defendant Baker John husbandman 590644 590644 Baker, John, of Frethynden, husbandman 1
5255231 2431751 2431751 defendant Wygan Henry yeoman 590644 590644 Wygan, Henry, of Frethynden, yeoman 0
5255232 2431751 2431751 defendant Tottenham John husbandman 590644 590644 Tottenham, John, of Frethynden, husbandman 1
5259295 2433025 2433025 defendant Miller Robert clerk 590644 590644 Miller, Robert, of Frethynden, clerk 0
5259296 2433025 2433025 defendant Totynham John husbandman 590644 590644 Totynham, John, of Frethynden, husbandman 1
5259298 2433025 2433025 defendant Horn Stephen husbandman 590644 590644 Horn, Stephen, of Frethynden, husbandman 3
5271816 2436852 2436852 defendant (illegible) Robert   590644 590644 ----, Robert, of Frethynden, parson 0
5271817 2436852 2436852 defendant Tyler John   590644 590644 Tyler, John, of Frethynden, parish clerk 1
5286202 2440974 2440974 defendant Tyler John   590644 590644 Tyler, John, of Frethynden, parish clerk 1
5293105 2442968 2442968 defendant Miller Robert clerk 590644 590644 Miller, Robert, of Frethynden, clerk 0
5293122 2442971 2442971 defendant Miller Robert clerk 590644 590644 Miller, Robert, of Frethynden, clerk 0
5348446 2459654 2459654 defendant Gulbregge Thomas butcher 590644 590644 Gulbregge, Thomas, of Frethynden, butcher 1
5351686 2460627 2460627 plaintiff Dogette William   590644 590644 Dogette, William, of Frethynden 0
5356098 2461985 2461985 defendant Hoigges Stephen gent 590644 590644 Hoigges, Stephen, of Frethynden, gent 0
5399487 2474932 2474932 defendant Tomelyn Peter (legal representative) 590644 590644 Tomelyn, Peter, of Frethynden, husbandman, executrix of 1
5399488 2474932 2474932 defendant Tomelyn Agnes widow 590644 590644 Tomelyn, Agnes, of Frethynden, widow 2
5412485 2478680 2478680 defendant Tomelyn Peter (legal representative) 590644 590644 Tomelyn, Peter, of Frethynden, husbandman, executrix of 1
5412486 2478680 2478680 defendant Tomelyn Agnes widow 590644 590644 Tomelyn, Agnes, of Frethynden, widow 2
5427287 2483106 2483106 defendant Thomelyn Peter (legal representative) 590644 590644 Thomelyn, Peter, of Frethynden, husbandman, executors of 0
5427289 2483106 2483106 defendant Thomelyn Agnes widow 590644 590644 Thomelyn, Agnes, of Frethynden, widow 2
5427293 2483107 2483107 defendant Thomelyn Agnes widow 590644 590644 Thomelyn, Agnes, of Frethynden, widow 2
5427296 2483108 2483108 defendant Tomelyn Agnes widow 590644 590644 (Tomelyn, Agnes, of Frethynden, widow 1
5442044 2487542 2487542 defendant Gubbregge Thomas butcher 590644 590644 Gubbregge, Thomas, of Frethynden, butcher 2
5445115 2488426 2488426 defendant Tomlyn Agnes widow 590644 590644 together with Tomlyn, Agnes, of Frethynden, widow 2
5480933 2499251 2499251 defendant Tomlyn Peter (legal representative) 590644 590644 Tomlyn, Peter, of Frethynden, husbandman, executors of 0
5480935 2499251 2499251 defendant Tomlyn Agnes widow 590644 590644 Tomlyn, Agnes, of Frethynden, widow 2
5482226 2499625 2499625 defendant Gulbregge Thomas butcher 590644 590644 Gulbregge, Thomas, of Frethynden, butcher 9
5507068 2507119 2507119 defendant Gulbregge Thomas butcher 590644 590644 Gulbregge, Thomas, of Frethynden, butcher 1
5546184 2518875 2518875 defendant A Berowe Stephen husbandman 590644 590644 A Berowe, Stephen, of Frethynden, husbandman 0
5577087 2527882 2527882 defendant Tournor Thomas shoemaker 590644 590644 Tournor, Thomas, of Frethynden, shoemaker 0
5582850 2529703 2529703 defendant Vyne John husbandman 590644 590644 Vyne, John, of Frethynden, husbandman 3

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);