names

43 rows where place_id = 605757

✎ 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
3662789 1914281 1914281 defendant Barne Ralph innholder 605757 605757 Barne, Ralph, of Brandon Ferry, Suff, innholder 0
3854212 1974955 1974955 plaintiff Talbott Lewis gent 605757 605757 Talbott, Lewis, of Brandon Ferry, Suff, gent 0
3929393 2000176 2000176 defendant Shakloke Giles mercer 605757 605757 Shakloke, Giles, of Brandon Ferry, Suff, mercer 3
3931958 2000987 2000987 defendant Atmore John yeoman 605757 605757 Atmore, John, of Brandon Ferry, Suff, yeoman 0
3961810 2011231 2011231 defendant Stragett Thomas yeoman 605757 605757 Stragett, Thomas, of Brandon Ferry, Suff, Suff, yeoman 3
4173538 2086200 2086200 defendant Shipley John yeoman 605757 605757 Shipley, John, of Brandon Ferry, Suff, yeoman 0
4180811 2088766 2088766 defendant Senys John clerk 605757 605757 Senys, John, of Brandon Ferry, Suff, clerk 1
4229591 2105835 2105835 defendant Canham John yeoman 605757 605757 Canham, John, of Brandon Ferry, Suff, yeoman 0
4229595 2105836 2105836 defendant Canham John yeoman 605757 605757 together with Canham, John, of Brandon Ferry, Suff, yeoman 1
4275043 2121224 2121224 defendant Tylbroke or Tylbroke Nicholas yeoman or "parytor" 605757 605757 Tylbroke or Tylbroke, Nicholas, of Brandon Ferry, Suff, yeoman or "parytor" 0
4284017 2124327 2124327 defendant Moulde John yeoman 605757 605757 Moulde, John, of Brandon Ferry, Suff, yeoman 0
4290495 2126660 2126660 defendant Bruyster John yeoman 605757 605757 Bruyster, John, of Brandon Ferry, Suff, yeoman 0
4327670 2139575 2139575 defendant Canham John yeoman 605757 605757 Canham, John, of Brandon Ferry, Suff, yeoman 1
4751726 2280992 2280992 defendant Bocher William yeoman 605757 605757 Bocher, William, of Brandon Ferry, Suff, yeoman 0
4776016 2288497 2288497 defendant Kirton Thomas yeoman 605757 605757 Kirton, Thomas, of Brandon Ferry, Suff, yeoman 3
4809466 2299135 2299135 defendant Gebtum John yeoman 605757 605757 Gebtum, John, of Brandon Ferry, Suff, yeoman 4
4913295 2330658 2330658 defendant Thomson Alexander husbandman 605757 605757 Thomson, Alexander, of Brandon Ferry, Suff, husbandman 2
4995360 2355455 2355455 defendant Chaundeler Richard yeoman 605757 605757 Chaundeler, Richard, of Brandon Ferry, Suff, yeoman 1
5008352 2359332 2359332 defendant Thomson Alexancer husbandman 605757 605757 Thomson, Alexancer, of Brandon Ferry, Suff, husbandman 0
5047711 2370932 2370932 defendant Chaundeler Richard ostler 605757 605757 with Chaundeler, Richard, of Brandon Ferry, Suff, ostler 2
5091952 2384025 2384025 defendant Whetley Roger ostler 605757 605757 Whetley, Roger, of Brandon Ferry, Suff, ostler 1
5091957 2384026 2384026 defendant Wheteley Roger ostler 605757 605757 Wheteley, Roger, of Brandon Ferry, Suff, ostler 1
5126268 2394167 2394167 defendant Barnam John chapman 605757 605757 Barnam, John, of Brandon Ferry, Suff, chapman 0
5137131 2397373 2397373 plaintiff Peper John yeoman 605757 605757 Peper, John, of Brandon Ferry, Suff, yeoman 0
5193459 2413815 2413815 defendant Pepir John, sen husbandman 605757 605757 Pepir, John, sen, of Brandon Ferry, Suff, husbandman 0
5268276 2435843 2435843 defendant Bonyfaunt Edmund water man 605757 605757 Bonyfaunt, Edmund, of Brandon Ferry, Suff, water man 1
5276256 2438123 2438123 defendant Swarston Thomas yeoman 605757 605757 Swarston, Thomas, of Brandon Ferry, Suff, yeoman 2
5276262 2438125 2438125 defendant Botyvaunt Edmund yeoman 605757 605757 Botyvaunt, Edmund, of Brandon Ferry, Suff, yeoman 2
5366664 2465226 2465226 defendant Leeme William husbandman 605757 605757 Leeme, William, of Brandon Ferry, Suff, husbandman 0
5367721 2465533 2465533 plaintiff George Roger   605757 605757 George, Roger, of Brandon Ferry, Suff 1
5384814 2470732 2470732 defendant Swarston Alexander shoemaker 605757 605757 Swarston, Alexander, of Brandon Ferry, Suff, shoemaker 1
5386980 2471342 2471342 defendant George Roger yeoman 605757 605757 George, Roger, of Brandon Ferry, Suff, yeoman 1
5399344 2474886 2474886 defendant George Roger yeoman 605757 605757 George, Roger, of Brandon Ferry, Suff, yeoman 0
5411185 2478304 2478304 defendant Barnard John skinner 605757 605757 Barnard, John, of Brandon Ferry, Suff, skinner 0
5420111 2480932 2480932 plaintiff George Roger   605757 605757 George, Roger, of Brandon Ferry, Suff 1
5421648 2481411 2481411 defendant Swarston Thomas husbandman 605757 605757 Swarston, Thomas, of Brandon Ferry, Suff, husbandman 2
5425363 2482559 2482559 defendant Bernard John skinner 605757 605757 Bernard, John, of Brandon Ferry, Suff, skinner 0
5441530 2487388 2487388 defendant Swerston Thomas husbandman 605757 605757 Swerston, Thomas, of Brandon Ferry, Suff, husbandman 2
5443886 2488089 2488089 defendant Bernard John skinner 605757 605757 Bernard, John, of Brandon Ferry, Suff, skinner 0
5454315 2491199 2491199 defendant Swarston Thomas husbandman 605757 605757 Swarston, Thomas, of Brandon Ferry, Suff, husbandman 2
5466215 2494833 2494833 defendant Swarston Thomas husbandman 605757 605757 Swarston, Thomas, of Brandon Ferry, Suff, husbandman 1
5469702 2495864 2495864 defendant George Robert warrener 605757 605757 George, Robert, of Brandon Ferry, Suff, warrener 0
5475677 2497718 2497718 defendant Talaunt Hugh yeoman 605757 605757 Talaunt, Hugh, of Brandon Ferry, Suff, yeoman 1

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