names

63 rows where place_id = 591848

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605771 1869470 1869470 defendant A Kent Joan widow 591848 591848 A Kent, Joan, of Watlyngton, Oxon, widow 6
3606671 1869761 1869761 defendant Nasshe William chapman 591848 591848 Nasshe, William, of Watlyngton, Oxon, chapman 1
3606676 1869762 1869762 defendant Nasshe William chapman 591848 591848 Nasshe, William, of Watlyngton, Oxon, chapman 1
3651104 1910712 1910712 defendant Cholles John butcher 591848 591848 Cholles, John, of Watlyngton, Oxon, butcher 1
3659622 1913267 1913267 defendant Benet Richard chapman 591848 591848 Benet, Richard, of Watlyngton, Oxon, chapman 1
3684594 1921313 1921313 defendant Benett Richard chapman 591848 591848 Benett, Richard, of Watlyngton, Oxon, chapman 0
3686069 1921803 1921803 defendant Benett Richard yeoman 591848 591848 Benett, Richard, of Watlyngton, Oxon, yeoman 0
3701166 1926612 1926612 defendant Benett Richard yeoman 591848 591848 Benett, Richard, of Watlyngton, Oxon, yeoman 0
3709142 1929157 1929157 defendant Benett Richard chapman 591848 591848 Benett, Richard, of Watlyngton, Oxon, chapman 0
3724030 1933799 1933799 defendant Benet Richard chapman 591848 591848 Benet, Richard, of Watlyngton, Oxon, chapman 0
3747872 1941257 1941257 defendant Nuynton John butcher 591848 591848 Nuynton, John, of Watlyngton, Oxon, butcher 1
3783864 1952725 1952725 plaintiff Lewys David (legal representative) 591848 591848 Lewys, David, of Watlyngton, Oxon, executrix of 0
3803365 1958952 1958952 defendant Woode John yeoman 591848 591848 Woode, John, of Watlyngton, Oxon, yeoman 0
3869086 1979907 1979907 defendant Dawson Thomas chapman 591848 591848 Dawson, Thomas, of Watlyngton, Oxon, chapman 0
3903277 1991319 1991319 defendant Chollys John yeoman 591848 591848 Chollys, John, of Watlyngton, Oxon, yeoman 0
3997559 2023875 2023875 defendant Tomson Michael yeoman 591848 591848 Tomson, Michael, of Watlyngton, Oxon, yeoman 1
4028156 2034719 2034719 defendant Hoptrowe Robert chapman 591848 591848 Hoptrowe, Robert, of Watlyngton, Oxon, chapman 1
4561127 2219436 2219436 defendant Davy John   591848 591848 Davy, John, of Watlyngton, Oxon 0
4662350 2249700 2249700 defendant Arnold alias Irissh John chapman 591848 591848 Arnold alias Irissh, John, of Watlyngton, Oxon, chapman 2
4676201 2258168 2258168 defendant Taillour Richard laborer 591848 591848 Taillour, Richard, of Watlyngton, Oxon, laborer 2
4682234 2260066 2260066 defendant Sadeler John husbandman 591848 591848 Sadeler, John, of Watlyngton, Oxon, husbandman 0
4683670 2260493 2260493 defendant Knyght John husbandman 591848 591848 Knyght, John, of Watlyngton, Oxon, husbandman 2
4709532 2268336 2268336 defendant Knyght Joanna widow 591848 591848 Knyght, Joanna, of Watlyngton, Oxon, widow 0
4717492 2270807 2270807 defendant (illegible) John, sen (legal representative) 591848 591848 _, John, sen, of Watlyngton, Oxon, executors of 0
4717494 2270807 2270807 defendant Bocher William husbandman 591848 591848 Bocher, William, of Watlyngton, Oxon, husbandman 2
4720111 2271633 2271633 defendant Bocher John butcher 591848 591848 Bocher, John, of Watlyngton, Oxon, butcher 1
4908929 2329338 2329338 defendant Burneham John collier 591848 591848 Burneham, John, of Watlyngton, Oxon, collier 0
4979612 2350859 2350859 defendant Bray John chapman 591848 591848 Bray, John, of Watlyngton, Oxon, chapman 0
4998519 2356439 2356439 defendant Bray Robert chapman 591848 591848 Bray, Robert, of Watlyngton, Oxon, chapman 0
5030732 2365861 2365861 defendant Bray Robert chapman or yeoman 591848 591848 Bray, Robert, of Watlyngton, Oxon, chapman or yeoman 0
5030738 2365862 2365862 defendant Bray Robert chapman or yeoman 591848 591848 Bray, Robert, of Watlyngton, Oxon, chapman or yeoman 0
5034452 2366936 2366936 defendant Bray Robert chapman 591848 591848 Bray, Robert, of Watlyngton, Oxon, chapman 0
5034453 2366936 2366936 defendant Naseglys alias Taillour John chapman 591848 591848 Naseglys alias Taillour, John, of Watlyngton, Oxon, chapman 1
5043789 2369770 2369770 defendant Bray Robert   591848 591848 Bray, Robert, of Watlyngton, Oxon, bailiff 1
5045231 2370201 2370201 defendant Bray Robert   591848 591848 Bray, Robert, of Watlyngton, Oxon, bailiff 0
5053793 2372735 2372735 defendant Bray Robert chapman 591848 591848 Bray, Robert, of Watlyngton, Oxon, chapman 1
5062136 2375231 2375231 defendant Waryn John smith 591848 591848 Waryn, John, of Watlyngton, Oxon, smith 1
5062141 2375232 2375232 defendant Waryn John smith 591848 591848 Waryn, John, of Watlyngton, Oxon, smith 1
5075994 2379313 2379313 defendant Bray Robert yeoman 591848 591848 Bray, Robert, of Watlyngton, Oxon, yeoman 0
5105151 2387944 2387944 defendant Nanseglys John chapman 591848 591848 Nanseglys, John, of Watlyngton, Oxon, chapman 4
5119887 2392251 2392251 defendant Est John, senior draper 591848 591848 Est, John, senior, of Watlyngton, Oxon, draper 1
5122738 2393084 2393084 defendant Bray Robert yeoman 591848 591848 Bray, Robert, of Watlyngton, Oxon, yeoman 0
5129814 2395206 2395206 defendant Est John husbandman 591848 591848 Est, John, of Watlyngton, Oxon, husbandman 0
5134532 2396593 2396593 defendant Warner Richard husbandman 591848 591848 Warner, Richard, of Watlyngton, Oxon, husbandman 3
5149004 2400836 2400836 defendant Est John husbandman 591848 591848 Est, John, of Watlyngton, Oxon, husbandman 0
5158613 2403639 2403639 defendant Gebons Thomas   591848 591848 Gebons, Thomas, of Watlyngton, Oxon, wool man 2
5169940 2406938 2406938 defendant atte Lee Thomas yeoman 591848 591848 atte Lee, Thomas, of Watlyngton, Oxon, yeoman 0
5226435 2423393 2423393 defendant Gybon Thomas merchant 591848 591848 Gybon, Thomas, of Watlyngton, Oxon, merchant 1
5226440 2423394 2423394 defendant Gybon Thomas merchant 591848 591848 Gybon, Thomas, of Watlyngton, Oxon, merchant 2
5249228 2429894 2429894 defendant Bukelond Richard smith 591848 591848 Bukelond, Richard, of Watlyngton, Oxon, smith 2
5363554 2464254 2464254 defendant Warner Richard yeoman 591848 591848 Warner, Richard, of Watlyngton, Oxon, yeoman 1
5385668 2470971 2470971 defendant Hautmount Robert gent 591848 591848 Hautmount, Robert, of Watlyngton, Oxon, gent 0
5434659 2485303 2485303 defendant Junklyn Thomas smith 591848 591848 Junklyn, Thomas, of Watlyngton, Oxon, smith 2
5449986 2489885 2489885 defendant Junklyn or Innklyn Thomas smith 591848 591848 Junklyn or Innklyn, Thomas, of Watlyngton, Oxon, smith 1
5454182 2491149 2491149 defendant Junkyn Thomas smith 591848 591848 Junkyn, Thomas, of Watlyngton, Oxon, smith 2
5500547 2505100 2505100 defendant Messenger John husbandman 591848 591848 Messenger, John, of Watlyngton, Oxon, husbandman 4
5504102 2506200 2506200 defendant Messenger John husbandman 591848 591848 Messenger, John, of Watlyngton, Oxon, husbandman 0
5553683 2521112 2521112 defendant Benet Richard chapman 591848 591848 Benet, Richard, of Watlyngton, Oxon, chapman 3
5555797 2521683 2521683 defendant Caryngton Ralph dyer 591848 591848 Caryngton, Ralph, of Watlyngton, Oxon, dyer 0
5557639 2522191 2522191 defendant Bennet Richard yeoman 591848 591848 Bennet, Richard, of Watlyngton, Oxon, yeoman 0
5566095 2524681 2524681 defendant Yong John husbandman 591848 591848 Yong, John, of Watlyngton, Oxon, husbandman 2
5586520 2530822 2530822 defendant Dene James yeoman 591848 591848 Dene, James, of Watlyngton, Oxon, yeoman 4
5586528 2530823 2530823 defendant Dene James yeoman 591848 591848 Dene, James, of Watlyngton, Oxon, yeoman 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);