names

29 rows where place_id = 589220

✎ 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
3596934 1866673 1866673 defendant Tebold Stephen husbandman 589220 589220 Tebold, Stephen, of Chalk, husbandman 0
3597487 1866834 1866834 defendant Cryp John husbandman 589220 589220 Cryp, John, of Chalk, husbandman 2
3617667 1873151 1873151 defendant Gyrdeler John smith 589220 589220 Gyrdeler, John, of Chalk, smith 0
3633195 1905196 1905196 defendant Martyn Thomas husbandman 589220 589220 Martyn, Thomas, of Chalk, husbandman 1
3658911 1913047 1913047 defendant Chamber Richard husbandman 589220 589220 Chamber, Richard, of Chalk, husbandman 0
3818330 1963637 1963637 defendant Hervytt William husbandman 589220 589220 Hervytt, William, of Chalk, husbandman 4
3830634 1967464 1967464 defendant Paynter alias Sayer William laborer 589220 589220 Paynter alias Sayer, William, of Chalk, laborer 0
3919449 1996838 1996838 plaintiff Launder Walter husbandman 589220 589220 Launder, Walter, of Chalk, husbandman 0
3923621 1998210 1998210 defendant Brudge George husbandman 589220 589220 Brudge, George, of Chalk, husbandman 3
4562270 2219770 2219770 defendant Rolf Roger   589220 589220 Rolf, Roger, of Chalk 0
4865519 2316179 2316179 defendant Fluk John yeoman 589220 589220 Fluk, John, of Chalk, yeoman 1
4923270 2333699 2333699 defendant Pope Robert husbandman 589220 589220 Pope, Robert, of Chalk, husbandman 0
4941594 2339390 2339390 defendant Pole John gent 589220 589220 Pole, John, of Chalk, gent 4
4949702 2341901 2341901 plaintiff Noreys Richard   589220 589220 Noreys, Richard, of Chalk 0
4949705 2341902 2341902 plaintiff Noreys Richard   589220 589220 Noreys, Richard, of Chalk 0
4953809 2343099 2343099 defendant Martyn John yeoman 589220 589220 Martyn, John, of Chalk, yeoman 0
4976077 2349806 2349806 defendant Martyn John husbandman 589220 589220 Martyn, John, of Chalk, husbandman 0
4990968 2354188 2354188 defendant Martyn John husbandman 589220 589220 Martyn, John, of Chalk, husbandman 0
4999452 2356706 2356706 defendant Martyn John husbandman 589220 589220 Martyn, John, of Chalk, husbandman 0
5132537 2396010 2396010 defendant Martyn Richard husbandman 589220 589220 Martyn, Richard, of Chalk, husbandman 0
5141160 2398536 2398536 defendant Tayllour Thomas husbandman 589220 589220 Tayllour, Thomas, of Chalk, husbandman 4
5152337 2401815 2401815 defendant Martyn Richard husbandman 589220 589220 Martyn, Richard, of Chalk, husbandman 0
5222299 2422229 2422229 plaintiff Martyn Richard, junior   589220 589220 Martyn, Richard, junior, of Chalk 0
5449768 2489821 2489821 defendant Grygge Thomas husbandman 589220 589220 Grygge, Thomas, of Chalk, husbandman 2
5488195 2501367 2501367 defendant Pokyll William husbandman 589220 589220 Pokyll, William, of Chalk, husbandman 0
5488196 2501367 2501367 defendant Tybold Stephen husbandman 589220 589220 Tybold, Stephen, of Chalk, husbandman 1
5530599 2514085 2514085 defendant Aleyn Richard yeoman 589220 589220 Aleyn, Richard, of Chalk, yeoman 2
5553703 2521118 2521118 defendant Alen Richard yeoman 589220 589220 Alen, Richard, of Chalk, yeoman 2
5625793 2552012 2552012 plaintiff Martyn William   589220 589220 Martyn, William, of Chalk 0

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