names

50 rows where place_id = 615438

✎ 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
3667704 1915845 1915845 plaintiff Wymbill Thomas (legal representative) 615438 615438 Wymbill, Thomas, of Harwich, executors of 0
3667710 1915846 1915846 plaintiff Wymbyll Thomas (legal representative) 615438 615438 Wymbyll, Thomas, of Harwich, executors of 0
3667715 1915847 1915847 plaintiff Wymbyll Thomas (legal representative) 615438 615438 Wymbyll, Thomas, of Harwich, executors of 0
3708876 1929067 1929067 defendant Browne John merchant 615438 615438 Browne, John, of Harwich, merchant 0
3821343 1964567 1964567 plaintiff Rychemond John (legal representative) 615438 615438 Rychemond, John, of Harwich, executor of 0
3821347 1964568 1964568 plaintiff Rychemond John (legal representative) 615438 615438 Rychemond, John, of Harwich, merchant, executor of 0
3872524 1981034 1981034 defendant Jopson John yeoman 615438 615438 Jopson, John, of Harwich, yeoman 1
3881492 1984074 1984074 defendant Sampson Adam merchant 615438 615438 Sampson, Adam, of Harwich, merchant 0
3886191 1985632 1985632 defendant Yaxley Christopher clerk 615438 615438 Yaxley, Christopher, of Harwich, clerk 0
3966587 2012949 2012949 defendant Greye John mariner 615438 615438 Greye, John, of Harwich, mariner 0
4087350 2055765 2055765 defendant Nicholson Robert tailor 615438 615438 Nicholson, Robert, of Harwich, tailor 2
4087351 2055765 2055765 defendant Davye Arthur mariner 615438 615438 Davye, Arthur, of Harwich, mariner 3
4167579 2084157 2084157 defendant Crosse John turner 615438 615438 Crosse, John, of Harwich, turner 0
4167580 2084157 2084157 defendant Cowper Margaret widow 615438 615438 Cowper, Margaret, of Harwich, widow 1
4167581 2084157 2084157 defendant Russell Nicholas mariner 615438 615438 Russell, Nicholas, of Harwich, mariner 2
4167582 2084157 2084157 defendant Kinge Richard butcher 615438 615438 Kinge, Richard, of Harwich, butcher 3
4208315 2098455 2098455 defendant Grene William   615438 615438 Grene, William, of Harwich, sailor 0
4234235 2107511 2107511 defendant Daye Owen butcher 615438 615438 Daye, Owen, of Harwich, butcher 0
4238803 2109193 2109193 defendant Johnson alias Arnold Hercules beer brewer 615438 615438 Johnson alias Arnold, Hercules, of Harwich, or of Maningtree, beer brewer 0
4275933 2121532 2121532 defendant Daye Robert butcher 615438 615438 Daye, Robert, of Harwich, butcher 0
4275934 2121532 2121532 defendant Stutton George butcher 615438 615438 Stutton, George, of Harwich, butcher 1
4277918 2122207 2122207 defendant Rolfe Thomas   615438 615438 Rolfe, Thomas, of Harwich, sailor 0
4278628 2122459 2122459 defendant Hawkyn John mariner 615438 615438 Hawkyn, John, of Harwich, mariner 1
4285916 2125017 2125017 defendant Johnson Hercules beer brewer 615438 615438 Johnson, Hercules, of Harwich, beer brewer 0
4323556 2138295 2138295 defendant Tolson Robert mariner 615438 615438 Tolson, Robert, of Harwich, mariner 1
4387222 2160375 2160375 defendant Godard Edmund tailor 615438 615438 Godard, Edmund, of Harwich, tailor 2
4401053 2164944 2164944 defendant Morris John blacksmith 615438 615438 Morris, John, of Harwich, blacksmith 0
4401055 2164945 2164945 defendant Morrys John blacksmith 615438 615438 Morrys, John, of Harwich, blacksmith 0
4407815 2167179 2167179 defendant Harryson Margaret spister 615438 615438 Harryson, Margaret, of Harwich, spister 1
4534172 2210950 2210950 defendant Juory John mariner 615438 615438 Juory, John, of Harwich, mariner 0
4720941 2271881 2271881 defendant Hethe Geoffrey shipman 615438 615438 Hethe, Geoffrey, of Harwich, shipman 1
4755380 2282067 2282067 defendant Stegeyn John (legal representative) 615438 615438 Stegeyn, John, of Harwich, executor of 2
4762160 2284144 2284144 plaintiff Felde Geoffrey   615438 615438 Felde, Geoffrey, of Harwich 0
4762162 2284145 2284145 plaintiff Felde Geoffrey   615438 615438 Felde, Geoffrey, of Harwich 0
4807385 2298506 2298506 defendant Crouch Thomas merchant 615438 615438 Crouch, Thomas, of Harwich, merchant 1
4830306 2305516 2305516 defendant Tourys John dapper 615438 615438 Tourys, John, of Harwich, dapper 0
4839419 2308251 2308251 defendant Pyksomer Robert butcher 615438 615438 Pyksomer, Robert, of Harwich, butcher 0
4908184 2329112 2329112 plaintiff Andrewe Thomas (legal representative) 615438 615438 Andrewe, Thomas, of Harwich, executors of 0
4913558 2330737 2330737 plaintiff Codlyng Robert merchant 615438 615438 Codlyng, Robert, of Harwich, merchant 0
4923274 2333701 2333701 defendant Rawemedowe Thomas butcher 615438 615438 Rawemedowe, Thomas, of Harwich, butcher 0
4990402 2354041 2354041 defendant Borwell John ferier or farrier 615438 615438 Borwell, John, of Harwich, ferier or farrier 0
5164257 2405283 2405283 defendant Broun John yeoman 615438 615438 Broun, John, of Harwich, yeoman 0
5176794 2408899 2408899 defendant Hardberd John merchant 615438 615438 Hardberd, John, of Harwich, merchant 0
5194845 2414237 2414237 defendant Clerk Robert yeoman 615438 615438 Clerk, Robert, of Harwich, yeoman 0
5208963 2418350 2418350 defendant Clerk Robert yeoman 615438 615438 Clerk, Robert, of Harwich, yeoman 0
5235449 2425946 2425946 defendant Burwell John, junior   615438 615438 Burwell, John, junior, of Harwich, mason 3
5306914 2447067 2447067 defendant Wellys John yeoman 615438 615438 Wellys, John, of Harwich, yeoman 0
5476682 2498022 2498022 defendant Parker William mariner 615438 615438 Parker, William, of Harwich, mariner 1
5476686 2498023 2498023 defendant Parker William mariner 615438 615438 Parker, William, of Harwich, mariner 1
5584830 2530333 2530333 defendant Harrys William merchant 615438 615438 Harrys, William, of Harwich, merchant 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);