names

33 rows where place_id = 589007

✎ 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
3596246 1866453 1866453 defendant Stedham John smith 589007 589007 Stedham, John, of Bradwater, smith 1
3959828 2010528 2010528 defendant Wassher Edward yeoman 589007 589007 Wassher, Edward, of Bradwater, yeoman 1
4511819 2204144 2204144 defendant Nore Simon   589007 589007 Nore, Simon, of Bradwater 0
4707364 2267679 2267679 defendant Taillour Thomas warner or warrener 589007 589007 Taillour, Thomas, of Bradwater, warner or warrener 3
4730113 2274619 2274619 defendant Warner John yeoman 589007 589007 Warner, John, of Bradwater, yeoman 0
4801640 2296697 2296697 defendant Smyth John   589007 589007 Smyth, John, of Bradwater husbandman 2
4826796 2304420 2304420 defendant atte Chambre Thomas husbandman 589007 589007 atte Chambre, Thomas, of Bradwater, husbandman 0
4836570 2307409 2307409 defendant Fulfan Thomas husbandman 589007 589007 Fulfan, Thomas, of Bradwater, husbandman 0
4863861 2315672 2315672 defendant Fulfan Thomas husbandman 589007 589007 Fulfan, Thomas, of Bradwater, husbandman 0
4874908 2319095 2319095 defendant Fauconer Henry husbandman 589007 589007 Fauconer, Henry, of Bradwater, husbandman 3
4912529 2330420 2330420 defendant Rede Peter butcher 589007 589007 Rede, Peter, of Bradwater, butcher 0
4912533 2330421 2330421 defendant Rede Peter butcher 589007 589007 Rede, Peter, of Bradwater, butcher 0
4942148 2339529 2339529 defendant Slutter John husbandman 589007 589007 Slutter, John, of Bradwater, husbandman 0
4964414 2346270 2346270 defendant Magge John   589007 589007 Magge, John, of Bradwater, shepherd 3
4974815 2349439 2349439 defendant Smyth Robert smith 589007 589007 Smyth, Robert, of Bradwater, smith 2
4999671 2356778 2356778 defendant Graunsford Richard gent 589007 589007 Graunsford, Richard, of Bradwater, gent 0
5021909 2363302 2363302 defendant Badyan John husbandman 589007 589007 Badyan, John, of Bradwater, husbandman 0
5026627 2364664 2364664 defendant Grauntford Richard gent 589007 589007 Grauntford, Richard, of Bradwater, or of Sountyngton, gent 0
5034409 2366922 2366922 defendant Hals Walter clerk 589007 589007 Hals, Walter, of Bradwater, clerk 2
5045742 2370361 2370361 defendant Grauntford Richard gent 589007 589007 Grauntford, Richard, of Bradwater, gent 0
5074165 2378758 2378758 defendant Vesk Peter gent 589007 589007 Vesk, Peter, of Bradwater, gent 0
5099298 2386224 2386224 defendant Couper Philip husbandman 589007 589007 Couper, Philip, of Bradwater, husbandman 0
5099299 2386224 2386224 defendant Parker Richard husbandman 589007 589007 Parker, Richard, of Bradwater, husbandman 1
5106189 2388246 2388246 defendant Grene Patrick clerk 589007 589007 Grene, Patrick, of Bradwater, clerk 4
5112653 2390089 2390089 defendant (not given) Patrick rector of Grene 589007 589007 Grene, Patrick, of Bradwater, rector of Thakham 1
5113968 2390476 2390476 defendant Plommere Richard yeoman 589007 589007 Plommere, Richard, of Bradwater, yeoman 0
5133196 2396189 2396189 defendant Fulvan or Fulban Reginald husbandman 589007 589007 Fulvan or Fulban, Reginald, of Bradwater, husbandman 0
5152999 2402017 2402017 defendant Fulvan Reginald husbandman 589007 589007 Fulvan, Reginald, of Bradwater, husbandman 0
5163291 2404997 2404997 defendant Soper Thomas esq 589007 589007 Soper, Thomas, of Bradwater, esq 0
5163293 2404998 2404998 defendant Soper Thomas esq 589007 589007 Soper, Thomas, of Bradwater, esq 0
5188338 2412299 2412299 defendant Fulvan Reginald husbandman 589007 589007 Fulvan, Reginald, of Bradwater, husbandman 0
5206014 2417491 2417491 defendant Fulvan Reginald husbandman 589007 589007 Fulvan, Reginald, of Bradwater, husbandman 0
5329326 2453855 2453855 defendant Tylford William yeoman 589007 589007 Tylford, William, of Bradwater, yeoman 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);