names

22 rows where place_id = 589298

✎ 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
3597145 1866731 1866731 defendant Andrewe John husbandman 589298 589298 Andrewe, John, of Snodland, husbandman 0
3645652 1909039 1909039 defendant Bewke John smith 589298 589298 Bewke, John, of Snodland, smith 2
3794373 1956119 1956119 defendant Whyte Edward gent 589298 589298 Whyte, Edward, of Snodland, gent 0
3813559 1962158 1962158 defendant Chetynden Nicholas sherman 589298 589298 Chetynden, Nicholas, of Snodland, sherman 3
3973905 2015442 2015442 defendant Downe Richard miller 589298 589298 Downe, Richard, of Snodland, miller 0
3973907 2015443 2015443 defendant Downe Richard miller 589298 589298 Downe, Richard, of Snodland, miller 0
4115138 2065703 2065703 plaintiff Ussher John (legal representative) 589298 589298 Ussher, John, of Snodland, yeoman, executors of 0
4233753 2107329 2107329 defendant Wood William gent 589298 589298 Wood, William, of Snodland, gent 2
4234884 2107753 2107753 defendant Bechynge Hamon yeoman 589298 589298 Bechynge, Hamon, of Snodland, yeoman 1
4320140 2137146 2137146 defendant Reader Nicholas husbandman 589298 589298 Reader, Nicholas, of Snodland, husbandman 0
4845953 2310241 2310241 defendant Benayt Thomas husbandman 589298 589298 Benayt, Thomas, of Snodland, husbandman 0
5159346 2403849 2403849 defendant Stalworth Roger yeoman 589298 589298 Stalworth, Roger, of Snodland, yeoman 2
5195257 2414359 2414359 defendant Stalworth Roger yeoman 589298 589298 Stalworth, Roger, of Snodland, yeoman 2
5200384 2415873 2415873 defendant Canon Roger husbandman 589298 589298 Canon, Roger, of Snodland, husbandman 3
5302446 2445697 2445697 defendant Nicolet John husbandman 589298 589298 Nicolet, John, of Snodland, husbandman 4
5351898 2460696 2460696 defendant Dalley John husbandman 589298 589298 Dalley, John, of Snodland, husbandman 1
5376757 2468327 2468327 defendant Andrew Robert miller 589298 589298 Andrew, Robert, of Snodland, miller 4
5405287 2476597 2476597 defendant Burnard John beer brewer 589298 589298 Burnard, John, of Snodland, beer brewer 2
5471225 2496331 2496331 defendant Stalworth Robert husbandman 589298 589298 Stalworth, Robert, of Snodland, husbandman 0
5493011 2502817 2502817 defendant Bocher Robert butcher 589298 589298 Bocher, Robert, of Snodland, butcher 0
5493013 2502817 2502817 defendant Canell or Cavell Roger husbandman 589298 589298 Canell or Cavell, Roger, of Snodland, husbandman 2
5556162 2521797 2521797 defendant Holeway John husbandman 589298 589298 Holeway, John, of Snodland, 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);