names

29 rows where place_id = 777864

✎ 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
4650279 2246101 2246101 defendant Pette John   777864 777864 Pette, John, of Milton by Gravesend 4
4691599 2262900 2262900 defendant Pette John husbandman 777864 777864 Pette, John, of Milton by Gravesend, husbandman 0
4707177 2267623 2267623 defendant Skarbery Richard yeoman 777864 777864 Skarbery, Richard, of Milton by Gravesend, yeoman 3
4707721 2267780 2267780 defendant Rawelyn John laborer 777864 777864 Rawelyn, John, of Milton by Gravesend, laborer 3
4708914 2268157 2268157 defendant Pette John husbandman 777864 777864 Pette, John, of Milton by Gravesend, husbandman 0
4764695 2284946 2284946 defendant Bocher Richard butcher 777864 777864 Bocher, Richard, of Milton by Gravesend, butcher 0
4769634 2286479 2286479 plaintiff Pette John   777864 777864 Pette, John, of Milton by Gravesend 0
4805296 2297859 2297859 plaintiff Broughton John   777864 777864 Broughton, John, of Milton by Gravesend, on his own account 0
5270395 2436443 2436443 defendant Beasylly Mathew husbandman 777864 777864 Beasylly, Mathew, of Milton by Gravesend, husbandman 0
5298761 2444615 2444615 defendant Harpham Michael butcher 777864 777864 Harpham, Michael, of Milton by Gravesend, butcher 0
5383443 2470344 2470344 defendant Beke Richard yeoman 777864 777864 Beke, Richard, of Milton by Gravesend, yeoman 0
5383445 2470345 2470345 defendant Beke Richard yeoman 777864 777864 Beke, Richard, of Milton by Gravesend, yeoman 0
5384175 2470562 2470562 defendant Beke Richard gent 777864 777864 Beke, Richard, of Milton by Gravesend, gent 0
5396007 2473941 2473941 defendant Beke Richard gent 777864 777864 Beke, Richard, of Milton by Gravesend, gent 0
5409269 2477739 2477739 defendant Beke Richard gent 777864 777864 Beke, Richard, of Milton by Gravesend, gent 0
5422770 2481762 2481762 defendant Beke Richard gent 777864 777864 Beke, Richard, of Milton by Gravesend, gent 0
5427121 2483050 2483050 defendant Outlawe Thomas husbandman 777864 777864 Outlawe, Thomas, of Milton by Gravesend, husbandman 1
5427126 2483050 2483050 defendant Postwell Joan widow 777864 777864 Postwell, Joan, of Milton by Gravesend, widow 6
5430675 2484113 2484113 defendant Pole Morris smith 777864 777864 Pole, Morris, of Milton by Gravesend, smith 1
5439002 2486586 2486586 defendant Colyng John husbandman 777864 777864 Colyng, John, of Milton by Gravesend, husbandman 0
5441505 2487382 2487382 defendant Kyrton John innholder 777864 777864 Kyrton, John, of Milton by Gravesend, innholder 1
5444985 2488385 2488385 defendant Restwell Joan widow 777864 777864 Restwell, Joan, of Milton by Gravesend, widow 5
5447209 2489051 2489051 defendant Pakston   mariner 777864 777864 _, Pakston, of Milton by Gravesend, mariner 2
5447210 2489051 2489051 defendant Kyrton John   777864 777864 Kyrton, John, of Milton by Gravesend, inn holder 3
5447444 2489123 2489123 defendant Paxton Richard mariner 777864 777864 Paxton, Richard, of Milton by Gravesend, mariner 2
5454281 2491192 2491192 defendant Kyrton John   777864 777864 Kyrton, John, of Milton by Gravesend, inn holder 1
5466184 2494826 2494826 defendant Kyrton John   777864 777864 Kyrton, John, of Milton by Gravesend, inn holder 1
5466191 2494827 2494827 defendant Kyrton John   777864 777864 Kyrton, John, of Milton by Gravesend, inn holder 1
5471488 2496419 2496419 defendant Pole Morris smith 777864 777864 Pole, Morris, of Milton by Gravesend, smith 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);