names

139 rows where place_id = 589622

✎ 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
3598201 1867068 1867068 defendant Borne George sherman 589622 589622 Borne, George, of Horsham, Sussex, sherman 0
3598204 1867069 1867069 defendant Borne George sherman 589622 589622 Borne, George, of Horsham, Sussex, sherman 0
3619405 1873645 1873645 defendant Banaster John yeoman 589622 589622 Banaster, John, of Horsham, Sussex, yeoman 0
3625515 1875519 1875519 defendant Wodsell Richard draper 589622 589622 Wodsell, Richard, of Horsham, Sussex, draper 2
3690324 1923136 1923136 defendant Hurst Nicholas smith 589622 589622 (Hurst, Nicholas, of Horsham, Sussex, smith 1
3690328 1923137 1923137 defendant Hurst Nicholas smith 589622 589622 (Hurst, Nicholas, of Horsham, Sussex, smith 1
3782659 1952317 1952317 defendant Hoke Thomas yeoman 589622 589622 Hoke, Thomas, of Horsham, Sussex, yeoman 3
3824177 1965439 1965439 defendant Michell Elizabeth widow 589622 589622 Michell, Elizabeth, of Horsham, Sussex, widow 0
3851688 1974115 1974115 defendant Mychell Richard   589622 589622 Mychell, Richard, of Horsham, Sussex 0
3902840 1991183 1991183 defendant Michell John yeoman 589622 589622 Michell, John, of Horsham, Sussex, yeoman 0
3919374 1996812 1996812 defendant Durrant Robert dyer 589622 589622 Durrant, Robert, of Horsham, Sussex, dyer 0
3937864 2002995 2002995 defendant Sharpe Robert yeoman 589622 589622 Sharpe, Robert, of Horsham, Sussex, yeoman 0
3943580 2004872 2004872 defendant Harrys Rowland gent 589622 589622 Harrys, Rowland, of Horsham, Sussex, gent 0
3943932 2004989 2004989 defendant Bradbryge John gent 589622 589622 Bradbryge, John, of Horsham, Sussex, gent 0
3945142 2005395 2005395 defendant Jenden John chapman 589622 589622 Jenden, John, of Horsham, Sussex, chapman 1
4054029 2043822 2043822 defendant Moncke Robert chapman 589622 589622 Moncke, Robert, of Horsham, Sussex, chapman 0
4054031 2043823 2043823 defendant Moncke Robert chapman 589622 589622 Moncke, Robert, of Horsham, Sussex, chapman 0
4056279 2044631 2044631 plaintiff Bradbridge Henry gent 589622 589622 Bradbridge, Henry, of Horsham, Sussex, gent 0
4056282 2044632 2044632 plaintiff Bradbridge Henry gent 589622 589622 Bradbridge, Henry, of Horsham, Sussex, gent 0
4056640 2044764 2044764 plaintiff Brodbridge Henry gent 589622 589622 Brodbridge, Henry, of Horsham, Sussex, gent 0
4208075 2098384 2098384 defendant Wyking Henry chapman 589622 589622 Wyking, Henry, of Horsham, Sussex, chapman 1
4236635 2108387 2108387 defendant Ingrame John yeoman 589622 589622 Ingrame, John, of Horsham, Sussex, yeoman 0
4456487 2187047 2187047 defendant atte Parye Adam dyer 589622 589622 atte Parye, Adam, of Horsham, Sussex, dyer 0
4456491 2187048 2187048 defendant Perye Adam atte dyer 589622 589622 Perye, Adam atte, of Horsham, Sussex, dyer 0
4517354 2205829 2205829 defendant Terry Roger esq 589622 589622 Terry, Roger, of Horsham, Sussex, esq 0
4517356 2205830 2205830 defendant Terry Roger esq 589622 589622 Terry, Roger, of Horsham, Sussex, esq 0
4571518 2222671 2222671 defendant Bole Thomas chapman 589622 589622 Bole, Thomas, of Horsham, Sussex, chapman 0
4722377 2272317 2272317 defendant Stryche John yeoman 589622 589622 Stryche, John, of Horsham, Sussex, yeoman 6
4744123 2278806 2278806 defendant Elyot William victualler 589622 589622 Elyot, William, of Horsham, Sussex, victualler 4
4744145 2278813 2278813 defendant Elyot William, senior victualler 589622 589622 Elyot, William, senior, of Horsham, Sussex, victualler 4
4746538 2279480 2279480 defendant Waller John yeoman 589622 589622 Waller, John, of Horsham, Sussex, yeoman 0
4748126 2279963 2279963 defendant Gartrum Richard husbandman 589622 589622 Gartrum, Richard, of Horsham, Sussex, husbandman 0
4748128 2279964 2279964 defendant Gantrim Richard husbandman 589622 589622 Gantrim, Richard, of Horsham, Sussex, husbandman 0
4841936 2309013 2309013 defendant atte Hille Thomas husbandman 589622 589622 atte Hille, Thomas, of Horsham, Sussex, husbandman 0
4841940 2309015 2309015 defendant atte Hille Thomas husbandman 589622 589622 atte Hille, Thomas, of Horsham, Sussex, husbandman 0
4842327 2309131 2309131 defendant Skynner John skinner 589622 589622 Skynner, John, of Horsham, Sussex, skinner 0
4848983 2311148 2311148 defendant Broker William   589622 589622 Broker, William, of Horsham, Sussex, stone haulier 0
4848986 2311149 2311149 defendant Broker William   589622 589622 Broker, William, of Horsham, Sussex, stone haulier 0
4860044 2314511 2314511 defendant Urry Walter gent 589622 589622 Urry, Walter, of Horsham, Sussex, gent 0
4877785 2320014 2320014 defendant Broker Richard   589622 589622 Broker, Richard, of Horsham, Sussex, "stonehelyer" or stone roofer 0
4894876 2325059 2325059 defendant Blast Reginald chapman 589622 589622 Blast, Reginald, of Horsham, Sussex, chapman 2
4915560 2331367 2331367 defendant Hunt Thomas chapman 589622 589622 Hunt, Thomas, of Horsham, Sussex, chapman 0
4915563 2331367 2331367 defendant Porter John chapman 589622 589622 Porter, John, of Horsham, Sussex, chapman 3
4915568 2331369 2331369 defendant Junt Thomas chapman 589622 589622 Junt, Thomas, of Horsham, Sussex, chapman 0
4917058 2331842 2331842 defendant Walle William chapman 589622 589622 Walle, William, of Horsham, Sussex, chapman 2
4993461 2354913 2354913 defendant Walker William yeoman 589622 589622 Walker, William, of Horsham, Sussex, yeoman 0
5002706 2357705 2357705 defendant Hunte Thomas chapman 589622 589622 Hunte, Thomas, of Horsham, Sussex, chapman 1
5002711 2357706 2357706 defendant Hunte Thomas chapman 589622 589622 Hunte, Thomas, of Horsham, Sussex, chapman 1
5002712 2357706 2357706 defendant Rycall (illegible) chapman 589622 589622 Rycall, _, of Horsham, Sussex, chapman 2
5006746 2358870 2358870 defendant Storker John chapman 589622 589622 Storker, John, of Horsham, Sussex, chapman 0
5019600 2362621 2362621 defendant Barbour William barber 589622 589622 Barbour, William, of Horsham, Sussex, barber 0
5039914 2368581 2368581 defendant Waller William yeoman 589622 589622 Waller, William, of Horsham, Sussex, yeoman 0
5083918 2381692 2381692 defendant Waller John drover 589622 589622 Waller, John, of Horsham, Sussex, drover 4
5091835 2383994 2383994 defendant Stoner John yeoman 589622 589622 Stoner, John, of Horsham, Sussex, yeoman 2
5103648 2387493 2387493 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 0
5103651 2387494 2387494 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 0
5107421 2388602 2388602 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 0
5107425 2388603 2388603 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 0
5112632 2390082 2390082 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 0
5114716 2390718 2390718 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 0
5115967 2391099 2391099 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 0
5117247 2391477 2391477 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 1
5117250 2391478 2391478 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 1
5117791 2391634 2391634 defendant Pechard John dyer 589622 589622 Pechard, John, of Horsham, Sussex, dyer 4
5123103 2393189 2393189 defendant Waller William husbandman 589622 589622 Waller, William, of Horsham, Sussex, husbandman 0
5130223 2395325 2395325 defendant Hertley Thomas clerk 589622 589622 Hertley, Thomas, of Horsham, Sussex, clerk 1
5142083 2398805 2398805 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, sussex, esq 0
5149550 2400997 2400997 defendant Hertley Thomas clerk 589622 589622 Hertley, Thomas, of Horsham, Sussex, clerk 1
5163241 2404980 2404980 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 0
5184045 2411067 2411067 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 0
5184709 2411276 2411276 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 1
5191776 2413332 2413332 defendant Waller William drover 589622 589622 Waller, William, of Horsham, Sussex, drover 3
5207345 2417889 2417889 defendant Waller William drover 589622 589622 Waller, William, of Horsham, Sussex, drover 3
5218375 2421106 2421106 defendant Bacheler William yeoman 589622 589622 Bacheler, William, of Horsham, Sussex, yeoman 1
5224039 2422715 2422715 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 0
5231988 2424925 2424925 defendant Waller William yeoman 589622 589622 Waller, William, of Horsham, Sussex, yeoman 0
5244856 2428669 2428669 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 1
5244863 2428671 2428671 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 1
5251990 2430725 2430725 defendant Mauncell Thomas yeoman 589622 589622 Mauncell, Thomas, of Horsham, Sussex, yeoman 0
5272551 2437047 2437047 defendant Hurst Robert smith 589622 589622 Hurst, Robert, of Horsham, Sussex, smith 0
5278134 2438699 2438699 defendant Herst Robert smith 589622 589622 Herst, Robert, of Horsham, Sussex, smith 0
5278140 2438700 2438700 defendant Herst Robert smith 589622 589622 Herst, Robert, of Horsham, Sussex, smith 0
5279824 2439180 2439180 defendant Coweper Richard chapman 589622 589622 Coweper, Richard, of Horsham, Sussex, chapman 3
5279845 2439186 2439186 defendant Cowper Richard chapman 589622 589622 Cowper, Richard, of Horsham, Sussex, chapman 0
5286486 2441052 2441052 defendant Reem William chapman 589622 589622 Reem, William, of Horsham, Sussex, chapman 1
5286489 2441053 2441053 defendant Reem William chapman 589622 589622 Reem, William, of Horsham, Sussex, chapman 1
5298847 2444644 2444644 defendant Waller William, sen yeoman 589622 589622 Waller, William, sen, of Horsham, Sussex, yeoman 0
5329322 2453853 2453853 defendant Snellyng Richard yeoman 589622 589622 Snellyng, Richard, of Horsham, Sussex, yeoman 0
5334640 2455426 2455426 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 0
5334890 2455503 2455503 defendant Nyter William husbandman 589622 589622 Nyter, William, of Horsham, Sussex, husbandman 1
5342942 2457984 2457984 defendant Wodesell Richard yeoman 589622 589622 Wodesell, Richard, of Horsham, Sussex, yeoman 2
5342947 2457985 2457985 defendant Wodesell Richard yeoman 589622 589622 Wodesell, Richard, of Horsham, Sussex, yeoman 2
5342952 2457986 2457986 defendant Wodsell Richard yeoman 589622 589622 Wodsell, Richard, of Horsham, Sussex, yeoman 2
5345330 2458712 2458712 defendant Hoo Thomas esq 589622 589622 Hoo, Thomas, of Horsham, Sussex, esq 0
5346667 2459111 2459111 defendant Waller Richard tanner 589622 589622 Waller, Richard, of Horsham, Sussex, tanner 0
5359410 2462978 2462978 defendant Wodesell Richard draper 589622 589622 Wodesell, Richard, of Horsham, Sussex, draper 1
5360779 2463403 2463403 defendant Maunsell Thomas husbandman 589622 589622 Maunsell, Thomas, of Horsham, Sussex, husbandman 0
5360784 2463404 2463404 defendant Maunsell Thomas husbandman 589622 589622 Maunsell, Thomas, of Horsham, Sussex, husbandman 0
5361901 2463747 2463747 defendant Selde Richard yeoman 589622 589622 Selde, Richard, of Horsham, Sussex, yeoman 1
5365033 2464735 2464735 defendant Wodesyll Richard draper 589622 589622 Wodesyll, Richard, of Horsham, sussex, draper 0

Next page

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);