names

28 rows where place_id = 653669

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3657258 1912531 1912531 defendant Garland John   653669 653669 Garland, John, of Dorchester, Dors, inn holder 0
3929375 2000170 2000170 defendant Wolfe Mathew merchant 653669 653669 Wolfe, Mathew, of Dorchester, Dors, merchant 1
3930711 2000622 2000622 defendant Wolfe Mathew chapman 653669 653669 Wolfe, Mathew, of Dorchester, Dors, chapman 0
3938417 2003193 2003193 defendant Stone William, junior   653669 653669 Stone, William, junior, of Dorchester, Dors 1
3938422 2003194 2003194 defendant Stone William, junior yeoman 653669 653669 Stone, William, junior, of Dorchester, Dors, yeoman 1
4516230 2205484 2205484 defendant Cranoll Henry   653669 653669 Cranoll, Henry, of Dorchester, Dors 1
4667962 2255684 2255684 defendant Patrych Thomas barber 653669 653669 Patrych, Thomas, of Dorchester, Dors, barber 0
4682751 2260223 2260223 defendant Walshe John yeoman 653669 653669 Walshe, John, of Dorchester, Dors, yeoman 2
4806250 2298163 2298163 defendant Lambard William yeoman 653669 653669 Lambard, William, of Dorchester, Dors, yeoman 0
4925245 2334326 2334326 defendant Cosyn Richard merchant 653669 653669 Cosyn, Richard, of Dorchester, Dors, merchant 0
5139857 2398133 2398133 defendant Wotton William clerk 653669 653669 Wotton, William, of Dorchester, Dors, clerk 0
5276958 2438341 2438341 defendant Baton Robert ostler 653669 653669 Baton, Robert, of Dorchester, Dors, ostler 0
5384486 2470647 2470647 defendant Revell William tailor 653669 653669 Revell, William, of Dorchester, Dors, tailor 0
5396340 2474045 2474045 defendant Revell or Renell William tailor 653669 653669 Revell or Renell, William, of Dorchester, Dors, tailor 0
5408876 2477614 2477614 defendant Lede Thomas mercer 653669 653669 Lede, Thomas, of Dorchester, Dors, mercer 2
5409646 2477855 2477855 defendant Revell William tailor 653669 653669 Revell, William, of Dorchester, Dors, tailor 0
5420089 2480926 2480926 defendant Sadeler Alexander sadler 653669 653669 Sadeler, Alexander, of Dorchester, Dors, sadler 0
5422217 2481593 2481593 defendant Lede Thomas mercer 653669 653669 Lede, Thomas, of Dorchester, Dors, mercer 2
5422223 2481594 2481594 defendant Lede Thomas mercer 653669 653669 Lede, Thomas, of Dorchester, Dors, mercer 2
5423221 2481908 2481908 defendant Revell William tailor 653669 653669 Revell, William, of Dorchester, Dors, tailor 0
5423272 2481923 2481923 defendant Asshe Robert vintner 653669 653669 Asshe, Robert, of Dorchester, Dors, vintner 3
5429836 2483866 2483866 defendant Kene John dyer 653669 653669 Kene, John, of Dorchester, Dors, dyer 0
5434039 2485132 2485132 defendant Golde Andrew yeoman 653669 653669 Golde, Andrew, of Dorchester, Dors, yeoman 1
5438815 2486529 2486529 defendant Sadeler Alexander sadler 653669 653669 Sadeler, Alexander, of Dorchester, Dors, sadler 0
5449550 2489753 2489753 defendant Golde Andrew yeoman 653669 653669 Golde, Andrew, of Dorchester, Dors, yeoman 1
5461690 2493435 2493435 defendant Golde Andrew yeoman 653669 653669 Golde, Andrew, of Dorchester, Dors, yeoman 1
5464695 2494353 2494353 defendant Sadeler Alexander sadler 653669 653669 Sadeler, Alexander, of Dorchester, Dors, sadler 0
5472038 2496595 2496595 defendant Kene John dyer 653669 653669 Kene, John, of Dorchester, Dors, dyer 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);