names

30 rows where place_id = 609750

✎ 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
3611832 1871360 1871360 defendant Coker Thomas husbandman 609750 609750 Coker, Thomas, of Wodham Mortimer, husbandman 1
3611833 1871360 1871360 defendant Bernard William husbandman 609750 609750 Bernard, William, of Wodham Mortimer, husbandman 2
3680111 1919847 1919847 defendant Radclyff James clerk 609750 609750 Radclyff, James, of Wodham Water, clerk 0
3696325 1925072 1925072 plaintiff Sander Robert husbandman 609750 609750 Sander, Robert, of Wodham, husbandman 0
3696411 1925103 1925103 defendant Ratclyff Robert   609750 609750 Ratclyff, Robert, of Wodham Water, knight, Lord FitzWauter 0
3906241 1992375 1992375 defendant Cokar alias Coke Thomas yeoman 609750 609750 Cokar alias Coke, Thomas, of Wodham Mortymer, yeoman 0
3976922 2016493 2016493 defendant Halsoth Robert yeoman 609750 609750 Halsoth, Robert, of Wodham Water, yeoman 7
4468611 2190854 2190854 defendant Mellere John   609750 609750 Mellere, John, of Wodham 1
4525961 2208421 2208421 defendant atte Boure John   609750 609750 atte Boure, John, of Wodham Water 0
4559480 2218914 2218914 defendant Sparwe John   609750 609750 Sparwe, John, of Wodham Water 2
4598386 2230734 2230734 defendant Lovelych John   609750 609750 Lovelych, John, of Wodham Walter 0
4728865 2274265 2274265 defendant Salerne John husbandman 609750 609750 Salerne, John, of Wodham Mortymer, husbandman 0
4772064 2287239 2287239 defendant fitz Wauter Walter   609750 609750 fitz Wauter, Walter, of Wodham, knight 0
4877485 2319916 2319916 defendant Salvage John husbandman 609750 609750 Salvage, John, of Wodham Water, husbandman 3
4877491 2319917 2319917 defendant Salvage John husbandman 609750 609750 Salvage, John, of Wodham Water, husbandman 3
4959184 2344716 2344716 defendant Cumberlowe John yeoman 609750 609750 Cumberlowe, John, of Wodham Water, yeoman 0
4990334 2354015 2354015 defendant Reynold John Essex 609750 609750 Reynold John, of Wodham Water, Essex 4
5017985 2362143 2362143 defendant Roulffe Thomas smith 609750 609750 Roulffe, Thomas, of Wodham Mortymer, smith 0
5067775 2376861 2376861 defendant Chapman John husbandman 609750 609750 Chapman, John, of Wodham Water, husbandman 6
5176461 2408802 2408802 defendant Dycheburn Richard yeoman 609750 609750 Dycheburn, Richard, of Wodham, yeoman 1
5176462 2408802 2408802 defendant Atkynson John husbandman 609750 609750 Atkynson, John, of Wodham, husbandman 2
5187358 2412027 2412027 defendant Hunte John husbandman 609750 609750 Hunte, John, of Wodham Water, husbandman 4
5198638 2415360 2415360 defendant Atkynson Thomas husbandman 609750 609750 Atkynson, Thomas, of Wodham, husbandman 0
5198640 2415360 2415360 defendant Atkynson John husbandman 609750 609750 Atkynson, John, of Wodham, husbandman 2
5205573 2417375 2417375 defendant Hunt John husbandman 609750 609750 Hunt, John, of Wodham Water, husbandman 4
5292123 2442695 2442695 defendant Sawyer Robert husbandman 609750 609750 Sawyer, Robert, of Wodham, husbandman 1
5322189 2451708 2451708 defendant Smyth John husbandman 609750 609750 Smyth, John, of Wodham Mortymer, husbandman 0
5344063 2458320 2458320 defendant Pascall William husbandman 609750 609750 Pascall, William, of Wodham Water, husbandman 2
5506935 2507083 2507083 defendant Coker John husbandman 609750 609750 Coker, John, of Wodham Mortymer, husbandman 0
5593697 2533018 2533018 plaintiff Arnold John yeoman 609750 609750 Arnold, John, of Wodham Water, 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);