names

60 rows where place_id = 617565

✎ 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
3720162 1932582 1932582 defendant Whall Thomas husbandman 617565 617565 Whall, Thomas, of Erpyngham, husbandman 4
3728911 1935290 1935290 defendant Hall Thomas husbandman 617565 617565 Hall, Thomas, of Erpyngham, husbandman 0
3735867 1937455 1937455 defendant Baly Thomas turner 617565 617565 Baly, Thomas, of Erpyngham, turner 1
3750021 1941922 1941922 defendant Awdeney John husnadman 617565 617565 Awdeney, John, of Erpyngham, husnadman 4
3782079 1952149 1952149 defendant Baly Thomas husbandman 617565 617565 Baly, Thomas, of Erpyngham, husbandman 2
3783293 1952526 1952526 defendant Audeney John husbandman 617565 617565 Audeney, John, of Erpyngham, husbandman 3
3804472 1959339 1959339 defendant Bayly Thomas husbandman 617565 617565 Bayly, Thomas, of Erpyngham, husbandman 1
3817226 1963304 1963304 defendant Audeney John husbandman 617565 617565 Audeney, John, of Erpyngham, husbandman 0
3820331 1964235 1964235 defendant Bayly Thomas turner 617565 617565 Bayly, Thomas, of Erpyngham, turner 0
3821937 1964754 1964754 defendant Kydman Thomas husbandman 617565 617565 Kydman, Thomas, of Erpyngham, husbandman 2
3821938 1964754 1964754 defendant Sawer William husbandman 617565 617565 Sawer, William, of Erpyngham, husbandman 3
3861577 1977333 1977333 plaintiff Freman John (legal representative) 617565 617565 Freman, John, of Erpyngham, executors of 0
3867204 1979267 1979267 defendant Bayly Thomas turner 617565 617565 Bayly, Thomas, of Erpyngham, turner 0
3886976 1985907 1985907 plaintiff Clare John (legal representative) 617565 617565 Clare, John, of Erpyngham, executor of 0
3986901 2020057 2020057 defendant Embberd or Guibberd Richard yeoman 617565 617565 Embberd or Guibberd, Richard, of Erpyngham, yeoman 0
3986903 2020058 2020058 defendant Gubberd Richard yeoman 617565 617565 Gubberd, Richard, of Erpyngham, yeoman 0
3986905 2020059 2020059 defendant Gubberd Richard yeoman 617565 617565 Gubberd, Richard, of Erpyngham, yeoman 0
4148266 2077524 2077524 defendant Wegger John husbandman 617565 617565 Wegger, John, of Erpyngham, husbandman 2
4208721 2098600 2098600 defendant Watson John clerk 617565 617565 Watson, John, of Erpyngham, clerk 0
4258398 2115776 2115776 defendant Brodbancke Thomas yeoman 617565 617565 Brodbancke, Thomas, of Erpyngham, yeoman 1
4385192 2159737 2159737 defendant Mendham Thomas yeoman 617565 617565 Mendham, Thomas, of Erpyngham, yeoman 1
4457407 2187329 2187329 plaintiff Peres Nicholas   617565 617565 Peres, Nicholas, of Erpyngham 0
4556649 2218012 2218012 defendant Sybbely John   617565 617565 Sybbely, John, of Erpyngham 0
4564148 2220358 2220358 defendant Wylde Stephen   617565 617565 Wylde, Stephen, of Erpyngham 3
4677579 2258601 2258601 defendant Braklee Richard yeoman 617565 617565 Braklee, Richard, of Erpyngham, yeoman 2
4748879 2280162 2280162 defendant Howe John yeoman 617565 617565 Howe, John, of Erpyngham, yeoman 2
4810457 2299417 2299417 plaintiff Spencer Tobert   617565 617565 Spencer, Tobert, of Erpyngham, parson 4
4937351 2338049 2338049 defendant Bathe Alice widow 617565 617565 Bathe, Alice, of Erpyngham, widow 0
4944443 2340242 2340242 defendant Drury John husbandman 617565 617565 Drury, John, of Erpyngham, husbandman 0
4944444 2340242 2340242 defendant Miller William husbandman 617565 617565 Miller, William, of Erpyngham, husbandman 1
4944445 2340242 2340242 defendant Bene William husbandman 617565 617565 Bene, William, of Erpyngham, husbandman 2
4944446 2340242 2340242 defendant Brakle William laborer 617565 617565 Brakle, William, of Erpyngham, laborer 3
4958808 2344608 2344608 defendant Heylot William husbandman 617565 617565 Heylot, William, of Erpyngham, husbandman 0
5022221 2363392 2363392 defendant Boole William butcher 617565 617565 Boole, William, of Erpyngham, butcher 2
5033706 2366735 2366735 defendant Heylot William husbandman 617565 617565 Heylot, William, of Erpyngham, husbandman 4
5034376 2366914 2366914 plaintiff Wyld Thomas   617565 617565 Wyld, Thomas, of Erpyngham 1
5037645 2367884 2367884 defendant Bettys Henry chaplain 617565 617565 Bettys, Henry, of Erpyngham, chaplain 1
5051925 2372190 2372190 plaintiff Wylde Thomas   617565 617565 Wylde, Thomas, of Erpyngham 0
5059040 2374268 2374268 defendant Wattys Robert laborer 617565 617565 Wattys, Robert, of Erpyngham, laborer 1
5100138 2386480 2386480 plaintiff Wylde Thomas   617565 617565 Wylde, Thomas, of Erpyngham 0
5100141 2386481 2386481 plaintiff Wylde Thomas   617565 617565 Wylde, Thomas, of Erpyngham 0
5126105 2394117 2394117 defendant Elys Richard laborer 617565 617565 Elys, Richard, of Erpyngham, laborer 4
5146356 2400067 2400067 defendant Elyn Richard laborer 617565 617565 Elyn, Richard, of Erpyngham, laborer 2
5254937 2431657 2431657 plaintiff Cheverey Thomas   617565 617565 Cheverey, Thomas, of Erpyngham 0
5263837 2434446 2434446 defendant Towtyng William husbandman 617565 617565 Towtyng, William, of Erpyngham, husbandman 0
5319875 2451031 2451031 defendant Kyttes Robert husbandman 617565 617565 Kyttes, Robert, of Erpyngham, husbandman 1
5323520 2452116 2452116 defendant Whall Thomas husbandman 617565 617565 Whall, Thomas, of Erpyngham, husbandman 0
5337095 2456172 2456172 defendant Qualle Thomas yeoman 617565 617565 Qualle, Thomas, of Erpyngham, yeoman 1
5345433 2458745 2458745 defendant Mendham John husbandman 617565 617565 Mendham, John, of Erpyngham, husbandman 0
5355872 2461912 2461912 plaintiff Kyttys Robert   617565 617565 Kyttys, Robert, of Erpyngham 0
5384762 2470725 2470725 defendant Whall Thomas husbandman 617565 617565 Whall, Thomas, of Erpyngham, husbandman 7
5386845 2471303 2471303 defendant Whalle Thomas husbandman 617565 617565 Whalle, Thomas, of Erpyngham, husbandman 3
5396779 2474170 2474170 defendant Whall Thomas   617565 617565 Whall, Thomas, of Erpyngham 7
5399285 2474869 2474869 defendant Whalle Thomas husbandman 617565 617565 Whalle, Thomas, of Erpyngham, husbandman 3
5426766 2482947 2482947 defendant Whall Thomas husbandman 617565 617565 Whall, Thomas, of Erpyngham, husbandman 10
5427686 2483238 2483238 defendant Whall Thomas husbandman 617565 617565 Whall, Thomas, of Erpyngham, husbandman 0
5427690 2483239 2483239 defendant Whall Thomas husbandman 617565 617565 Whall, Thomas, of Erpyngham, husbandman 0
5482070 2499569 2499569 defendant Ballard Robert laborer 617565 617565 Ballard, Robert, of Erpyngham, laborer 0
5485009 2500436 2500436 defendant Qwalle Thomas husbandman 617565 617565 Qwalle, Thomas, of Erpyngham, husbandman 1
5494959 2503390 2503390 defendant Ballard Robert laborer 617565 617565 Ballard, Robert, of Erpyngham, laborer 2

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