names

31 rows where place_id = 631561

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3801352 1958350 1958350 defendant Russell William bowyer 631561 631561 Russell, William, of Birmyngeham, bowyer 1
4447141 2184012 2184012 defendant Lutterworth Thomas de draper 631561 631561 Lutterworth, Thomas de, of Birmyngeham, draper 2
4591252 2228622 2228622 defendant Holdon John   631561 631561 Holdon, John, of Birmyngeham, son of Thomas 1
4722845 2272459 2272459 defendant Couper John cooper 631561 631561 Couper, John, of Birmyngeham, cooper 0
4728886 2274273 2274273 defendant Seler John mercer 631561 631561 Seler, John, of Birmyngeham, mercer 0
4779911 2289717 2289717 defendant Bowyer John bowyer 631561 631561 Bowyer, John, of Birmyngeham, bowyer 1
4782368 2290488 2290488 defendant Acton John husbandman 631561 631561 Acton, John, of Birmyngeham, husbandman 0
4793193 2293968 2293968 defendant Cutte Robert baker 631561 631561 Cutte, Robert, of Birmyngeham, baker 0
4944163 2340145 2340145 defendant Osteler Richard drover 631561 631561 Osteler, Richard, of Birmyngeham, drover 0
4971312 2348354 2348354 defendant Blake John butcher 631561 631561 Blake, John, of Birmyngeham, butcher 1
4971313 2348354 2348354 defendant Bromley Richard butcher 631561 631561 Bromley, Richard, of Birmyngeham, butcher 2
4971314 2348354 2348354 defendant Lenche Richard drover 631561 631561 Lenche, Richard, of Birmyngeham, drover 3
4971315 2348354 2348354 defendant Lenche William drover 631561 631561 Lenche, William, of Birmyngeham, drover 4
5023996 2363929 2363929 defendant Harryes Henry drover 631561 631561 Harryes, Henry, of Birmyngeham, drover 0
5036623 2367579 2367579 defendant Bowyer John bowyer 631561 631561 Bowyer, John, of Birmyngeham, bowyer 2
5036624 2367579 2367579 defendant Gest William lormier 631561 631561 Gest, William, of Birmyngeham, lormier 3
5036625 2367579 2367579 defendant Waterfall Roger butcher 631561 631561 Waterfall, Roger, of Birmyngeham, butcher 4
5036629 2367580 2367580 defendant Bowyer John bowyer 631561 631561 Bowyer, John, of Birmyngeham, bowyer 2
5036630 2367580 2367580 defendant Gest William lorimer 631561 631561 Gest, William, of Birmyngeham, lorimer 3
5036631 2367580 2367580 defendant Waterfall or Watersall Roger butcher 631561 631561 Waterfall or Watersall, Roger, of Birmyngeham, butcher 4
5102925 2387277 2387277 defendant Philips William husbandman 631561 631561 Philips, William, of Birmyngeham, husbandman 0
5267288 2435532 2435532 defendant Bauderike Thomas yeoman 631561 631561 Bauderike, Thomas, of Birmyngeham, yeoman 0
5267289 2435532 2435532 defendant Peteman John husbandman 631561 631561 Peteman, John, of Birmyngeham, husbandman 1
5267290 2435532 2435532 defendant Bradeley John husbandman 631561 631561 Bradeley, John, of Birmyngeham, husbandman 2
5283759 2440293 2440293 defendant Phelippes William yeoman 631561 631561 Phelippes, William, of Birmyngeham, yeoman 0
5340452 2457214 2457214 defendant Symondes John yeoman 631561 631561 Symondes, John, of Birmyngeham, yeoman 0
5361933 2463758 2463758 defendant Snowedon John yeoman 631561 631561 Snowedon, John, of Birmyngeham, yeoman 3
5519650 2510979 2510979 defendant Bird Roger grasier 631561 631561 Bird, Roger, of Birmyngeham, grasier 1
5519651 2510979 2510979 defendant Couper John butcher 631561 631561 Couper, John, of Birmyngeham, butcher 2
5535424 2515607 2515607 defendant Lloid alias Fleyte Richard (legal representative) 631561 631561 Lloid alias Fleyte, Richard, of Birmyngeham, administratrix of 0
5535425 2515607 2515607 defendant Lloid Mary widow 631561 631561 Lloid, Mary, of Birmyngeham, widow 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);