names

22 rows where place_id = 613050

✎ 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
3659672 1913281 1913281 defendant Wonam William husbandman 613050 613050 Wonam, William, of East Becheworth, husbandman 0
3659674 1913282 1913282 defendant Wonan William husbandman 613050 613050 Wonan, William, of East Becheworth, husbandman 0
3696356 1925081 1925081 defendant Woman William yeoman 613050 613050 Woman, William, of Est Becheworth, yeoman 0
3713706 1930583 1930583 defendant Rogers Thomas yeoman 613050 613050 Rogers, Thomas, of Est Becheworth, yeoman 1
3871941 1980848 1980848 defendant Humfrey William carpenter 613050 613050 Humfrey, William, of Est Becheworth, carpenter 3
3900042 1990235 1990235 defendant Wheler Thomas, senior yeoman 613050 613050 Wheler, Thomas, senior, of Est Becheworth, yeoman 0
3900043 1990235 1990235 defendant Wheler Thomas, junior laborer 613050 613050 Wheler, Thomas, junior, of Est Becheworth, laborer 1
3963371 2011793 2011793 defendant Humfrey William carpenter 613050 613050 Humfrey, William, of Est Becheworth, carpenter 0
3963373 2011793 2011793 defendant Parker Nicholas husbandman 613050 613050 together with Parker, Nicholas, of Est Becheworth, husbandman 2
4692452 2263157 2263157 defendant Brokham Thomas husbandman 613050 613050 Brokham, Thomas, of East Becheworth, husbandman 1
4775956 2288482 2288482 defendant Colyn John   613050 613050 Colyn, John, of East Becheworth, wheel wright 1
5084152 2381765 2381765 defendant Donmowe John husbandman 613050 613050 Donmowe, John, of Est Becheworth, husbandman 0
5084156 2381766 2381766 defendant Donmowe John husbandman 613050 613050 Donmowe, John, of Est Becheworth, husbandman 0
5299682 2444877 2444877 defendant Wysedam Richard husbandman 613050 613050 Wysedam, Richard, of East Becheworth, husbandman 0
5299683 2444877 2444877 defendant Saker John husbandman 613050 613050 Saker, John, of East Becheworth, husbandman 1
5299684 2444877 2444877 defendant Botiller William husbandman 613050 613050 Botiller, William, of East Becheworth, husbandman 2
5347184 2459280 2459280 defendant Vysedam Richard husbandman 613050 613050 Vysedam, Richard, of Est Becheworth, husbandman 0
5539042 2516694 2516694 defendant Saker Richard, senior husbandman 613050 613050 Saker, Richard, senior, of Est Becheworth, husbandman 0
5539043 2516694 2516694 defendant Saker Richard, junior pulter 613050 613050 Saker, Richard, junior, of Est Becheworth, pulter 1
5539044 2516694 2516694 defendant Saker Robert laborer 613050 613050 Saker, Robert, of Est Becheworth, laborer 2
5539045 2516694 2516694 defendant Blake John pulter 613050 613050 Blake, John, of Est Becheworth, pulter 3
5603363 2535940 2535940 defendant Wheler Robert husbandman 613050 613050 Wheler, Robert, of Est Becheworth, husbandman 4

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