names

50 rows where place_id = 590269

✎ 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
3600442 1867786 1867786 defendant Barnard Richard husbandman 590269 590269 Barnard, Richard, of Codyngton, husbandman 0
3632979 1905133 1905133 defendant Nasshe John husbandman 590269 590269 Nasshe, John, of Codyngton, husbandman 0
3638404 1906832 1906832 defendant Dean John clerk 590269 590269 Dean, John, of Codyngton, clerk 0
3662838 1914292 1914292 plaintiff Naysshe John gent 590269 590269 Naysshe, John, of Codyngton, gent 0
3683552 1920988 1920988 defendant Byrch Thomas husbandman 590269 590269 Byrch, Thomas, of Codyngton, husbandman 0
3757666 1944376 1944376 defendant Gateley John husbandman 590269 590269 Gateley, John, of Codyngton, husbandman 2
3758898 1944774 1944774 defendant Barton John yeoman 590269 590269 Barton, John, of Codyngton, yeoman 0
3758899 1944774 1944774 defendant Peerson John sawyer 590269 590269 Peerson, John, of Codyngton, sawyer 1
3758900 1944774 1944774 defendant Williams John sawyer 590269 590269 Williams, John, of Codyngton, sawyer 2
3767745 1947548 1947548 defendant Tayllour Richard clerk 590269 590269 Tayllour, Richard, of Codyngton, clerk 0
3786060 1953431 1953431 defendant Skaye Richard husbandman 590269 590269 Skaye, Richard, of Codyngton, husbandman 4
3859174 1976559 1976559 defendant Ive William gent 590269 590269 Ive, William, of Codyngton, gent 0
4057803 2045175 2045175 defendant Nash Richard gent 590269 590269 Nash, Richard, of Codyngton, gent 0
4459547 2188040 2188040 defendant Claydon John   590269 590269 Claydon, John, of Codyngton 1
4459560 2188044 2188044 defendant Claydon John   590269 590269 Claydon, John, of Codyngton 2
4459584 2188050 2188050 defendant Claydon John   590269 590269 Claydon, John, of Codyngton 2
4461946 2188794 2188794 defendant Claydon John   590269 590269 Claydon, John, of Codyngton 2
4629942 2240285 2240285 defendant Padlee John   590269 590269 Padlee, John, of Codyngton 2
4692839 2263270 2263270 defendant Warener Thomas hosteller 590269 590269 Warener, Thomas, of Codyngton, hosteller 0
4754773 2281877 2281877 defendant Codyngton Simon gent 590269 590269 Codyngton, Simon, of Codyngton, gent 0
4754786 2281878 2281878 defendant Gardyn John husbandman 590269 590269 Gardyn, John, of Codyngton, husbandman 8
4754787 2281878 2281878 defendant Bast Nicholas husbandman 590269 590269 Bast, Nicholas, of Codyngton, husbandman 9
4754788 2281878 2281878 defendant Choser Peter husbandman 590269 590269 Choser, Peter, of Codyngton, husbandman 10
4759878 2283424 2283424 defendant Codyngton Simon gent 590269 590269 Codyngton, Simon, of Codyngton, gent 0
4759880 2283425 2283425 defendant Codyngton Simon gent 590269 590269 Codyngton, Simon, of Codyngton, gent 0
4776339 2288593 2288593 defendant Codyngton Simon gent 590269 590269 Codyngton, Simon, of Codyngton, gent 0
4776341 2288593 2288593 defendant Gardyn John husbandman 590269 590269 Gardyn, John, of Codyngton, husbandman 2
4778217 2289171 2289171 defendant Scardeburgh John husbandman 590269 590269 Scardeburgh, John, of Codyngton, husbandman 3
4782112 2290404 2290404 defendant Codyngton Simon gent 590269 590269 Codyngton, Simon, of Codyngton, gent 0
4802127 2296858 2296858 defendant Codyngton Simon gent 590269 590269 Codyngton, Simon, of Codyngton, gent 0
4802129 2296858 2296858 defendant Gardyn John husbandman 590269 590269 Gardyn, John, of Codyngton, husbandman 2
4892413 2324367 2324367 defendant Outelade William butcher 590269 590269 Outelade, William, of Codyngton, butcher 2
4945762 2340660 2340660 defendant Chapman William husbandman 590269 590269 Chapman, William, of Codyngton, husbandman 0
4982268 2351613 2351613 defendant Codyngton Thomas esq 590269 590269 Codyngton, Thomas, of Codyngton, esq 0
5002516 2357647 2357647 defendant Davy Henry husbandman 590269 590269 Davy, Henry, of Codyngton, husbandman 1
5054036 2372800 2372800 defendant Codyngton Thomas gent 590269 590269 Codyngton, Thomas, of Codyngton, gent 0
5054037 2372800 2372800 defendant Shipton Nicholas yeoman 590269 590269 Shipton, Nicholas, of Codyngton, yeoman 1
5057344 2373763 2373763 defendant Codyngton Thomas gent 590269 590269 Codyngton, Thomas, of Codyngton, gent 0
5126777 2394308 2394308 defendant Conley William gent 590269 590269 Conley, William, of Codyngton, gent 2
5143652 2399278 2399278 defendant Conley William gent 590269 590269 Conley, William, of Codyngton, gent 0
5164796 2405436 2405436 defendant Couley William gent 590269 590269 Couley, William, of Codyngton, gent 0
5178265 2409346 2409346 defendant Conley William gent 590269 590269 Conley, William, of Codyngton, gent 0
5311217 2448381 2448381 defendant Quiteladde or Outteladde John husbandman 590269 590269 Quiteladde or Outteladde, John, of Codyngton, husbandman 0
5311219 2448381 2448381 defendant Hikkys Robert husbandman 590269 590269 Hikkys, Robert, of Codyngton, husbandman 2
5323221 2452026 2452026 defendant Grey John tailor 590269 590269 Grey, John, of Codyngton, tailor 0
5493809 2503052 2503052 defendant Nasshe John yeoman 590269 590269 Nasshe, John, of Codyngton, yeoman 0
5502225 2505620 2505620 defendant Lane Henry husbandman 590269 590269 Lane, Henry, of Codyngton, husbandman 6
5502226 2505620 2505620 defendant Lane William, junior husbandman 590269 590269 Lane, William, junior, of Codyngton, husbandman 7
5521459 2511529 2511529 defendant Nesshe John, junior yeoman 590269 590269 Nesshe, John, junior, of Codyngton, yeoman 1
5597658 2534164 2534164 defendant Assheby William gent 590269 590269 Assheby, William, of Codyngton, gent 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);