names

24 rows where place_id = 641209

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3860109 1976878 1976878 defendant Dethyke John gent 641209 641209 Dethyke, John, of Bychamwell, gent 2
3862260 1977563 1977563 defendant Clement Anthony husbandman 641209 641209 Clement, Anthony, of Bychamwell, husbandman 0
3866939 1979181 1979181 defendant Clement Anthony husbandman 641209 641209 Clement, Anthony, of Bychamwell, husbandman 0
3868873 1979831 1979831 defendant Dedyke alias Bedyke John gent 641209 641209 Dedyke alias Bedyke, John, of Bychamwell, gent 0
3882646 1984462 1984462 defendant Dedyke John gent 641209 641209 Dedyke, John, of Bychamwell, gent 0
3975390 2015958 2015958 defendant Croft Edward clerk 641209 641209 Croft, Edward, of Bychamwell, clerk 0
4409583 2167803 2167803 defendant Downes Richard clerk 641209 641209 Downes, Richard, of Bychamwell, clerk 0
4426220 2173005 2173005 plaintiff Nichole Agnes   641209 641209 Nichole, Agnes, of Bychamwell, formerly wife of John 0
4697752 2264790 2264790 defendant Wautowene Peter butcher 641209 641209 Wautowene, Peter, of Bychamwell, butcher 2
4893556 2324686 2324686 defendant Mason Ralph husbandman 641209 641209 Mason, Ralph, of Bychamwell, husbandman 3
4893557 2324686 2324686 defendant Toke William husbandman 641209 641209 Toke, William, of Bychamwell, husbandman 4
4916479 2331658 2331658 defendant Walsham Thomas gent 641209 641209 Walsham, Thomas, of Bychamwell, gent 0
4955481 2343601 2343601 defendant Langwade Robert clerk 641209 641209 (Langwade, Robert, of Bychamwell, clerk 4
5016605 2361750 2361750 defendant Tw or Tew Simon chaplain 641209 641209 Tw or Tew, Simon, of Bychamwell, chaplain 0
5025290 2364290 2364290 defendant Cosyn Simon clerk 641209 641209 Cosyn, Simon, of Bychamwell, clerk 0
5025295 2364291 2364291 defendant Cosyn Simon clerk 641209 641209 Cosyn, Simon, of Bychamwell, clerk 0
5241569 2427734 2427734 defendant Toke Robert husbandman 641209 641209 Toke, Robert, of Bychamwell, husbandman 0
5257140 2432367 2432367 defendant Toke William yeoman 641209 641209 Toke, William, of Bychamwell, yeoman 0
5257141 2432367 2432367 defendant Barker Margaret widow 641209 641209 Barker, Margaret, of Bychamwell, widow 1
5356408 2462072 2462072 defendant Langwade Robert husbandman 641209 641209 Langwade, Robert, of Bychamwell, husbandman 0
5379373 2469140 2469140 defendant Hermer William (legal representative) 641209 641209 Hermer, William, of Bychamwell, gent, administratrix of 4
5379374 2469140 2469140 defendant Hermer Katherine widow 641209 641209 Hermer, Katherine, of Bychamwell, widow 5
5636623 2555398 2555398 defendant Monke Thomas butcher 641209 641209 Monke, Thomas, of Bychamwell, butcher 2
5636923 2555492 2555492 defendant Monke Thomas butcher 641209 641209 Monke, Thomas, of Bychamwell, butcher 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);