names

62 rows where place_id = 770318

✎ 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
4312377 2134467 2134467 defendant Stephyn Alexander (legal representative) 770318 770318 Stephyn, Alexander, of Goudhurst, tailor, executrix of 1
4325919 2139043 2139043 defendant Stephyn Alexander (legal representative) 770318 770318 Stephyn, Alexander, of Goudhurst, tailor, executrix of 1
4566923 2221218 2221218 defendant Courthope John, sen   770318 770318 Courthope, John, sen, of Goudhurst 0
4575346 2223802 2223802 defendant Goldyng Henry   770318 770318 Goldyng, Henry, of Goudhurst 0
4703233 2266391 2266391 defendant Donnere Richard husbandman 770318 770318 Donnere, Richard, of Goudhurst, husbandman 1
4703234 2266391 2266391 defendant Clerk Thomas husbandman 770318 770318 Clerk, Thomas, of Goudhurst, husbandman 2
4703978 2266621 2266621 defendant Overy Nicholas smith 770318 770318 Overy, Nicholas, of Goudhurst, smith 0
4708806 2268124 2268124 defendant Mugge William   770318 770318 Mugge, William, of Goudhurst, ripiere or an inland fish seller 0
4711867 2269042 2269042 defendant Courthope John butcher 770318 770318 Courthope, John, of Goudhurst, butcher 0
4712900 2269347 2269347 defendant Chaloner William husbandman 770318 770318 Chaloner, William, of Goudhurst, husbandman 0
4717255 2270727 2270727 defendant Walter William laborer 770318 770318 Walter, William, of Goudhurst, laborer 0
4726813 2273656 2273656 defendant Kynot Richard wheeler 770318 770318 Kynot, Richard, of Goudhurst, wheeler 0
4726815 2273657 2273657 defendant Kynot John   770318 770318 Kynot, John, of Goudhurst, wheel wright 0
4734439 2275940 2275940 defendant Courthope John butcher 770318 770318 Courthope, John, of Goudhurst, butcher 0
4736289 2276479 2276479 defendant Bereworthe John yeoman 770318 770318 Bereworthe, John, of Goudhurst, yeoman 0
4737289 2276781 2276781 defendant Twysden Roger husbandman 770318 770318 Twysden, Roger, of Goudhurst, husbandman 0
4738759 2277212 2277212 defendant Trottare Henry husbandman 770318 770318 Trottare, Henry, of Goudhurst, husbandman 0
4740716 2277803 2277803 defendant Wyndhell Thomas laborer 770318 770318 Wyndhell, Thomas, of Goudhurst, laborer 1
4756148 2282297 2282297 defendant Northbery Thomas   770318 770318 Northbery, Thomas, of Goudhurst, inland fish seller 0
4756149 2282297 2282297 defendant Holbeme John   770318 770318 Holbeme, John, of Goudhurst, inland fish seller 1
4760780 2283712 2283712 defendant atte Stone Walter laborer 770318 770318 atte Stone, Walter, of Goudhurst, laborer 3
4760781 2283712 2283712 defendant atte Stone Thomas laborer 770318 770318 atte Stone, Thomas, of Goudhurst, laborer 4
4760783 2283712 2283712 defendant Wygge Simon husbandman 770318 770318 Wygge, Simon, of Goudhurst, husbandman 6
4764552 2284900 2284900 defendant Herde John   770318 770318 Herde, John, of Goudhurst, vicar 0
4764553 2284900 2284900 defendant Horsmenden Stephen husbandman 770318 770318 Horsmenden, Stephen, of Goudhurst, husbandman 1
4771678 2287117 2287117 defendant Roper John laborer 770318 770318 Roper, John, of Goudhurst, laborer 0
4830896 2305687 2305687 defendant Broker John smith 770318 770318 Broker, John, of Goudhurst, smith 0
4830940 2305702 2305702 plaintiff Bourne Stephen   770318 770318 Bourne, Stephen, of Goudhurst 0
4831002 2305722 2305722 defendant Chaloner William laborer 770318 770318 Chaloner, William, of Goudhurst, laborer 0
4834902 2306917 2306917 defendant atte Wode Simon butcher 770318 770318 atte Wode, Simon, of Goudhurst, butcher 0
4841862 2308988 2308988 plaintiff Kynott Richard   770318 770318 Kynott, Richard, of Goudhurst 0
4841863 2308988 2308988 defendant Heygham William husbandman 770318 770318 Heygham, William, of Goudhurst, son of Roger, husbandman 0
4846895 2310538 2310538 plaintiff Rede John   770318 770318 Rede, John, of Goudhurst, vicar 0
4847214 2310628 2310628 defendant Herry John   770318 770318 Herry, John, of Goudhurst, linen weaver 1
4847215 2310628 2310628 defendant Houchon John butcher 770318 770318 Houchon, John, of Goudhurst, butcher 2
4849241 2311238 2311238 defendant Tyly Richard laborer 770318 770318 Tyly, Richard, of Goudhurst, laborer 0
4849243 2311239 2311239 defendant Tyly Richard laborer 770318 770318 Tyly, Richard, of Goudhurst, laborer 0
4863550 2315570 2315570 defendant Love John tailor 770318 770318 Love, John, of Goudhurst, tailor 2
5004204 2358120 2358120 defendant Pepesham John carpenter 770318 770318 Pepesham, John, of Goudhurst, carpenter 1
5004873 2358323 2358323 defendant Love John tailor 770318 770318 Love, John, of Goudhurst, tailor 0
5128550 2394827 2394827 plaintiff Colepeper John   770318 770318 Colepeper, John, of Goudhurst 0
5138312 2397714 2397714 defendant Courthope Robert smith 770318 770318 Courthope, Robert, of Goudhurst, smith 0
5154276 2402408 2402408 defendant Courthope Robert smith 770318 770318 Courthope, Robert, of Goudhurst, smith 0
5159104 2403777 2403777 defendant Courthope Robert smith 770318 770318 Courthope, Robert, of Goudhurst, smith 0
5159106 2403778 2403778 defendant Courthope Robert smith 770318 770318 Courthope, Robert, of Goudhurst, smith 0
5159107 2403778 2403778 defendant Birchette Thomas husbandman 770318 770318 Birchette, Thomas, of Goudhurst, husbandman 1
5159196 2403805 2403805 defendant Bayteppe Henry carpenter 770318 770318 Bayteppe, Henry, of Goudhurst, carpenter 0
5165562 2405668 2405668 defendant Stopersfeld William husbandman 770318 770318 Stopersfeld, William, of Goudhurst, husbandman 1
5179718 2409804 2409804 defendant Stopersfeld William husbandman 770318 770318 Stopersfeld, William, of Goudhurst, husbandman 1
5183635 2410947 2410947 defendant Culpeper John gent 770318 770318 Culpeper, John, of Goudhurst, gent 1
5183636 2410947 2410947 defendant Culpeper Nicholas gent 770318 770318 Culpeper, Nicholas, of Goudhurst, gent 2
5194973 2414282 2414282 defendant Courthope Robert smith 770318 770318 Courthope, Robert, of Goudhurst, smith 0
5194976 2414282 2414282 defendant Baseden Robert   770318 770318 Baseden, Robert, of Goudhurst, wheel wright 3
5202010 2416355 2416355 defendant Stopersfeld William husbandman 770318 770318 Stopersfeld, William, of Goudhurst, husbandman 1
5209036 2418375 2418375 defendant Courthope Robert smith 770318 770318 Courthope, Robert, of Goudhurst, smith 0
5298119 2444464 2444464 defendant Godfrey John draper 770318 770318 Godfrey, John, of Goudhurst, draper 0
5308593 2447603 2447603 defendant Atkyn John fuller 770318 770318 Atkyn, John, of Goudhurst, fuller 2
5422851 2481789 2481789 defendant Bereworthe James husbandman 770318 770318 Bereworthe, James, of Goudhurst, husbandman 0
5455774 2491627 2491627 defendant Dodde Thomas baker 770318 770318 Dodde, Thomas, of Goudhurst, baker 0
5464840 2494398 2494398 defendant Burges Henry husbandman 770318 770318 Burges, Henry, of Goudhurst, husbandman 1
5467597 2495238 2495238 defendant Dodde Thomas baker 770318 770318 Dodde, Thomas, of Goudhurst, baker 0
5472704 2496803 2496803 defendant Skynner John laborer 770318 770318 Skynner, John, of Goudhurst, laborer 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);